Search results

No, I'm not saying that. I just don't know what I'm doing. Clearly. I can follow instructions, I just don't know how to use what I've been tasked with using. I'm not familiar with the terminology so have to guess a lot. I started following the instructions from the Microsoft article ... ...

Ok .. hope I'm doing the right thing here.. exported to Excel and attached. Thank you for your patience.

Ack ... no, I hadn't. I forgot I'd removed it when the macro was erroring. I've replaced it ... with its Data Type as Date/Time (is that right?), and gone back into the form and made sure that the controlsource is that field, LastModified. I still get the same error. (Next time my manager...

Yes. I started from scratch .... inserted a new text control, renamed it from Text2354 to LastModified, inserted the code precisely as you directed, and when I attempt to save I get the same error as I described above which began "The expression Before Update you entered as the event property...

I've taken a screen shot of what that window looks like when I paste the code (and yes, I pasted all three lines of it). Is this right?

Umm ... no, not putting it in Properties. I went to Database Tools/Visual Basic, and pasted it in there. Isn't that right? Isn't that the "VBA window"? I didn't even think of going into the form and to its properties ... I wouldn't even know where to put it in there. When I follow your...

Ok, I updated something, and now I get: "Compile error: Method or data member not found"

Oh nuts. I misunderstood ... you were telling me what to do next. Sorry. I'll see if I can figure out how to do that. /smacks self up side of the head.

I'm afraid I don't know how to do that, but thank you. In any case, I've removed the offending macro from the form, because I couldn't save any edits, and I had to keep working in it. It contains ~3,600 records, and I'm in the process of adding/editing ~500 more. I stopped by here yesterday to...

I'm afraid not. It doesn't look quite like the same thing. But thank you.

Yes. I've appended your code. Just not quite sure what to do next. :)

I followed the instructions from Microsoft (h t t p : / / office.microsoft.com/en-us/access-help/store-the-date-and-time-when-a-record-is-modified-HA010342039.aspx) to include a "Last modified" date on a form. I did this, oh, several years ago and it's been working just fine. Access 2010, XP...

I believe so. It's in a corporate environment where these things are all pushed through from the network. .... A quick check has shown that Service Pack 3 has been applied. Thanks.

It's just a text field containing a date qualifier. I changed the Back Style property to Normal, and it's now behaving like all the other field labels, ie: the layering effect is gone. Thank you! I wasn't aware of that property, so I've learned something. Weird .. the person who normally uses...

I'm using it as is, at its current location. It will remain on this machine, and there is currently no option to upgrade to 2010 (so no point playing with it on another machine with 2010). Thanks.

I've Googled, which landed me here, and then searched on this forum, but the key words which describe my problem are not bringing me answers. I have inherited a database from a work colleague, which runs on a machine with Office 2003. One of the text labels on a field is behaving oddly. As I...