That would definitely be a good idea for a template/seminar. I'll add it to the list. I'm sure you COULD build something like that after having completed my course - even just up through the Expert series. But yeah, I could see that being a helpful template.

If anyone else is interested, click the LIKE button on this comment. That's how I gauge user interest. More likes = more likely I'll build it soon. :)

I've been working in Access for around 20 years now. I've just found your site about a year ago. I've just begun watching your Access 2010 Beginner Series. Figured it would be a good refresher and I might even be reminded of things I'm not doing in the best manner. A way to clean up any bad habits I may have developed over the years.

Thanks for putting the idea on your list. Here's to hoping it gets lots of likes and becomes a seminar.

I have changed careers and was hired to maintain an Access DB but that quickly changed to "we need you to Develop".  I had never worked with Access. Now we all know that takes time, more than 8 months of working with Access. I have had no training from the person who built the DB. I took a couple of classes and have been doing your videos. One of the projects that I have been handed is developing a Vacation DB for about 1000 employees. I have pecked around with this for several months and have only gotten a few tables and forms and queries to work together. My boss who is not a DB or IT person, is expecting me to produce something by the end of the year.

Hey Lisa, you should be able to do this with either a module + an update query manually or with record sets. Record sets are probably out of your current scope.

Update Queries may be able to help you. Basically just make an if/then statement in a module to tell it how many hours to give to all of your employees based on start date (if they have varying amounts), and then tell it what to do with any that's already in there before you run it (if PTO <> 0 then PTO = PTO + NewHours kinda thing). Then just manually run it when it's time to add new PTO time.

Alternatively, I'm not sure how soon Rick has this on the table, but there is also AccessDev.NET as an option.

It's definitely on the list. It's not on top, but it's on there. I've never done this kind of a database before, so I need to know what kinds of crazy rules ya'll have for giving and using vacation time. Building the database is a piece of cake (for me, at least). Understanding all of the rules are the hard part. Once we have those down, I can code it. I built a payroll system years ago for a client. Didn't know anything about payroll at the time. He gave me a concise list of all the rules, deductions, percentages, etc. and that made it super easy for me. So, Lisa and John, if you guys can give me an EXACT list of what all the rules are, I'd be happy to put something together - and yes, definitely by the end of the year. I think this would sell well as a template.