Current Date and Time functions in Access

P

PSULionRP

Within a text field in Access, can you shortcut the current date and time???
Similar to <CTRL><;> in Excel for the Current Date.

Thanks in advance for your review and help.

PSULionRP
 
T

Tony Toews [MVP]

PSULionRP said:
Within a text field in Access, can you shortcut the current date and time???
Click to expand...

Also in a date field you can just enter either the day and month with
a space between them and Access/Windows will insert the year. Or if
you enter a 4 digit year and a month it will insert the 1 for the 1st
day of the month.

A few developers and testers in the Access product group within
Microsoft were amazed when I told them that trick. One guy, who'd
been around for a while said "Ahhh, it's using OLEAUT32 DLL etc,
etc.". This was all in the context of determining the field type for
new columns when in A2007 table view.

Tony
 

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

Similar Threads

Clearing Immediate Window in a debug session 2
Access Module Listing and printing 2
Access VBA creating an Excel spreadsheet with a total line 5
Query date Parameter Anomaly 4
Application stopping in VBA Module 6
Make Table Query 2
Export Access Query to a pipe delimited .csv file 5
Date search query 0

Top