Cannot set value via event


R

redFred

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
Ad

Advertisements

M

MikeJohnB

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
 
R

redFred

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



MikeJohnB said:
Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
M

MikeJohnB

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



MikeJohnB said:
Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
M

MikeJohnB

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



MikeJohnB said:
Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
R

redFred

Yes, I am aware of that.

MikeJohnB said:
By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
Ad

Advertisements

M

MikeJohnB

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Yes, I am aware of that.

MikeJohnB said:
By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
R

redFred

Still? I have gotten no suggestions as to what could be my issue.




MikeJohnB said:
Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Yes, I am aware of that.

MikeJohnB said:
By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
M

MikeJohnB

I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Still? I have gotten no suggestions as to what could be my issue.




MikeJohnB said:
Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
M

MikeJohnB

I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Still? I have gotten no suggestions as to what could be my issue.




MikeJohnB said:
Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
R

redFred

For a test you need three forms.

1. Stand alone with update control, bound, button to call #2.
2. Stand alone popup, bound.
3. Subform of #2, bound. A control's event (any, but I want BeforeUpdate)
contains the code referencing #1 form update control for "=Now()".

Did you specifically test this way?

MikeJohnB said:
I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Still? I have gotten no suggestions as to what could be my issue.




MikeJohnB said:
Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
Ad

Advertisements

R

redFred

Did you see my reply of 10:06 AM PST?

Is the code you are calling it from in an event?
Is that event on a subform of the form you are calling it from?

See my most recent response prior to this.

MikeJohnB said:
I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
R

redFred

Got it!

The subform was (at one time) bound to a query. Today it was bound to a
table. The query included the LastUpdate field for the client. Once that
change was made...voila! Success.

Thanks.


MikeJohnB said:
I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
M

MikeJohnB

Phewwww, been trying to replicate your problem, got all sorts of forms,
popup, bound, unbound subforms etc in the trial Database.

However, really glad you have got to the bottom of the issue. I can now
relax to my sick bed. Got one Bitch of a cold.

All the very best fred

Best wishes for the Holiday and Happy New Year

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Got it!

The subform was (at one time) bound to a query. Today it was bound to a
table. The query included the LastUpdate field for the client. Once that
change was made...voila! Success.

Thanks.


MikeJohnB said:
I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 
Ad

Advertisements

M

MikeJohnB

Don't know what happened to my Reply,

Glad you got to the bottom of the issue now, Got all sorts of tables,
Queries, forms, subforms, popup forms on the trial database here but couldn't
find the problem.

Have a really good Holiday Fred and a happy 2009

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


redFred said:
Got it!

The subform was (at one time) bound to a query. Today it was bound to a
table. The query included the LastUpdate field for the client. Once that
change was made...voila! Success.

Thanks.


MikeJohnB said:
I have

Private Sub Command15_Click()

Forms!Test_Colour!UpDate = Now()

End Sub

This sets a Bound control (Update) to date

It is a completly seperate form to where the code is being fired from.

Perhaps I am not really understanding the issue you have.

I'm really sorry to have cause you a delay

I suggest you repost with the same problem

Kindest regards and seasons greetings

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


MikeJohnB said:
I'm really sorry Fred, cant seem to replicate your error here, have tried

Forms!Test_Colour!Text17 = Now()

Which works a treat

The form Test_Colour has a text box Text17 and the above code sets that.

I will try it with a bound control

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Still? I have gotten no suggestions as to what could be my issue.




:

Have you still got the same issue with the code?
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, I am aware of that.

:

By the way, Now() will give you both a date and time stamp, if you only want
a date, then = Date() only returns the date portion?

Kindest regards

Cannot see anything else wrong with your code, let me know how you get on?????

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Forms![1frmclient].Form!txtLastUpdate = Now()

() ??????

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Yes, thanks.

Forms![1frmclient].Form!txtLastUpdate = Now

Like I stated...in any event as the only code.



:

Can you post the code that is being used to perform the update?

Forms!MainFormName.UpdateControlName = ??????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


:

Happy Holidays and thanks for helping.

I have a main form that has a control to record last update to it or another
form/subform.

[frmClient]-user clicks button to display [frmClientUpdate].
[frmClientUpdate]-popup, not subform.
[frmClientUpdate]![subforms] - contain controls,bound, to update data. There
are several, behavior is common to all.

I am unable due to the error 2448 to update the last update control on
[frmClient] when I make a change to a control on [frmClientUpdate]![subform].

[frmClient] last update control works fine when tested at [frmClient] and
[frmClientUpdate] and the [frmClientUpdate]![subform] source object form.

However, when I add the same updating code to [frmClientUpdate]![subform]
event (any subform, any event) I get runtime error. I am attempting to use
the BeforeUpdate event to test Value vs OldValue.

The subform's form open event will update [frmClient] last update correctly.
Any subform's control, any event will fail 2448 cannot update.

Does anyone see a solution? I have Compacted/Repaired, rebuilt and no joy.
I am at a loss.

Thanks.
redFred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top