|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
July 11th, 2007, 12:48 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Resource Allocations
LoL. Take it one step at a time and read my two other responses! "ant1983" wrote: 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! "scubadiver" wrote: 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!) "ant1983" wrote: 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 "scubadiver" wrote: 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? "ant1983" wrote: 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. "scubadiver" wrote: 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. "ant1983" wrote: 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! 
|
|
#12
July 11th, 2007, 05:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Resource Allocations
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 "Peter Hibbs" wrote: Wayne A Flex Grid Control will probably do what you want. Have a look at - http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.m db' for some examples. Peter Hibbs. On Wed, 11 Jul 2007 03:24:00 -0700, ant1983 wrote: 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 "scubadiver" wrote: 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? "ant1983" wrote: 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. "scubadiver" wrote: 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. "ant1983" wrote: 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!
|
|
#13
July 11th, 2007, 08:05 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Resource Allocations
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. On Wed, 11 Jul 2007 09:02:07 -0700, ant1983 wrote: 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 "Peter Hibbs" wrote: Wayne A Flex Grid Control will probably do what you want. Have a look at - http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.m db' for some examples. Peter Hibbs. On Wed, 11 Jul 2007 03:24:00 -0700, ant1983 wrote: 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 "scubadiver" wrote: 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? "ant1983" wrote: 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. "scubadiver" wrote: 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. "ant1983" wrote: 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!
|
|
#14
July 12th, 2007, 06:56 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Resource Allocations
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 "Peter Hibbs" wrote: 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. On Wed, 11 Jul 2007 09:02:07 -0700, ant1983 wrote: 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 "Peter Hibbs" wrote: Wayne A Flex Grid Control will probably do what you want. Have a look at - http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.m db' for some examples. Peter Hibbs. On Wed, 11 Jul 2007 03:24:00 -0700, ant1983 wrote: 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 "scubadiver" wrote: 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? "ant1983" wrote: 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. "scubadiver" wrote: 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. "ant1983" wrote: 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!
|
|
#15
July 12th, 2007, 07:56 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Resource Allocations
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 "ant1983" wrote: 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! "scubadiver" wrote: 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!) "ant1983" wrote: 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 "scubadiver" wrote: 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? "ant1983" wrote: 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. "scubadiver" wrote: 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. "ant1983" wrote: 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!
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
