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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter a Multi-value combo box field based on data entered in the 6
Date and hourly time of use 3
Please Help a School do a database 1
Trying to find a students location at a given time 1
Data seperation for form with many fields 7
Dynamcially add a field to a query? 2
Question about LOOK UP 2
Logic for WHERE statement in a combo box? 5

Back
Top