S
Steve
I'd like to design a form to record the date and time of visits in the visit
table. I'm looking for information on how to develop a user interface to
make this process very easy for the user. The users are currently using
SharePoint and are able to pick times like 7 AM from a combo box, and then
for examble 15 for the minutes. It evidently stores information from both
combo's in one date field in the table. Can someone tell me how to create
something similar on an Access?
I have a start on it. I created an Hours table with two fields
HoursDescription and HoursValue. I put the integers 1 - 24 in the HoursValue
field and descriptions like 7 AM in HoursDescription. For the minutes table
I used 05, 10, etc. in the Minutes Description field and put the integers 5,
10, etc. in the MinutesValue. I would do something similar with the dates.
Shoud I store this info into different fields of a table and then somehow
combine them as a date and time in a query? How? I'm sure there is probably
a better way. Any advice would be appreciated.
table. I'm looking for information on how to develop a user interface to
make this process very easy for the user. The users are currently using
SharePoint and are able to pick times like 7 AM from a combo box, and then
for examble 15 for the minutes. It evidently stores information from both
combo's in one date field in the table. Can someone tell me how to create
something similar on an Access?
I have a start on it. I created an Hours table with two fields
HoursDescription and HoursValue. I put the integers 1 - 24 in the HoursValue
field and descriptions like 7 AM in HoursDescription. For the minutes table
I used 05, 10, etc. in the Minutes Description field and put the integers 5,
10, etc. in the MinutesValue. I would do something similar with the dates.
Shoud I store this info into different fields of a table and then somehow
combine them as a date and time in a query? How? I'm sure there is probably
a better way. Any advice would be appreciated.