M
MikeQs
Excuse my ignorance, but I've completely forgotten everthing I used to know
with Access and VBA programming (it's been about 5 years since I've used it).
I'm hoping someone can spark my memory!
I have created a table to capture our client's daily attendance to our day
program.
-ID
-Client Name
-Date
-Time In
-Time Out
I also have an existing table with client program authorization information
(including client name, program name, demographic data, active status,etc).
My question is this: I would like to create a user form that will first
prompt the user for a date, and then set-up a input grid that lists all
active clients, the date (input by user), and allows the user to enter a
"time in" and time out." I'm not sure if you would have to create a record
for each (active) client first, and then edit it via the user form
(datasheet), or if you could set it up to display the grid, and write only
records that have time input. Any suggestions?
Thanks mucho!
Mike
with Access and VBA programming (it's been about 5 years since I've used it).
I'm hoping someone can spark my memory!
I have created a table to capture our client's daily attendance to our day
program.
-ID
-Client Name
-Date
-Time In
-Time Out
I also have an existing table with client program authorization information
(including client name, program name, demographic data, active status,etc).
My question is this: I would like to create a user form that will first
prompt the user for a date, and then set-up a input grid that lists all
active clients, the date (input by user), and allows the user to enter a
"time in" and time out." I'm not sure if you would have to create a record
for each (active) client first, and then edit it via the user form
(datasheet), or if you could set it up to display the grid, and write only
records that have time input. Any suggestions?
Thanks mucho!
Mike