Datasheet Form
in [Getting Started]
|
From: Gina Whipp on 9 Feb 2010 10:20 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" <Lenee(a)discussions.microsoft.com> wrote in message news:2972E2BE-37D8-4ACF-A101-0215604D8314(a)microsoft.com... 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" <Lenee(a)discussions.microsoft.com> wrote in message > news:B70B030E-5BDF-4F87-BD3A-16DC4C85D1F7(a)microsoft.com... > 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" <Lenee(a)discussions.microsoft.com> wrote in message > > news:65238FDD-A873-4E50-8EAD-B765558DC89F(a)microsoft.com... > > > 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 > > >> santus(a)penn.com > > >> > > >> > > >> "Lenee" <Lenee(a)discussions.microsoft.com> wrote in message > > >> news:A5BB1169-7B01-4686-A0AF-8B6C4D9FA487(a)microsoft.com... > > >> >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 > > >> > > >> > > >> . > > >> > > > > > > . > > > > > . >
From: Lenee on 9 Feb 2010 12:25 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" <Lenee(a)discussions.microsoft.com> wrote in message > news:2972E2BE-37D8-4ACF-A101-0215604D8314(a)microsoft.com... > 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" <Lenee(a)discussions.microsoft.com> wrote in message > > news:B70B030E-5BDF-4F87-BD3A-16DC4C85D1F7(a)microsoft.com... > > 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" <Lenee(a)discussions.microsoft.com> wrote in message > > > news:65238FDD-A873-4E50-8EAD-B765558DC89F(a)microsoft.com... > > > > 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 > > > >> santus(a)penn.com > > > >> > > > >> > > > >> "Lenee" <Lenee(a)discussions.microsoft.com> wrote in message > > > >> news:A5BB1169-7B01-4686-A0AF-8B6C4D9FA487(a)microsoft.com... > > > >> >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 > > > >> > > > >> > > > >> . > > > >> > > > > > > > > > . > > > > > > > > > . > > > > > . >
From: Gina Whipp on 9 Feb 2010 13:16 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" <Lenee(a)discussions.microsoft.com> wrote in message news:51F52E5D-0B60-456B-AEB6-35803BBCFD6A(a)microsoft.com... 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" <Lenee(a)discussions.microsoft.com> wrote in message > news:2972E2BE-37D8-4ACF-A101-0215604D8314(a)microsoft.com... > 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" <Lenee(a)discussions.microsoft.com> wrote in message > > news:B70B030E-5BDF-4F87-BD3A-16DC4C85D1F7(a)microsoft.com... > > 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" <Lenee(a)discussions.microsoft.com> wrote in message > > > news:65238FDD-A873-4E50-8EAD-B765558DC89F(a)microsoft.com... > > > > 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 > > > >> santus(a)penn.com > > > >> > > > >> > > > >> "Lenee" <Lenee(a)discussions.microsoft.com> wrote in message > > > >> news:A5BB1169-7B01-4686-A0AF-8B6C4D9FA487(a)microsoft.com... > > > >> >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 > > > >> > > > >> > > > >> . > > > >> > > > > > > > > > . > > > > > > > > > . > > > > > . >
First
|
Prev
|
Pages: 1 2 3 4 Prev: Access 2007 Read Only Issue Next: Keith, Your information was just what I needed. |