 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Resource Allocations
Riiiiight, one more question: Basically what im after is to have a form where i can allocate jobs to employees. The way i see it is to have the headings in the forms as: 00:00 01:00 02:00 03:00 (and so forth) Then on the left i have all the employee names. So next to each employee name for each time (as above) there should be a drop down box with all the jobs. Once a job is allocated under the correct time and next to an employee it should disapear from the drop down box. So my question is how is best to do this? OR Is there a better way? Sorry guyz!!! Thanks! Are you thinking in terms of a spreadsheet (rows and columns). A big NO, NO if you are. How flexible is the coordination between employees and jobs? Can each job be carried out by many employees for example or is each job allocated to one employee at a time? This will affect the design so you have to absolutely sure it is correct. Can you give a brief description of what is happening? It is better to think in plain language first before getting technical. > Riiiiight, one more question: > [quoted text clipped - 19 lines] > > Thanks! Heya!! Damn i must have had a bad night coz all my questions were vague. Sorry mate!! Riiiight... (here we go) To clarify im building a db for a Tour Operator. This company basically transfers clients from one place to another (so basically like a taxi service) So when clients make a booking it gets capturered on the system (A simple table with fields like: ClientID ClientName ClientCityFrom ClientCityTo ClientEmployee Riiiight, then at the end of the day the Resource planner has to schedule the bookings for the next day so he wants to then open a form to show all jobs for tomorrow (i know how to do this) and then in this form he would like to see all his Employees (Drivers) on the far left column and then the headings should be the times in hour increments. So basically: 00:00 01:00 02:00 03:00 (and so forth) 22:00 23:00 So its gona look like this: 00:00 01:00 02:00 03:00 (and so forth) 22:00 23:00 Employee1 <<job>> <<job>> <<job>> <<job>> <<job>> Employee2 <<job>> <<job>> <<job>> <<job>> <<job>> Employee3 <<job>> <<job>> <<job>> <<job>> <<job>> Employee4 <<job>> <<job>> <<job>> <<job>> <<job>> Employee5 <<job>> <<job>> <<job>> <<job>> <<job>> So as you can see each employee can have a job for each hour of the day and i was thinking of having these jobs as drop down boxes of the pending jobs (i.e: All jobs for next day) The "job" wil get its values from a query but i know how to do this so thank. So what am i asking?? Damed if i know!! LOL No seriously: I jsut want to know if this is the best way of doing it from the "Resource Planner's" point of view. I think so cos then you can (almost) graphically see where the jobs are allocated and who is open when so thats why i chose this format though i am very open to other suggestions. Hope i shed some clarity. Many thanks in advance for your help mate!! Cheers! Wayne ant1983 To answer your question. One job gets allocated to ONE employee ONLY. > Are you thinking in terms of a spreadsheet (rows and columns). A big NO, NO > if you are. [quoted text clipped - 30 lines] > > > > Thanks! Am I right in thinking the resource planner wants to see a blank form? What happens to the information in the form the following day? Does it get deleted? > Heya!! > [quoted text clipped - 90 lines] > > > > > > Thanks! Well yeah the resource planner would open the form and have the Employees and the left and the times on the top so these can obviously not be edited. Crossing these two you would then get an entry for each so those would be (blank) drop down boxes which the resource planner would then just select jobs from. (This action would signify a job being allocated to a person) It will probably just look fancy or whatever but the way i see it is it should be really simple: it would prob just run off the tblJob table so each time a job is "allocated" (as above) to an employee it would basicaly just write the Employee name in that entry's Employee field. Again, im open to other suggestions but this jsut makes sense. I think what im really just asking is how do i get a form with the employee names on the left and the times at the top and by selecting from the drop down box it would just allocate the job to that employee at that time (in the back end all that has to happen is the name of employee should be in that line's employee field > Am I right in thinking the resource planner wants to see a blank form? > What happens to the information in the form the following day? Does it get [quoted text clipped - 94 lines] > > > > > > > > Thanks! What you want to achieve sounds really straightfoward but, design wise, a case of head scratching! I was thinking each employee can have multiple jobs but if your resource planner is doing it on a daily basis it may not be a problem since it can be used flexibly) I think the best thing would be to have a one to many relationship. In one table you have all your employee information. In the second table you have your hour fields: tble_employee EmployeeID (Primary Key) field1 field2 etc tble_booking EmployeeID (Foreign Key) Hour1 . . . Hour23 Go to tools->Relationships Show the two tables and drag the employeeID from one table to the other and establish the relationship. Ensure referential integrity (sorry if you already know this). Then you create a query using these two tables. Select all the fields and then you can use this query as the source for your form (a query of this type is hopefully updateable). I would suggest that you change the properties so that you can't add or delete employees (do this in the employee table). As far as job info goes you can use the booking information as the source for the combo boxes. I was going to suggest you could use cascading combos to ensure there isn't a chance of a job being replicated by mistake in a row but it depends whether every field is going to filled in. The catch is that each row is a distinct entity so there is a chance that two employees could get the same job (by mistake). I think you would have to put up with this to ensure you can add and delete employee information otherwise a fixed number of fields for employees will make the DB very difficult to maintain (especially if the business expands!) > Well yeah the resource planner would open the form and have the Employees and > the left and the times on the top so these can obviously not be edited. [quoted text clipped - 116 lines] > > > > > > > > > > Thanks! Eeeeeeeek!! Did i mention i'm a Novice ova here?? LOL!! Cheers mate! im gona try that tonight as its on my personal PC and let ya know tomor!!! Thanks a mil!! If ya dont mind (and only if you up for it) I have one more question titled "Multiple fields using to search" Would be sooo grateful if you can take a look at it for me!! Cheers man and chat tomor! > What you want to achieve sounds really straightfoward but, design wise, a > case of head scratching! [quoted text clipped - 164 lines] > > > > > > > > > > > > Thanks! LoL. Take it one step at a time and read my two other responses! > Eeeeeeeek!! Did i mention i'm a Novice ova here?? LOL!! > [quoted text clipped - 177 lines] > > > > > > > > > > > > > > Thanks! Have you sorted out your problem? I cooked up a database yesterday and it is very straight forward. Would you like me to send it to you? if you want to, give me your email address like this so it doesn't get picked up by spam software. someone . something (at) blah blah . co . uk > Eeeeeeeek!! Did i mention i'm a Novice ova here?? LOL!! > [quoted text clipped - 177 lines] > > > > > > > > > > > > > > Thanks! Oh dear. the problem with my suggestion is that if there is no information in the "hour" fields then the names won't appear in the form. > Well yeah the resource planner would open the form and have the Employees and > the left and the times on the top so these can obviously not be edited. [quoted text clipped - 116 lines] > > > > > > > > > > Thanks! My fault. In the query, click on the line between the tables and choose option 2. This will give you all the employee names in the form. As you add or delete employees this form will update itself. > Well yeah the resource planner would open the form and have the Employees and > the left and the times on the top so these can obviously not be edited. [quoted text clipped - 116 lines] > > > > > > > > > > Thanks! Wayne A Flex Grid Control will probably do what you want. Have a look at - http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20D emo.mdb' for some examples. Peter Hibbs. >Well yeah the resource planner would open the form and have the Employees and >the left and the times on the top so these can obviously not be edited. [quoted text clipped - 116 lines] >> > > > >> > > > Thanks! Hey Peter... Thanks for the link but if i click it i get the following page: ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /Otherdownload.asp, line 32 Please help. Thanks mate > Wayne > [quoted text clipped - 126 lines] > >> > > > > >> > > > Thanks! Wayne, Do you mean you get the error when you click on the link (it works OK for me) or do you mean when you double click on the database file after you have installed and registered the Flex Grid control. Peter. >Hey Peter... > [quoted text clipped - 141 lines] >> >> > > > >> >> > > > Thanks! Hey Peter, Its when i click the link. Thought it might be our firewall or something but tried it at home last night and getting the same thing. Thanks, Wayne > Wayne, > [quoted text clipped - 149 lines] > >> >> > > > > >> >> > > > Thanks! Hi Wayne. I have no idea. You could try accessing the Home page at http://www.rogersaccesslibrary.com/index.htm click on Other Developer Libraries and look for my name. If that doesn't work perhaps you should try a different browser (I use Mozilla Firefox which is free). If you still have problems and you still want to try the Flex Grid demo then email me at peter.hibbs@btinternet.comNOSPAM (omit the NOSPAM bit) and I will send you a copy. Peter. >Hey Peter, > [quoted text clipped - 160 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
|
©2009 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.