 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / November 2005Can anyone suggest a good scheduling template for weekly shifts?
Am looking for help in scheduling two teams of five (5) persons....7am to 3pm, and 3pm to 11pm...Mon-Sat. (Sundays off). Furthermore...of the teams of five, the team covering 3pm to 11pm would give up one to cover 11pm to 3am... Major holidays off. (covered by On Call assignments) and minor holidays short staffing. Any suggestions? Am tired of doing it the "way we've always done it!" Thanks I have a week scheduling calendar form/report that could be adapted to do this. Send me an email.  SignaturePC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com If you can't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. Need a month calendar or 7 day calendar? Need appointment scheduling? Need room reservations scheduling? Need employee work scheduling? Contact me! > Am looking for help in scheduling two teams of five (5) persons....7am to > 3pm, and 3pm to 11pm...Mon-Sat. (Sundays off). Furthermore...of the teams [quoted text clipped - 8 lines] > > Thanks How much are you charging? These newsgroups are for free support, not soliciting John... Visio MVP >I have a week scheduling calendar form/report that could be adapted to do >this. Send me an email. >I have a week scheduling calendar form/report that could be adapted to do > this. Send me an email. [quoted text clipped - 3 lines] > Need a month calendar or 7 day calendar? Need appointment scheduling? Need > room reservations scheduling? Need employee work scheduling? Contact me! To the OP: Beware of this guy!! Steve just does *not* care about the newsgroups. He has *no ethics at all*. Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground. -- He abuses this group and others for job-hunting and advertising over and over again -- He is insulting lots of people here when they ask him to stop this -- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions (the latest 'star's': 'Access Resource' and Tom notmy@email.com and Andy) -- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here -- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all': http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en -- Also recently it became clear that he has been spamming innocent people asking questions: http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en So why would ANYBODY ever trust a person like him and hire him? ******************************************************** Explanation and more links on this answer: http://home.tiscali.nl/arracom/stopsteve.html Arno R Ronbo, sorry about the inappropriate solicitation post you received in this thread. the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database. if you don't receive any advice or suggestions from fellow developers in this thread within a day or two, you may want to try posting again in the tablesdbdesign NG, asking for suggestions on what tables/relationships you need, and/or perhaps links to existing templates or "demo" databases to get you started. if you prefer to hire a developer to build your database, there are websites where you can look for contractors. you can find those by googling. hth > Am looking for help in scheduling two teams of five (5) persons....7am to > 3pm, and 3pm to 11pm...Mon-Sat. (Sundays off). Furthermore...of the teams of [quoted text clipped - 6 lines] > > Thanks Thank you....they can solicit all they want, I have no funds for that. > Ronbo, sorry about the inappropriate solicitation post you > received in this thread. the purpose of these unmonitored newsgroups is to [quoted text clipped - 22 lines] > > > > Thanks you're welcome, and good luck with your project! :) > Thank you....they can solicit all they want, I have no funds for that. > [quoted text clipped - 24 lines] > > > > > > Thanks ......the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database...... Where does it say this? > Ronbo, sorry about the inappropriate solicitation post you > received in this thread. the purpose of these unmonitored newsgroups is to [quoted text clipped - 26 lines] >> >> Thanks > ......the purpose of these unmonitored newsgroups is to > offer free assistance, advice, and suggestions from fellow Access > developers, to answer your question(s) and help you build a better > database...... > > Where does it say this? IMO it is better not to argue about this with you. You just don't *want* to know this. Arno R I would not have asked if I did not want to know!!!!!!!!!! Now let Tina answer. "PC Datasheet" <nospam@nospam.spam> schreef in bericht news:niPef.1289$N45.1041@newsread1.news.atl.earthlink.net... > ......the purpose of these unmonitored newsgroups is to > offer free assistance, advice, and suggestions from fellow Access > developers, to answer your question(s) and help you build a better > database...... > > Where does it say this? IMO it is better not to argue about this with you. You just don't *want* to know this. Arno R >I would not have asked if I did not want to know!!!!!!!!!! Why does quoted text not appear as such in your postings? Is this another form of plagiarism? How's this --- "You're a dimwit!" >>I would not have asked if I did not want to know!!!!!!!!!! >> > Why does quoted text not appear as such in your postings? Is this another > form of plagiarism? > How's this --- "You're a dimwit!" So you keep saying but I don't see you providing any evidence in support of your claim. Don't you ever tire of being wrong? > > How's this --- "You're a dimwit!" > > So you keep saying but I don't see you providing any evidence in support of > your claim. Don't you ever tire of being wrong? How would he recognize the alternative? SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >> > How's this --- "You're a dimwit!" >> [quoted text clipped - 3 lines] > > How would he recognize the alternative? It strikes me as being a little scary that someone who claims to be such an all knowing and indispensable "resource" can't even operate a news reader program, and the name-calling speaks for itself. Doug, You may think you are big stuff writing for Pinnacle or whoever you write for but you have lowered yourself into the gutter supporting and promoting Arno R, John Marshall and Keith Wilby. Just take a look at the worthless garbage they are polluting the newsgroups with and count the number of responses of help made by that trio of dimwits. Also keep in mind that the rules went out the window when Arno R started sending emails to my office. As for highly respected contributors to the newsgroups, here is a list of just a few: Allen Browne Ken Snell Jim Fortune Salad Tom van Stiphout MG Foster FredG John Nurick These guys are class acts!!!! You aren't even in their league. Steve >> > How's this --- "You're a dimwit!" >> [quoted text clipped - 3 lines] > > How would he recognize the alternative? > Just take a look at the worthless garbage they are polluting the > newsgroups > > Steve That's a novel way of describing your solicitations. Stop soliciting, we'll stop complaining. John... Visio MVP > Doug, > > Also keep in mind that the rules went out the window when Arno R started > sending emails to my office. You were not following the rules in the first place and have you not been asking users to contact you directly? > These guys are class acts!!!! You aren't even in their league. Since Nov 1st, Doug has made 386 posts to the Access newsgroups. You on the other hand have only posted 85, which was mainly a combination of slander, plagarism or incorrect information. You are definitely in a league of your own. > Steve PS: where is your legions of supporters? John... Visio MVP <snip self-opinionated clap-trap> I'm not going to get involved in a statistical joust with you, it really isn't worth it. You are entitled to your opinion but as far as I'm concerned it counts for nothing here and the name-calling speaks volumes about you. > Doug, > > Also keep in mind that the > rules went out the window when Arno R started sending emails to my office. To all: Do *not* believe this lunatic accusation. Simply *not true*. ************************************************** BUT: I *did* sent ONE email indeed where PC was *asking* for it. Look at the thread: "Checkboxes and Option Groups" http://groups.google.com/group/comp.databases.ms-access/msg/bce809737152b925 In that thread I said to Steve: "If you are interested contact me and I will send you a screenshot." Steve replied: "I am interested. I would appreciate whatever you can send me". ************************************************ So I did send a screenshot to Steve indeed in a private mail .... "Steve, As promised a screenshot, <Screenshot> If you stop your advertising you can have the code for free" And I also replied to Steve here in the groups with the same message: "I just did send the screenshot to you. As I said in the mail: If you stop your advertising you can have the code for free !" He did *not* answer this. So my conclusion was: >Since I don't hear from you again, I guess your are not interested in free >code or free support? So I never have been sending email*s*. Only the ONE that he asked for. I see only ONE mail to resource@pcdatasheet in my Outbox. As I recall I was even hesitating sending Steve the screenshot because I choked on the address ("resource..." sic!!) To Steve: So yet another false accusation! Any self-esteem left ?? *************************************** Besides: I am *still* waiting for other answers. Coming soon Steve ??? Arno R > As for highly respected contributors to the newsgroups, here is a list of > just a few: [quoted text clipped - 9 lines] > > Steve So what are you trying to tell us with this list Steve ?? I don't think they are members of the PCDataSheet-FanClub ! They are highly respected contributors indeed (and there are a lot of others also). But they are *not highly respecting you* I guess ... At least I know that some of them are not ... Arno R Tina, Your failure to answer is an affirmative confirmation that you can not support the statement you made. In the future do not make statements that you can not support. This is not the way to achieve MVP status. Steve PC Datasheet > Ronbo, sorry about the inappropriate solicitation post you > received in this thread. the purpose of these unmonitored newsgroups is to [quoted text clipped - 26 lines] >> >> Thanks > Tina, > > Your failure to answer is an affirmative confirmation that you can not > support the statement you made. So what about the long list of questions you have never answered? > In the future do not make statements that you can not support. So what about the statements that you refuse to support? > This is not the way to achieve MVP status. From what I have seen of Tina's posts, she has a far better chance of being awarded than you. > Steve PC Datasheet John... Visio MVP IMO Tina is smart enough to not enter a useless discussion about the rules here with you. You just don't want to *know* the rules here. BUT: I am *still* waiting for *your* answers Steve !! What a drag .... <sigh> Arno R > Tina, > [quoted text clipped - 4 lines] > Steve > PC Datasheet You are selling three day old fish!!! Should I put your last post in the 'helpful' pile or 'solicitation' pile when calculating your "10:1" ratio? Ed Warren > Tina, > [quoted text clipped - 38 lines] >>> >>> Thanks I think you will have to 'roll your own' to get something this specific. As a start lay out in a paragraph all the 'entites'. Here is a start I have a number of teams (currently 2) Each team is made up of a number of people (currently 5) There are a number of shifts to be covered. Each shift consists of a day, start time, end time, and required number of staff Some days are holidays and they are off but are covered by 'On Call Assignments All Sundays are holidays Some days are minor holidays and they have 'short staffing' ----not sure what the meaning of 'the team covering 3pm to 11pm will give up one to cover 11pm to 3am-- but this is yet another business rule. Ok look for the nouns teams people shifts days workdays holidays minor holidays sundays saturdays ?? (might be just another work day) ----you may have more Now we look for relationships each person is assigned to one and only one team each team consists of many people (currently 5) each shift is assigned to one and only one team each team is assigned many shifts each day consists of many shifts ---- you may have more. After you get all the: (one can roughly consider all of these the same but in places the language varies) Enties (entity-relation model); Classes (Object Oriented model); Tables (relational physical database design) and their characteristics (field types) and their relationships to other things in the model, you are almost ready to start building your database. After you get the data structure right, you will need to build in the business logic, I think this will take some coding in Visual Basic. The same team cannot have more than one shift in a day, etc. Then you can build your user interface. Lots of luck. Ed Warren > Am looking for help in scheduling two teams of five (5) persons....7am to > 3pm, and 3pm to 11pm...Mon-Sat. (Sundays off). Furthermore...of the teams [quoted text clipped - 8 lines] > > Thanks in addition to following Ed's excellent methodology, suggest you read up on data modeling and relational design principles. see http://home.att.net/~california.db/tips.html#aTip1 for more information. hth > Am looking for help in scheduling two teams of five (5) persons....7am to > 3pm, and 3pm to 11pm...Mon-Sat. (Sundays off). Furthermore...of the teams of [quoted text clipped - 6 lines] > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.