Vacation Time + Sick Time + Overtime + Time Management

[JK]

I am not a professional access developer; I’ve had zero professional
training. I have however created a couple of really great applications using
MS Access. I was only able to create them because of the sample apps people
post online. I’ve been able to study the examples and various instructional
websites to do what I’ve done.

I’ve now been asked to create an application that will track vacation time,
sick time and overtime in our organization. I thought this was going to be
easy in comparison to the last application I created – but it’s not! There
are many calculations – much VBA code needed to automate certain functions +
SQL, etc. Most of this is over my head.

I wonder if anyone out there would be willing to email me a sample (or
example) application that was designed to track this type of information. I
would be forever grateful. I’m hoping I’ll be able to modify it to meet our
own organizational needs.

I work for a coffee company and would certainly be willing to trade.

I’m using access 2003.

Thanks!
JK
(e-mail address removed)

 

[ghetto_banjo]

Not sure what exactly you need, but if you need help with doing simple
additions and subtractions on time data, take a look at the syntax for
the DateAdd Function and the DateDiff function on this site:

http://www.techonthenet.com/access/functions/date/dateadd.php
http://www.techonthenet.com/access/functions/date/datediff.php

DateAdd will add/subtract time (by seconds, minute, days, whatever)

DateDiff will return the difference in two date/time variable (in
seconds, hours, weeks, whatever)



Those two functions are a lifesaver for working with date/time
variables. if you need more help, be a little more specific on the
type of functions you are having difficulty with in VBA.