Search results

hi there; i am trying to enter the date in a box of a form (in datasheet view) using a macro. as soon as the box is clicked, the date must be entered into the box. i have been able to do this before using macros but i have forgotten how to do it! which action do i use when creating the...

i have got it working: the date is entered on click and =IIf([DATE IN]<=Date(),Yes) enters the returned tick. do you know how to modify the iif formula so there can be manually override? or is this not possible. thanks for the link to the tutorial (im sure it will come in useful!)...

and how do you get a form to auto enter the date when the returned box is ticked? and how do you get a form to select data with a specific field from one table (ie a persons name).

using a form: will it retain the current values? also, what do i do with the code: If Len(Me.DateControlNameHere & vbNullstring) = 0 Then Me.DateControlNameHere = Date End If

thanks for the input: as far as coding goes, im a complete noob. this is the most advanced stuff ive done (we are only taught basic querys and tables at school and ive only used access in the last 6 months). the table has 980 records and is used constantly. every person has their own query which...

i use a checkbox because of other querys (to see what has been issued/ not returned) hence why auto entry of date is required. the problem is that it updates everything, it does not keep the current values. the iif formula solves part but not all of the problem

hi there; i am working on a database that logs kit (ie what people have, when it went out of the store room and when it was brought back). at the moment, i need to click on the "returned" yes/no field then enter the date. i want the date to be auto entered when the returned field is ticked...