Setting field in table to user input
Setting field in table to user input
(OP)
I am a MIS student working on a work-study database project. For this DB, I automatically import a text file into a table each week. I wish to allow the user to define the date of the information to go into a field. I know how to format the field for today's date, however this won't work if the user cannot import data each Friday since I then query the table by date. (This is a database regarding timecard information). I was hoping to have an input box of somekind that could be linked to the field, but so far Access doesn't like my code - Is it possible to define a input in a table?
If anyone could help me that would be great!
- Kerryn :)
If anyone could help me that would be great!
- Kerryn :)
RE: Setting field in table to user input
If you are creating a new table every time, use the InputBox to get the date. Then after the import, add a field to the table using the TableDef object. Then run an update query to put the date in the field.
Let me know if that sounds like what you want.
Kathryn