Give Me A Clue Please

H

HappyGilmore

Is it possible to obtain a dynamic time stamp from my computer and
access data accordingly?
I'm trying to set up a database for 500+ children, establishing where
they are to the minute throughout the day, by room number.
I'd like to type the student's name and get a room number where that
child is at that moment without referring to a schedule.

thanks!
 
K

Ken Snell

To get the Time without the date, use Time().

To get both the date and time, use Now().

To get the Date without the time, use Date().
 
H

HSalim

LOL!
he does not want to refer to a schedule, so where is the info coming from?
does each kid have a transponder that transmits location info?
HS
 
H

HSalim

no that is too little information - or it is confusing.
You said earlier that you do not want to look up a schedule. Now I guess
that's OK
What about the time stanp? where does that fit in?

To answer your question,
To display johnny smith's location do the following
1. Add a new text box to your form - call it txtLocation
2. On the text box whre you type Johnny Smith, add code that will look up
the value from the table and display it it in the tetbos
me.txtLocation = Dlookup("room" , "LocationTable", "ChildID = " &
me.ChildID)

Good Luck
HS
 
Top