Give Me A Clue Please

  • Thread starter Thread starter HappyGilmore
  • Start date Start date
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!
 
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().
 
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
 
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
 
Back
Top