|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 1st, 2003, 02:54 AM
|
|||
|
|||
|
Updating a record with now() in access
Hi,
I am in the process of making a program which keeps tracks of bags we have coming in and out of work here. I have basically got 3 columns in tables with Bag_id, In_Date, Out_date I can get the In_date value to be auto inputted via default value field in the table structure. What I can't seem to do is to get the Out_date field to be updated in form every time a bag_id is entered in the Logout Bag form. Can anyone point me to the right direction?
|
|
#2
October 3rd, 2003, 12:23 PM
|
||||
|
||||
|
give this a shot. this would just add a date as far as what it is right now() like you wanted but it uses the date() function. let me know if it works
Code:
insert into table1 (date_out) values (date());
__________________
My brain cells are like a storm trooper's armor: useless
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Updating a record with now() in access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
