help

thelostcircuit

New member
Local time
Yesterday, 19:44
Joined
Feb 11, 2005
Messages
6
i have a database that i have been working on for a week or so it is for a tumbling process witch is currently controled by a paper log witch is verry hard to search and also it is susceptible to operator error so i have been asked to make a database to eliminate these problems.

I bought the Access 2003 bible and i have goted throught the table part of the book

ok so this is what i have:

i would like to know how to make a button from a form set a value in a table to now()

and i would also like that same buton add a value to the time that the button inputs

thanks
 

Attachments

  • relationships copy.jpg
    relationships copy.jpg
    41 KB · Views: 133
  • tables.jpg
    tables.jpg
    28.7 KB · Views: 133
You can place a command button on the form or you can add this into the code of an existing button. Place it before the function that the button is designed to perform.

Me![field1] = Me!Now()
Me![field2] = Me!Time()

Everytime the command button is clicked, the date and time will be added to the fields.
 
thanks that helped

now i have been trying to debug my next part

Me![Rinse] = (que_operation.Cut + Timein)

any help ?
 

Users who are viewing this thread

Back
Top Bottom