Search results

Ouch...I feel ridiculous. :eek: Thank you very much, I went in and realized I had not renamed the hidden textbox. Thank you :o

No, getting it when I exit the fields to save the data. The function is: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.txtUpdated = fOSUserName Me.txtDate_Updated = Now() End Sub Without Me.txtDate_Updated = Now() there is no problem

I have it setup in the after update code. date_updated is setup as the field on my form and is hidden - It is tied to the correct field I am updating on the table.

Currently I have a field setup on my form and hidden. I have inputted the code me.txtDate_updated=now() to assign the date that the field was updated. However, now whenever I access the form I receive a Compile error stating "Method or data member not found" Anyone have an idea as to what...

Still receiving "Method or data member not found" ...Any help would be greatly appreciated.

Anyone?.... :confused:

Any update... Currently I h ave the field setup on the form and hidden and the me.txtDate_updated=now() and that is what is causing the compile error.

Okay...got the before update item resolve. In terms of the date_updated - I have been getting a Compile error stating "Method or data member not found"

Believe is stopped working last time I tried that, but I will check again. Thank you for that feedback. Any idea on the actual date field?

I have a form where I am currently showing the last updated user with the following code: Private Sub Form_Current() Me.Updated = fOSUserName End Sub I would like to add another field Date_Updated that shows the day that the record was updated. So far me.txtDate_Updated = date() has given me...

Same, been trying to figure this out all day! Very glad I ran across this board. :D

Finally! Thank you so much for your extremely prompt response and patience! :D

That's my table. If I just do: Private Sub Form_Current() Me.Updated = fOSUserName End Sub Then I get: Compile Error Method or data member not found.

I put this in the event procedure box: Private Sub Form_Current() WFH_Actives.Updated = fOSUserName End Sub Now I get a runtime error 424.

Bob, When doing that I received the following error in running the actual form "Microsoft Office Access can't find the macro 'Me'."

I have a form that I need to return the value of a fOSUserName() function back to the table so that I know the username of the person who last updated a record. I have been able to display the username on the form with the function, but have not been able to figure out how to assign the value...