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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
want to have date from 1 field automatically in another field (but allow edits)
creating db in access 2000, but will ultimately use it on a single machine
using access 2003. I have a table (with forms & reports based on it). I have some fields EntryDate & ActionDate I would like to automatically have the EntryDate entered into the ActionDate, but still allow the user to be able to change the ActionDate after is originally inputted. The scenario is I need to keep the db very simple, when a occupants goes in say Room 1 on 9/6/05 this date would be the EntryDate - this date would rank them on a list for a single room availability (i would want to be able to manually change the ActionDate - if they decline a single room or get their single room revoked at a future date). TIA, _Bigred |
#2
|
|||
|
|||
From _Bigred :
creating db in access 2000, but will ultimately use it on a single machine using access 2003. I have a table (with forms & reports based on it). I have some fields EntryDate & ActionDate I would like to automatically have the EntryDate entered into the ActionDate, but still allow the user to be able to change the ActionDate after is originally inputted. The scenario is I need to keep the db very simple, when a occupants goes in say Room 1 on 9/6/05 this date would be the EntryDate - this date would rank them on a list for a single room availability (i would want to be able to manually change the ActionDate - if they decline a single room or get their single room revoked at a future date). TIA, _Bigred Use the afterupdate event of the EntryDate for: if IsNull(Me.Actiondate) then me.actiondate = me.Entrydate So, when the actiondate = blank, the entrydate is filled in. When the actiondate is already there, nothing happens. |
#3
|
|||
|
|||
I'll try that out and let you know.
Thanks _Bigred "Gijs Beukenoot" wrote in message ... From _Bigred : creating db in access 2000, but will ultimately use it on a single machine using access 2003. I have a table (with forms & reports based on it). I have some fields EntryDate & ActionDate I would like to automatically have the EntryDate entered into the ActionDate, but still allow the user to be able to change the ActionDate after is originally inputted. The scenario is I need to keep the db very simple, when a occupants goes in say Room 1 on 9/6/05 this date would be the EntryDate - this date would rank them on a list for a single room availability (i would want to be able to manually change the ActionDate - if they decline a single room or get their single room revoked at a future date). TIA, _Bigred Use the afterupdate event of the EntryDate for: if IsNull(Me.Actiondate) then me.actiondate = me.Entrydate So, when the actiondate = blank, the entrydate is filled in. When the actiondate is already there, nothing happens. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
converting atomic fields to a single date time field | LAF | Database Design | 2 | May 25th, 2005 05:21 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Update the Date Field | Chris Peikert | Using Forms | 1 | August 27th, 2004 06:27 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |