function to return Date/Time

[dsmaj]

Hey, I've got a Date/Time field in a table that I would like to populate with the Current Date/Time. Is there a VBA function that will return the current date/time in a format that the tables Date/Time field-format will like?

I really wish there was some sort of topical VBA function reference--anyone have any links to something like that?

Thanks,
sam

 

[Rich]

=Now() as the default value for the control or in vba

 

[dsmaj]

Perfect. Thanks Rich!

Sam.

 

[dsmaj]

Open Access Help to the Contents tab and drill down. You will find different topics depending on whether you open help from the Access container window or from the VBA code window. In either case, there is a great deal of information that just doesn't seem to pop up when searching.

Woah! Good tip... I recomend everyone that doesn't know about this check it out. There's tonnes of stuff in there that just doesn't get returned by the search...

Thanks Pat,
Sam.