Help to input data (1 Viewer)

Bonowox

New member
Local time
Today, 14:12
Joined
Jun 13, 2018
Messages
8
Hello guys!

For the first time I'm on the forum and I'm greeted all of you.
I also note that I am a beginner in access so do not be surprised with some of my questions (or at least do not laugh at me).
I have a problem I can not solve.

How can I put in "date_to" columns, in fields that are empty, to enter current date date (), and to keep dates in other fields as I entered it.

Thank you!
 

Attachments

  • Slika access.PNG
    Slika access.PNG
    12 KB · Views: 32

Bonowox

New member
Local time
Today, 14:12
Joined
Jun 13, 2018
Messages
8
Thanks, I'll try.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:12
Joined
May 7, 2009
Messages
19,169
edit your Table.
click on Date_To field.
set its Default Value property to: Date().
this will save the Current Date for New records you will enter in the table.

For old records with blank Date_To, see post #2.
 

Users who are viewing this thread

Top Bottom