423,688 Members | 1,889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

Todays Date

P: 1
In Access 2010 can I make a field populate the current date each time the database is opened?

Thanks in advance for any help given.
2 Weeks Ago #1
Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,667
Set the ControlSource to

Expand|Select|Wrap|Line Numbers
  1. =Date()
Hope this hepps!
2 Weeks Ago #2

NeoPa
Expert Mod 15k+
P: 31,084
Just to be clear Ivan, I suspect you're actually asking about a Control on a Form or Report. Fields are another matter and your question would have to specify what you're after more clearly for more accurate and practical help.

If it's simply to show then that works fine - in a Query for instance. If you're looking for an existing field to be updated to reflect the day it was opened last then you need to explain what you want more clearly. Very short questions such as this very rarely give enough information to make proper sense. Some more effort is usually required and expected.
2 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.