I need a modification to a current very popular MS Access template.
The template is available there:
[url removed, login to view]:TC101898281|
(Search Time Tracking in Office templates) if you dont find it by that link.
But any other template can be used if you know a better one or already heavily modified that one.
I basically need to be able for a user to input his time worked on a specific event. He has to report this on 15 minute periods, over a working way.
Please downloaded the above template to see what Im talking about.
The template currently selects "Start" date and "End" Date. Which is ok. But I need it to auto fill time based on 15 minutes periods instead.
That means the "Start" field should fill automatically the date and time, but the End field, in this case doesn't need to fill a date+time. Its should auto fills the time only, taking the Start field in 15 minutes periods.
Example. The start field is:
2/17/2011 10:44:25 AM
When you go to the End field it currently is blank. You can select the date from the date picker, but its very cumbersome to then manually change the time each time without making a mystake.
If the Start field was "2/17/2011 10:44:25 AM" then when you go to the End field it show auto populate directly "11:00 AM", if the Start field is for example "2/17/2011 04:16:25 AM" then the End field show auto populate automatically "04:30 AM"
Now if you noticed basically it show fill the end field in 15 minute periods, of course the user has to be able to be able to change this is he wants like "04:35 AM" manually. Now if notice the template actually uses seconds as well. That can be eliminated and its not needed. Time in hour and minute is enough.
The other think is that I added a userlogin box to the template, so basically when opening this Access file, it show a pop up for a username (like other Access templates) and then you choose a username, log in and all the data that is entered is only for that user (tracked for this user). I can modify of course modify all fields, but the user should not, he should only be able to input the data, but not delete data. Thats why a login box should be.
In the reports I should be able to see the user activity per day, week, month and year. For one or all users. And the total hours for each day and in total worked.
I think this is extremely easy to do for anyone that knows MS Access. Even beginners. Since the template is freely available on the Internet, you can download and test it by your needs.
See my description is very long, but just because I wanted to make a detailed description of what I want. Lets go back and resume this again.
Take the template that already exists.
Change the fields and erase seconds, seconds in data are of now use.
Change the end field to auto populate only time but not date, in 15 minutes periods.
Put a login box to this database, only admin (me) can erase data, users can enter data
Users can only input data, not modify or erase once send
Change the report feature to show all activity from a user by day, week, month or year and total hours. Similar to how it does now.
If someone is nice and wants to add a few extras I will likely accept them, like the user maybe could change the input data he send for the last 60 minutes or for that specific day, but not other data
Also I mention that I translated this template (visually for the user) it will be in another language, so you have to be able to tell me all the text fields that can be changed without breaking your mod or the template Sorry but I dont know anything about Access and I need to start learning, but I dont have the time right now, if I change a word I should not not it will stop working. Bidder will get more jobs in the feature.
Thats all, very simple, should not take more then couple of minutes for someone expert in Access, or maybe an hour if you are just learning Access. I mention that is Access 2010
10 freelancers are bidding on average $153 for this job
Hi there, I am a professional database developer and ms access specialist and am sure i can help you in this and am very keen to deliver you the solution . Regards