By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,639 Members | 1,988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,639 IT Pros & Developers. It's quick & easy.

Help on building a flat schedule for 50 to 100 plus employees

P: 2
We have this database to track all our employees. I am trying to build a 14 day schedule to track all employees appointments leaves etc... I am sure this needs to be done in vba code but I am not that familiar with programming. I have an attached database if some one could lend me a hand figuring this out. I have two forms schedule and schedule2. I am need to make a flat schedule not listing everyone twice or more when they have different appointment and how could I list more than one appoint in a listbox. Form Schedule shows an example with info. I will also be breaking this down to 3 shifts with master view looking at all shifts broken down. This product needs to be printed for those who perform rollcalls for each shift. I will also need to move people around from shift to shift. The break down of each shift will be supervision at the top then crew1, crew2, crew3, etc... each crew consist of 4 employees supervision is 2 to 6.
Attached Files
File Type: zip Employee Tracker.zip (471.5 KB, 46 views)
Sep 13 '09 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 1,287
Answering questions is one thing, but don't expect anyone here to build your application for you. There are websites where you can hire programmers like ScriptLance.
Sep 14 '09 #2

NeoPa
Expert Mod 15k+
P: 31,487
I support that last comment.

We freely offer our time to answer specific technical questions. Your question is more a request for unlimited & ongoing help with your project. You can check out the posting guidelines in the Help section available on every page of the site.
Sep 14 '09 #3

P: 2
Not looking for anyone to build the database... Just some help with the schedule form I started. I can figure things out for myself if someone has a code ideal to compair the Name field and pull the schedule across only showing one Name and everyday they have appointments. My bad for posting my database before being asked and but felt easier to show what I am trying to do than explain my somewhat working copy as everyone's info and I am able to email appoint reminders. Thanks for your comments will continue to search for something they may be doing something close to what I am trying to do.
Sep 15 '09 #4

NeoPa
Expert Mod 15k+
P: 31,487
Posting the database is not the problem. It is the nature of the question. It is simply too general and open-ended. We try to avoid such questions as they tend to tie us up for hours on a single poster. This doesn't work very well when you have a whole forum full of questions to try to cover.
Sep 15 '09 #5

Expert Mod 2.5K+
P: 2,545
Further to what my site colleagues have advised you, from what you have told us of your requirements the tasks you are asking assistance on are decidedly non-trivial! Setting up a calendar to record appointments and so on is difficult enough (see this 143-entry thread for examples), never mind moving appointments etc.

Seems like potentially many tens (if not hundreds) of hours work is involved (much more than you may think there is), and as NeoPa already said it is too open-ended a task for us to assist in such a general way. Posting the DB does not assist in such circumstances, as to understand someone else's project itself takes a time investment which we as volunteers assisting posters just don't have in such an open-ended way.

The way you describe some of your requirements makes me think this is student project work - but whatever the source, it is just too much for us to handle in the way you have presented it.

Good luck with your project anyway.

-Stewart
Sep 15 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.