Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Setting field in table to user input

Setting field in table to user input

Setting field in table to user input

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 :)

RE: Setting field in table to user input

How are you automatically importing your text?  If it is through code, use an InputBox to get the date from the user.  If you are importing it into an existing table, then change the default property of the field to the input date prior to the import.

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close