capture today's date

[whatcloud]

thanks!

Thanks pbaldy,

I'm so stupid! Thank you, even although I had set warnings to come up, they didn't, and I hadn't added any trusted places. I just assumed it was because I had no idea what I was doing in VB!!!!

Thanks!

 

[pbaldy]

No problem; that screwed with my head until I figured out what was going on.

 

[BobNTN]

Having had a look at the Student Mgmt database, I figure this could help me out with my problem.
I want a form to have just 2 fields (ID Number & Rec Time).

In the Student Mgmt database the tick box, when checked inserts the current date into the Converted Date field.

What I would like is to have a text box that I can enter the ID Number and when I press enter for it to automatically insert the current time into the Rec Time field.

I tried adjusting the Student Mgmt database, removing the unwanted fields, adding a text box and altering the code in the after update section of Converted date. I managed to get it to insert the correct current time, but it filled all the ID Number records with the same information.


Could anybody please help me out with this dilemma, and possibly build the seemingly simple form for me.

I did something similar to this - I just set the 'Default Value' in the properties of the text box to =Date() which gives the month day and year. You can use =Now() instead then add formatting to it to get just the time if you want.
Example:
=Format(Now(),"dddd"", ""mmm dd yyyy"", ""hh:nn:ss ampm")
will give - Wednesday Feb 6, 2008 12:45:44 AM
I use this for an on screen clock.