Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-14-2018, 04:31 AM   #1
Bonowox
Newly Registered User
 
Join Date: Jun 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Bonowox is on a distinguished road
Help to input data

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!
Attached Images
File Type: png Slika access.PNG (12.0 KB, 6 views)

Bonowox is offline   Reply With Quote
Old 06-14-2018, 04:38 AM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,640
Thanks: 10
Thanked 2,072 Times in 2,027 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Help to input data

You would use an UPDATE query:

https://www.w3schools.com/sql/sql_update.asp

Before you go running any action query (UPDATE, INSERT, DELETE, etc.) make a copy of your database for when you mess up and have to restore it.
plog is offline   Reply With Quote
Old 06-14-2018, 04:44 AM   #3
Bonowox
Newly Registered User
 
Join Date: Jun 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Bonowox is on a distinguished road
Re: Help to input data

Thanks, I'll try.

Bonowox is offline   Reply With Quote
Old 06-14-2018, 04:49 AM   #4
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,136
Thanks: 54
Thanked 1,968 Times in 1,881 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Help to input data

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.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Input Ceas Forms 1 10-20-2013 06:27 AM
Data input help Tark221 Excel 3 10-17-2012 01:56 AM
no data on form, then no data input in subform mafhobb Forms 12 11-24-2011 01:34 AM
Update table with data not in data input form SwanseaAccess Forms 1 10-05-2010 06:00 AM
data input ngeng4 Forms 7 02-23-2010 10:55 PM




All times are GMT -8. The time now is 10:59 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World