I gang

MS Access Template Modification

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

Færdigheder: Excel, Microsoft Access

Se mere: access template modification, modify access 2010 template, modify access templates, want change fields access template, modification microsoft access, microsoft access templates, modification log template, word find template, why do you want to change jobs, when to change jobs, what to put on your resume, what to put on resume, what to put on a resume, what to put in a resume, what should be on a resume, what not to put on a resume, wanted opening, wanted excel expert, use case simple example, up jobs login, total jobs login, test excel expert, templates in c language, template hour log, should i change jobs

Om arbejdsgiveren:
( 12 bedømmelser ) Asuncion, Paraguay

Projekt-ID: #952847

Tildelt til:

djucuti

Hello, please check PM

$95 USD in 2 dage
(18 bedømmelser)
4.6

10 freelancere byder i gennemsnit $153 for dette job

KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$110 USD in 2 dage
(26 bedømmelser)
4.5
italinobz

Hi, MS Access expert and a Oracle Certified developer. Please see PMB for more details.

$100 USD in 3 dage
(2 bedømmelser)
1.8
YashpalSingh123

Access/php experiened

$250 USD in 3 dage
(0 bedømmelser)
0.0
shyamkasun

I have done several Drupal web projects with my company(Meegua Solutions), and Latest one is www.cubble.nl. We do Logo designing, theme making and custom module based on the customer requirements. Please Mere

$230 USD in 2 dage
(0 bedømmelser)
0.0
hkit711

I will do the job, it's almost the same as i did to my boss...

$200 USD in 2 dage
(0 bedømmelser)
0.0
sccharikaemoney

i will anticipation complete your work as my best and time.

$150 USD in 2 dage
(0 bedømmelser)
0.0
eldiablopHp

Hi. Please check your PMB. Thanks.

$200 USD in 2 dage
(0 bedømmelser)
0.0
takitsolutions

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

$100 USD på 1 dag
(0 bedømmelser)
0.0
alfredcadungog

I hope i can help you though your project.

$99 USD på 1 dag
(0 bedømmelser)
0.0