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

[btraveler747]

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.

[ChipR]

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.

[NeoPa]

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.

[btraveler747]

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.

[NeoPa]

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.

[Stewart Ross]

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