|
| 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
February 8th, 2010, 09:59 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Datasheet Form
Steve
I need to see customer name (Customer Table) with there area (Cut table) and the cut week (Cutwork table), so that i can enter the data in the cut week field for the customers that were cut that week. I am looking to enter 90 to 120 entries in a day. Doing the sub-forms still only lets me look at 1 record at a time. Am I trying to do the impossibe here? The Estimate table only has 2 fields that I need for this query. I will be putting Customer information in the customer table from a form, then the estimate information from a form, cut information from a form, the nice neet idiot proof ones. I have those all made linked together works great. Now trying to put this in a datasheet form to input the cuts (date) quickly. I hope this isn't to confusing. Here is the information you asked for. If you need anything else just let me know. Thanks for your help and advise. Customer Table CustomerID MyCounter ABC FirstName LastName Address City MapPage MapPageLetter MapPageNum Cut Table CustomerID (Foreign Key) CutCust2010 CutArea CutOrdNum CutPrice CutEOW CutComments CutLR CutWork Table CustomerID (Foreign Key) Cutwk1 Cutwk2 Cutwk3 Cutwk4 Cutwk5 Estimate Table CustomerID (Foreign Key) Services SqFt These are the fields that I am putting in my query to try and make a datasheet form for quick entries in the cut weeks. All tables have a primary key except for the Cut table, but I do have a field that Can be put as a primary key. -- Lenee "Steve" wrote: Lenee, Your tables probably need a simple tweak! I presume you want to enter an estimate for a customer. Is that correct? Please explain Cut Table and CutWork Table. Is CutWork the details of a Cut? Could you respond back with the fields in the Estimate Table, Cut Table and CutWork Table in this format: Estimate EstimateID your fields Cut your fields CutWork CutworkID your fields Steve "Lenee" wrote in message ... Steve you were right. Is there any way to make it updateable? -- Lenee "Steve" wrote: Your query is probably not updateable. Open the query and look at the navigation buttons. If the new record button os grayed out, your query is not updateable. When a query is not updateable, you won't be able to add new records to a form based on the query. For example, union queries and crosstab queries are not updateable. Steve "Lenee" wrote in message ... I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee . . 
|
|
#13
February 9th, 2010, 01:55 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form
Lenee,
Please explain a little of what business this applies to so we can get a clearer picture. And for FREE we (and by that I don't mean Steve) will work with you to get an updateable query (one that can be edited). -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Steve I need to see customer name (Customer Table) with there area (Cut table) and the cut week (Cutwork table), so that i can enter the data in the cut week field for the customers that were cut that week. I am looking to enter 90 to 120 entries in a day. Doing the sub-forms still only lets me look at 1 record at a time. Am I trying to do the impossibe here? The Estimate table only has 2 fields that I need for this query. I will be putting Customer information in the customer table from a form, then the estimate information from a form, cut information from a form, the nice neet idiot proof ones. I have those all made linked together works great. Now trying to put this in a datasheet form to input the cuts (date) quickly. I hope this isn't to confusing. Here is the information you asked for. If you need anything else just let me know. Thanks for your help and advise. Customer Table CustomerID MyCounter ABC FirstName LastName Address City MapPage MapPageLetter MapPageNum Cut Table CustomerID (Foreign Key) CutCust2010 CutArea CutOrdNum CutPrice CutEOW CutComments CutLR CutWork Table CustomerID (Foreign Key) Cutwk1 Cutwk2 Cutwk3 Cutwk4 Cutwk5 Estimate Table CustomerID (Foreign Key) Services SqFt These are the fields that I am putting in my query to try and make a datasheet form for quick entries in the cut weeks. All tables have a primary key except for the Cut table, but I do have a field that Can be put as a primary key. -- Lenee "Steve" wrote: Lenee, Your tables probably need a simple tweak! I presume you want to enter an estimate for a customer. Is that correct? Please explain Cut Table and CutWork Table. Is CutWork the details of a Cut? Could you respond back with the fields in the Estimate Table, Cut Table and CutWork Table in this format: Estimate EstimateID your fields Cut your fields CutWork CutworkID your fields Steve "Lenee" wrote in message ... Steve you were right. Is there any way to make it updateable? -- Lenee "Steve" wrote: Your query is probably not updateable. Open the query and look at the navigation buttons. If the new record button os grayed out, your query is not updateable. When a query is not updateable, you won't be able to add new records to a form based on the query. For example, union queries and crosstab queries are not updateable. Steve "Lenee" wrote in message ... I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee . .
|
|
#14
February 9th, 2010, 02:00 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form - little stevie is pimping AGAIN
"Steve" wrote in message
... It's going to take some time to sort things out. Would you consider hiring me to work with you to develop what you have into a proper database? I provide help with Access, Excel and Word applications for a small fee. My fee to help you would be very reasonable. Contact me offline at and let's get your database working. Steve Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He also offers questionable servies at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. John... Visio MVP
|
|
#15
February 9th, 2010, 08:12 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form
"Steve" schreef in bericht ... Lenee, It is very confusing!!! Not confusing at all... OP would like help... for FREE -- Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it's a shame !!) Arno R
|
|
#16
February 9th, 2010, 02:34 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form
Gina,
We are a Lawn Maintanence Co. which had 4 divisions within the company: 1. Mowing service 2. Fertilization service (LCP) 3. Misc Work - Mulching, trim shrubs, etc. 4. Hardscapes - Patios, walkways walls, etc. We have the following customer base: 1. 600 cut cust. 2. 250 lcp cust. 3. 150 Misc cust. 4. 25 Hardscape cust. Customers can be either a cut, lcp,misc or hardscape customer or any combination of these. We do approximately 2500 estimates per year. Our mind set was to set up the tables as follows: 1. Customer Table - Name, rank, serial number 2. Estimate Table - Info pretaining to estimate done. 3. Cut Table - All infor pretaining to the cut side. 4. Cutwork T - 36 cut weeks (to enter dates cut) plus leaf removal weeks. 5. CutPayment T - Monthly bill and payment info. 6. LCP T - All information pretaining to LCP work. 7. Misc T - All info pretaining to Misc work. 8. Hardscape T - All info pretaining to Hardscape work. There is a total of 309 fields in all of these tables and none of them are duplicates. We have tried putting them all into 1 table, but it was to big. The problem arises when we try to link 4 tables CustT, CutT, CutworkT and EstimateT in a query. We do most of our work in a Datasheet view/form since we cut approx 150 propertys a day. Inputing todays date takes approximately 1 minute in a datasheet view vs 10 minutes in a form view. Should we try to put this in 2 tables? Table 1 Customer, Cut, Cutwork, Cutpayments & Estimate. Table 2 LCP, Misc & Hardscape. Also another issue is we are trying to set an account number using the DMAX function to lookup the greatest number and increase by 1. Isn't happening here. We have been using Microsoft Works for the past 15 years or so and it has been working fine, just a little limiting as far as the amount of filters and reports. Thanks for help and advice. -- Lenee "Gina Whipp" wrote: Lenee, Please explain a little of what business this applies to so we can get a clearer picture. And for FREE we (and by that I don't mean Steve) will work with you to get an updateable query (one that can be edited). -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Steve I need to see customer name (Customer Table) with there area (Cut table) and the cut week (Cutwork table), so that i can enter the data in the cut week field for the customers that were cut that week. I am looking to enter 90 to 120 entries in a day. Doing the sub-forms still only lets me look at 1 record at a time. Am I trying to do the impossibe here? The Estimate table only has 2 fields that I need for this query. I will be putting Customer information in the customer table from a form, then the estimate information from a form, cut information from a form, the nice neet idiot proof ones. I have those all made linked together works great. Now trying to put this in a datasheet form to input the cuts (date) quickly. I hope this isn't to confusing. Here is the information you asked for. If you need anything else just let me know. Thanks for your help and advise. Customer Table CustomerID MyCounter ABC FirstName LastName Address City MapPage MapPageLetter MapPageNum Cut Table CustomerID (Foreign Key) CutCust2010 CutArea CutOrdNum CutPrice CutEOW CutComments CutLR CutWork Table CustomerID (Foreign Key) Cutwk1 Cutwk2 Cutwk3 Cutwk4 Cutwk5 Estimate Table CustomerID (Foreign Key) Services SqFt These are the fields that I am putting in my query to try and make a datasheet form for quick entries in the cut weeks. All tables have a primary key except for the Cut table, but I do have a field that Can be put as a primary key. -- Lenee "Steve" wrote: Lenee, Your tables probably need a simple tweak! I presume you want to enter an estimate for a customer. Is that correct? Please explain Cut Table and CutWork Table. Is CutWork the details of a Cut? Could you respond back with the fields in the Estimate Table, Cut Table and CutWork Table in this format: Estimate EstimateID your fields Cut your fields CutWork CutworkID your fields Steve "Lenee" wrote in message ... Steve you were right. Is there any way to make it updateable? -- Lenee "Steve" wrote: Your query is probably not updateable. Open the query and look at the navigation buttons. If the new record button os grayed out, your query is not updateable. When a query is not updateable, you won't be able to add new records to a form based on the query. For example, union queries and crosstab queries are not updateable. Steve "Lenee" wrote in message ... I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee . . .
|
|
#17
February 9th, 2010, 03:20 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form
Lenee,
Okay, the problem with getting the information is that your tables are set up incorrectly. Now, you have to tell me if you are able to adjust them. If you are then you need to type in the tables and there names here OR you can send it to me (get my eMail address from my website) and I will review and send you a proper data model with which you can import your data into. (I will not be able to look at it till tonight but I will look at it and get it back to you.) By the way, table being big? If you alot of records then that's not big... if you mean alot of fields then that's a sign of an incorrect data model. The way you are trying to link the the tables you will never get all the information without a UNION query. As a side note... everything I offered is FREE! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Gina, We are a Lawn Maintanence Co. which had 4 divisions within the company: 1. Mowing service 2. Fertilization service (LCP) 3. Misc Work - Mulching, trim shrubs, etc. 4. Hardscapes - Patios, walkways walls, etc. We have the following customer base: 1. 600 cut cust. 2. 250 lcp cust. 3. 150 Misc cust. 4. 25 Hardscape cust. Customers can be either a cut, lcp,misc or hardscape customer or any combination of these. We do approximately 2500 estimates per year. Our mind set was to set up the tables as follows: 1. Customer Table - Name, rank, serial number 2. Estimate Table - Info pretaining to estimate done. 3. Cut Table - All infor pretaining to the cut side. 4. Cutwork T - 36 cut weeks (to enter dates cut) plus leaf removal weeks. 5. CutPayment T - Monthly bill and payment info. 6. LCP T - All information pretaining to LCP work. 7. Misc T - All info pretaining to Misc work. 8. Hardscape T - All info pretaining to Hardscape work. There is a total of 309 fields in all of these tables and none of them are duplicates. We have tried putting them all into 1 table, but it was to big. The problem arises when we try to link 4 tables CustT, CutT, CutworkT and EstimateT in a query. We do most of our work in a Datasheet view/form since we cut approx 150 propertys a day. Inputing todays date takes approximately 1 minute in a datasheet view vs 10 minutes in a form view. Should we try to put this in 2 tables? Table 1 Customer, Cut, Cutwork, Cutpayments & Estimate. Table 2 LCP, Misc & Hardscape. Also another issue is we are trying to set an account number using the DMAX function to lookup the greatest number and increase by 1. Isn't happening here. We have been using Microsoft Works for the past 15 years or so and it has been working fine, just a little limiting as far as the amount of filters and reports. Thanks for help and advice. -- Lenee "Gina Whipp" wrote: Lenee, Please explain a little of what business this applies to so we can get a clearer picture. And for FREE we (and by that I don't mean Steve) will work with you to get an updateable query (one that can be edited). -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Steve I need to see customer name (Customer Table) with there area (Cut table) and the cut week (Cutwork table), so that i can enter the data in the cut week field for the customers that were cut that week. I am looking to enter 90 to 120 entries in a day. Doing the sub-forms still only lets me look at 1 record at a time. Am I trying to do the impossibe here? The Estimate table only has 2 fields that I need for this query. I will be putting Customer information in the customer table from a form, then the estimate information from a form, cut information from a form, the nice neet idiot proof ones. I have those all made linked together works great. Now trying to put this in a datasheet form to input the cuts (date) quickly. I hope this isn't to confusing. Here is the information you asked for. If you need anything else just let me know. Thanks for your help and advise. Customer Table CustomerID MyCounter ABC FirstName LastName Address City MapPage MapPageLetter MapPageNum Cut Table CustomerID (Foreign Key) CutCust2010 CutArea CutOrdNum CutPrice CutEOW CutComments CutLR CutWork Table CustomerID (Foreign Key) Cutwk1 Cutwk2 Cutwk3 Cutwk4 Cutwk5 Estimate Table CustomerID (Foreign Key) Services SqFt These are the fields that I am putting in my query to try and make a datasheet form for quick entries in the cut weeks. All tables have a primary key except for the Cut table, but I do have a field that Can be put as a primary key. -- Lenee "Steve" wrote: Lenee, Your tables probably need a simple tweak! I presume you want to enter an estimate for a customer. Is that correct? Please explain Cut Table and CutWork Table. Is CutWork the details of a Cut? Could you respond back with the fields in the Estimate Table, Cut Table and CutWork Table in this format: Estimate EstimateID your fields Cut your fields CutWork CutworkID your fields Steve "Lenee" wrote in message ... Steve you were right. Is there any way to make it updateable? -- Lenee "Steve" wrote: Your query is probably not updateable. Open the query and look at the navigation buttons. If the new record button os grayed out, your query is not updateable. When a query is not updateable, you won't be able to add new records to a form based on the query. For example, union queries and crosstab queries are not updateable. Steve "Lenee" wrote in message ... I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee . . .
|
|
#18
February 9th, 2010, 05:25 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form
Gina, I tried to go to your website but it wasn't working correctly. Not sure
if I have correct email address, will send a quick note to see if it is the correct one. I did give you the name of the tables. I am able to ajust them. Do you need all of their field names? Not really sure what you need. Do you want me to email you the whole database? Table to big as in to many fields. That is why we are doing more tables. -- Lenee "Gina Whipp" wrote: Lenee, Okay, the problem with getting the information is that your tables are set up incorrectly. Now, you have to tell me if you are able to adjust them. If you are then you need to type in the tables and there names here OR you can send it to me (get my eMail address from my website) and I will review and send you a proper data model with which you can import your data into. (I will not be able to look at it till tonight but I will look at it and get it back to you.) By the way, table being big? If you alot of records then that's not big... if you mean alot of fields then that's a sign of an incorrect data model. The way you are trying to link the the tables you will never get all the information without a UNION query. As a side note... everything I offered is FREE! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Gina, We are a Lawn Maintanence Co. which had 4 divisions within the company: 1. Mowing service 2. Fertilization service (LCP) 3. Misc Work - Mulching, trim shrubs, etc. 4. Hardscapes - Patios, walkways walls, etc. We have the following customer base: 1. 600 cut cust. 2. 250 lcp cust. 3. 150 Misc cust. 4. 25 Hardscape cust. Customers can be either a cut, lcp,misc or hardscape customer or any combination of these. We do approximately 2500 estimates per year. Our mind set was to set up the tables as follows: 1. Customer Table - Name, rank, serial number 2. Estimate Table - Info pretaining to estimate done. 3. Cut Table - All infor pretaining to the cut side. 4. Cutwork T - 36 cut weeks (to enter dates cut) plus leaf removal weeks. 5. CutPayment T - Monthly bill and payment info. 6. LCP T - All information pretaining to LCP work. 7. Misc T - All info pretaining to Misc work. 8. Hardscape T - All info pretaining to Hardscape work. There is a total of 309 fields in all of these tables and none of them are duplicates. We have tried putting them all into 1 table, but it was to big. The problem arises when we try to link 4 tables CustT, CutT, CutworkT and EstimateT in a query. We do most of our work in a Datasheet view/form since we cut approx 150 propertys a day. Inputing todays date takes approximately 1 minute in a datasheet view vs 10 minutes in a form view. Should we try to put this in 2 tables? Table 1 Customer, Cut, Cutwork, Cutpayments & Estimate. Table 2 LCP, Misc & Hardscape. Also another issue is we are trying to set an account number using the DMAX function to lookup the greatest number and increase by 1. Isn't happening here. We have been using Microsoft Works for the past 15 years or so and it has been working fine, just a little limiting as far as the amount of filters and reports. Thanks for help and advice. -- Lenee "Gina Whipp" wrote: Lenee, Please explain a little of what business this applies to so we can get a clearer picture. And for FREE we (and by that I don't mean Steve) will work with you to get an updateable query (one that can be edited). -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Steve I need to see customer name (Customer Table) with there area (Cut table) and the cut week (Cutwork table), so that i can enter the data in the cut week field for the customers that were cut that week. I am looking to enter 90 to 120 entries in a day. Doing the sub-forms still only lets me look at 1 record at a time. Am I trying to do the impossibe here? The Estimate table only has 2 fields that I need for this query. I will be putting Customer information in the customer table from a form, then the estimate information from a form, cut information from a form, the nice neet idiot proof ones. I have those all made linked together works great. Now trying to put this in a datasheet form to input the cuts (date) quickly. I hope this isn't to confusing. Here is the information you asked for. If you need anything else just let me know. Thanks for your help and advise. Customer Table CustomerID MyCounter ABC FirstName LastName Address City MapPage MapPageLetter MapPageNum Cut Table CustomerID (Foreign Key) CutCust2010 CutArea CutOrdNum CutPrice CutEOW CutComments CutLR CutWork Table CustomerID (Foreign Key) Cutwk1 Cutwk2 Cutwk3 Cutwk4 Cutwk5 Estimate Table CustomerID (Foreign Key) Services SqFt These are the fields that I am putting in my query to try and make a datasheet form for quick entries in the cut weeks. All tables have a primary key except for the Cut table, but I do have a field that Can be put as a primary key. -- Lenee "Steve" wrote: Lenee, Your tables probably need a simple tweak! I presume you want to enter an estimate for a customer. Is that correct? Please explain Cut Table and CutWork Table. Is CutWork the details of a Cut? Could you respond back with the fields in the Estimate Table, Cut Table and CutWork Table in this format: Estimate EstimateID your fields Cut your fields CutWork CutworkID your fields Steve "Lenee" wrote in message ... Steve you were right. Is there any way to make it updateable? -- Lenee "Steve" wrote: Your query is probably not updateable. Open the query and look at the navigation buttons. If the new record button os grayed out, your query is not updateable. When a query is not updateable, you won't be able to add new records to a form based on the query. For example, union queries and crosstab queries are not updateable. Steve "Lenee" wrote in message ... I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee . . . .
|
|
#19
February 9th, 2010, 06:16 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Datasheet Form
Lenne,
Thanks for the heads up regarding my website... will go check that. HOWEVER, you did send me an eMail and I responded. I stepped away from my machine so I did not see it straight away! So if you just want to send it please do! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Gina, I tried to go to your website but it wasn't working correctly. Not sure if I have correct email address, will send a quick note to see if it is the correct one. I did give you the name of the tables. I am able to ajust them. Do you need all of their field names? Not really sure what you need. Do you want me to email you the whole database? Table to big as in to many fields. That is why we are doing more tables. -- Lenee "Gina Whipp" wrote: Lenee, Okay, the problem with getting the information is that your tables are set up incorrectly. Now, you have to tell me if you are able to adjust them. If you are then you need to type in the tables and there names here OR you can send it to me (get my eMail address from my website) and I will review and send you a proper data model with which you can import your data into. (I will not be able to look at it till tonight but I will look at it and get it back to you.) By the way, table being big? If you alot of records then that's not big... if you mean alot of fields then that's a sign of an incorrect data model. The way you are trying to link the the tables you will never get all the information without a UNION query. As a side note... everything I offered is FREE! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Gina, We are a Lawn Maintanence Co. which had 4 divisions within the company: 1. Mowing service 2. Fertilization service (LCP) 3. Misc Work - Mulching, trim shrubs, etc. 4. Hardscapes - Patios, walkways walls, etc. We have the following customer base: 1. 600 cut cust. 2. 250 lcp cust. 3. 150 Misc cust. 4. 25 Hardscape cust. Customers can be either a cut, lcp,misc or hardscape customer or any combination of these. We do approximately 2500 estimates per year. Our mind set was to set up the tables as follows: 1. Customer Table - Name, rank, serial number 2. Estimate Table - Info pretaining to estimate done. 3. Cut Table - All infor pretaining to the cut side. 4. Cutwork T - 36 cut weeks (to enter dates cut) plus leaf removal weeks. 5. CutPayment T - Monthly bill and payment info. 6. LCP T - All information pretaining to LCP work. 7. Misc T - All info pretaining to Misc work. 8. Hardscape T - All info pretaining to Hardscape work. There is a total of 309 fields in all of these tables and none of them are duplicates. We have tried putting them all into 1 table, but it was to big. The problem arises when we try to link 4 tables CustT, CutT, CutworkT and EstimateT in a query. We do most of our work in a Datasheet view/form since we cut approx 150 propertys a day. Inputing todays date takes approximately 1 minute in a datasheet view vs 10 minutes in a form view. Should we try to put this in 2 tables? Table 1 Customer, Cut, Cutwork, Cutpayments & Estimate. Table 2 LCP, Misc & Hardscape. Also another issue is we are trying to set an account number using the DMAX function to lookup the greatest number and increase by 1. Isn't happening here. We have been using Microsoft Works for the past 15 years or so and it has been working fine, just a little limiting as far as the amount of filters and reports. Thanks for help and advice. -- Lenee "Gina Whipp" wrote: Lenee, Please explain a little of what business this applies to so we can get a clearer picture. And for FREE we (and by that I don't mean Steve) will work with you to get an updateable query (one that can be edited). -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Lenee" wrote in message ... Steve I need to see customer name (Customer Table) with there area (Cut table) and the cut week (Cutwork table), so that i can enter the data in the cut week field for the customers that were cut that week. I am looking to enter 90 to 120 entries in a day. Doing the sub-forms still only lets me look at 1 record at a time. Am I trying to do the impossibe here? The Estimate table only has 2 fields that I need for this query. I will be putting Customer information in the customer table from a form, then the estimate information from a form, cut information from a form, the nice neet idiot proof ones. I have those all made linked together works great. Now trying to put this in a datasheet form to input the cuts (date) quickly. I hope this isn't to confusing. Here is the information you asked for. If you need anything else just let me know. Thanks for your help and advise. Customer Table CustomerID MyCounter ABC FirstName LastName Address City MapPage MapPageLetter MapPageNum Cut Table CustomerID (Foreign Key) CutCust2010 CutArea CutOrdNum CutPrice CutEOW CutComments CutLR CutWork Table CustomerID (Foreign Key) Cutwk1 Cutwk2 Cutwk3 Cutwk4 Cutwk5 Estimate Table CustomerID (Foreign Key) Services SqFt These are the fields that I am putting in my query to try and make a datasheet form for quick entries in the cut weeks. All tables have a primary key except for the Cut table, but I do have a field that Can be put as a primary key. -- Lenee "Steve" wrote: Lenee, Your tables probably need a simple tweak! I presume you want to enter an estimate for a customer. Is that correct? Please explain Cut Table and CutWork Table. Is CutWork the details of a Cut? Could you respond back with the fields in the Estimate Table, Cut Table and CutWork Table in this format: Estimate EstimateID your fields Cut your fields CutWork CutworkID your fields Steve "Lenee" wrote in message ... Steve you were right. Is there any way to make it updateable? -- Lenee "Steve" wrote: Your query is probably not updateable. Open the query and look at the navigation buttons. If the new record button os grayed out, your query is not updateable. When a query is not updateable, you won't be able to add new records to a form based on the query. For example, union queries and crosstab queries are not updateable. Steve "Lenee" wrote in message ... I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee . . . .
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
