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
|
|||
|
|||
Table/Form - Not sure what else to put
I have a form that loads information on to a table "job details" now in this
form i have it displaying a list of cars from another table "courtesy Cars". In the current form i want to be able to select a car and enter the hire dates. thats the easy bit. however i want the hiredates i enter to show in the table untill the car is returned to me. then i want the dates to be deleted fro the form "courtesy cares" but remain in the form Job details. can this be done? |
#2
|
|||
|
|||
Table/Form - Not sure what else to put
On Sun, 26 Oct 2008 12:26:01 -0700, DH010010
wrote: Yes. Presumably when a car is returned you look up that job (which identifies the car) and then you can run an Update query to set those fields to blank. Something like: update tblCourtesyCars set HireDateFrom=Null, HireDateTo=Null where CourtesyCarID = Forms!MyJobDetailsForm!MyCourtesyCarField DoCmd.RunSQL can run this query. -Tom. Microsoft Access MVP I have a form that loads information on to a table "job details" now in this form i have it displaying a list of cars from another table "courtesy Cars". In the current form i want to be able to select a car and enter the hire dates. thats the easy bit. however i want the hiredates i enter to show in the table untill the car is returned to me. then i want the dates to be deleted fro the form "courtesy cares" but remain in the form Job details. can this be done? |
#3
|
|||
|
|||
Table/Form - Not sure what else to put
On Sun, 26 Oct 2008 12:26:01 -0700, DH010010
wrote: I have a form that loads information on to a table "job details" now in this form i have it displaying a list of cars from another table "courtesy Cars". In the current form i want to be able to select a car and enter the hire dates. thats the easy bit. however i want the hiredates i enter to show in the table untill the car is returned to me. then i want the dates to be deleted fro the form "courtesy cares" but remain in the form Job details. can this be done? Ummm... You are aware that nobody here could possibly have any clue how your tables are set up, or where you're storing this information, right? Please give us a little help. I would GUESS that you want to store the hire dates in a related history table, not in your courtesy cars table, but that's purely a guess. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|