A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatic date



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2010, 09:37 PM posted to microsoft.public.access.gettingstarted
janelgirl
external usenet poster
 
Posts: 8
Default Automatic date

I need to add a field that is the current date to a table, but the date needs
to be updated automatically to always equal the current date. In Excel, this
was easily done with the "TODAY" function, but this isn't working in Access.
When I use "Date()", it returns the date that the record was created, but
does not update to the current date as time passes. In other words, if it
was created on 4/22/10, when I open the table on 4/28/10, I need that field
to read 4/28/10, even though it was created on an earlier date. I hope this
makes sense. Any help is greatly appreciated! Thanks!
  #2  
Old April 28th, 2010, 09:57 PM posted to microsoft.public.access.gettingstarted
Daniel Pineault
external usenet poster
 
Posts: 658
Default Automatic date

Firstly, you should not ever be working directly in your tables, but rather
through a form.

Once you have a form setup you could add a current event to your form to
automatically update your control value.

Me.ControlName = Date()

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"janelgirl" wrote:

I need to add a field that is the current date to a table, but the date needs
to be updated automatically to always equal the current date. In Excel, this
was easily done with the "TODAY" function, but this isn't working in Access.
When I use "Date()", it returns the date that the record was created, but
does not update to the current date as time passes. In other words, if it
was created on 4/22/10, when I open the table on 4/28/10, I need that field
to read 4/28/10, even though it was created on an earlier date. I hope this
makes sense. Any help is greatly appreciated! Thanks!

  #3  
Old April 29th, 2010, 06:51 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Automatic date

On Wed, 28 Apr 2010 13:37:01 -0700, janelgirl
wrote:

I need to add a field that is the current date to a table, but the date needs
to be updated automatically to always equal the current date. In Excel, this
was easily done with the "TODAY" function, but this isn't working in Access.
When I use "Date()", it returns the date that the record was created, but
does not update to the current date as time passes. In other words, if it
was created on 4/22/10, when I open the table on 4/28/10, I need that field
to read 4/28/10, even though it was created on an earlier date. I hope this
makes sense. Any help is greatly appreciated! Thanks!


A table should contain only real, static data. You can display today's date in
a Query, or in the control source of a textbox on a Form or Report, using the
Date() function. You cannot do so (and should not do so, because no such
field should exist!) in a Table.
--

John W. Vinson [MVP]
  #4  
Old April 29th, 2010, 02:24 PM posted to microsoft.public.access.gettingstarted
janelgirl
external usenet poster
 
Posts: 8
Default Automatic date

Thanks for the help! On a side note, why should I not work directly in my
tables? I am new at this, so I don't want to do anything that would create
issues down the road.

Thanks - janelgirl

"Daniel Pineault" wrote:

Firstly, you should not ever be working directly in your tables, but rather
through a form.

Once you have a form setup you could add a current event to your form to
automatically update your control value.

Me.ControlName = Date()

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.




  #5  
Old April 29th, 2010, 02:25 PM posted to microsoft.public.access.gettingstarted
janelgirl
external usenet poster
 
Posts: 8
Default Automatic date

This really helped - Now I see what you mean by not having data in your
tables that changes. That clears up a lot of things for me. :-)

"John W. Vinson" wrote:

On Wed, 28 Apr 2010 13:37:01 -0700, janelgirl
wrote:



A table should contain only real, static data. You can display today's date in
a Query, or in the control source of a textbox on a Form or Report, using the
Date() function. You cannot do so (and should not do so, because no such
field should exist!) in a Table.
--

John W. Vinson [MVP]
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.