Infinite Form

[rrueger]

Hello,
I have recently been assigned the task of Database manager in my department. 3 weeks ago, I've never used access. 3 weeks later and two books, I'm getting the general concepts of access and vba (enough to write simple codes) to create working forms/tables/queries etc.

Okay so I want to change the current "productivity entry" form at work. Currently, employees are faced with a form that basically has
Employee ID:
Date:
Function worked:
Total time worked:
Units worked:

They hit save, the info is added, and they add there next one. the problem is the workers are doing this at the end of the day and its causing them to manually track there hours in excel throughout the day..

I would like to change the form so it basically has

[Text Box 1 Function] [ Text box 2 Start time] [Text Box 3 End Time] [ Text box 4 Units]
Then.. when the user enters data into the boxes, another row below the first appears with the same boxes(and so on and so on).. This way they can leave it open all day and track what they are doing.


Thanks so much for any insight

 

[pbaldy]

Re: Infinate Form

Generally, a form in continuous or datasheet view will show multiple records with a new record at the bottom. I prefer continuous myself.

 

[spikepl]

Re: Infinate Form

I would suggest that you consider what is required in detail, so as to minimise the required user interaction

Does the next period start when the previous ends? Then you can fill in the time automatically
Does the period end, when the user inputs anything? Then the time is Time() , i.e. now
Does a limited number of functions exist? Then use combo to pick one, instead of typing

 

[rrueger]

Thanks for the response! I love when it's something so easy. One question though;

We have multiple users on the database, stored in a tblUsers table.

Is there any way to filter the form so it only shows the information that was posted on the current days date.. for the specific user.

I have a module built in that returns the computer login name FosUserName(). Figure I could filter by that and Date(). Just dont know the code.

 

[pbaldy]

Just base the form on a query that includes those in the criteria.

 

[missinglinq]

Since it hasn't been brought up, and you're a tyro at this, you do understand that with multiple users you'll simply have to split this database, right? The Back End will hold all data/tables and reside on a shared drive, while the Front End will hold everything else, Forms, Queries, Reports, etc, with a copy being placed on each user's hard drive.

Linq ;0)>

 

[rrueger]

The database is split at its current state, but both the front end and back end are on the companies shared drive, not the hard drive.