Access: Form to input dates

25 pts.
Tags:
Access forms
Access Forms Database
Microsoft Access
Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur : Fri and they just fill in the number of hours they worked on each task each day for that week (by default it will be the current week) Is this possible? Thanks in advance for any help!

Answer Wiki

Thanks. We'll let you know when a new response is added.

This could be done; but it would take some work. Because the Mon, Tue, Wed, etc. would not be bound to the table at all. You would need VBA code to insert into the table and also to read from the table to display on the form.

Could you simply have them key the date or pick the date from a calendar and display the day name after the date is entered? You could make a report to display like you are asking.

Another option would be to add the Mon, Tue, Wed… fields to your table in place of the hours. The date field in the table would be the week beginning date that is created behind the screens on your form. Now the fields can be bound to the table. To calculate the actual date, you would use the dateadd function to add x number of days to the weekbeginning date.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Js8765
    Thanks for the ideas Randy. Having read your answer I came across this solution which has VBA to do something similar to what I want to do. I found it helpful. Cheers
    report
  • Js8765
    Strange... the link ended up in my final text and I canĀ“t figure out how to edit the last entry. Anyways...
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following