• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Create a database (1 Viewer)

T

TrangKhanh

Guest
Hi,
I am currently seeking an intership position which I have to create a database. My project is to design a weekly timesheet for all employees to sign in and out on each day, and the users have to enter the information in the system by themselves. The information needed for the table and the form are created and they are just fine. However, there are some problems. First, I could not get the "automatic" fields working. For example, when the users log in, a friendly interface window would pop-up so that the users can enter the time they are in. At the same time, their name, SSN, and current date should be automatically pop-up in the "automatic fields" (users don't have to type in these infor.), but I couldn't figure out how to do this. Another problem is the calculation part. When employees enter their working hours on specific date, the total worked hours should be automatically calculated, but this is not working either. They have to enter the number by themselves, otherwise, nothing is shown up.

I really need your help in order to finish this project. Anyone who knows about this, please help me out. Your help would be greatly appreciated.

Thanks,
KhanhTran
 

Bru

Registered User.
Local time
Today, 01:04
Joined
Nov 12, 1999
Messages
18
I just made a form that does what you have specified in your question. The time entries have not been added but they are just a matter of adding a subform.

I use a similar form for our employees to do time sheets, and another to do expenses. I would be happy to send you something if you still need it.
Bru
 
W

wballard

Guest
Hello. I think I can help with your second problem with the total hours not calculating. I had the same problem, where the totals calculated field just stays blank. Go into your table where the raw data resides, and go to design view. Then, highlight the fields where the hours are being logged. Make sure that those fields are tagged as number and not text in the "data type". Make sure that there are no alpha characters in those fields...only numbers. I hope this helps - this plagued me for over a month!!
 

Users who are viewing this thread

Top Bottom