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
|
|||
|
|||
Table/Forms Design Question
Not stalking... not sure where you get that from. Here I am here now and I
see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve "Gina Whipp" wrote in message ... I am a little busy right now BUT if no one gets back to you by the time I get UNbusy I will review your tables. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#13
|
|||
|
|||
Table/Forms Design Question
Here are my Relationships so far
( http://img210.imageshack.us/img210/4...ellsample3.png ) I had to change few fields in tables from "text" to "number" in order to link them. You probably know that. In order to to the totals should TblWorkerCrew be linked to TblWorker Type? So these 3 fields will be together in a form I would create for a user? or its not necessary? Thanks "Damian" wrote: Great advice. I renamed the tables and I think You are right. It will avoid confusion. So far I have this: ( http://img263.imageshack.us/img263/1...ellsample2.png ) Image for easier view and review. What my goal is: To create a form for a user which has Defined fields for WorkerType, Underneeth Worker Name, and across CrewName all there because there are only handfull of guys for each WorkerType. The User will input only a number of CrewName he/she had for that day.. So if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her. She would only enter 1 , 2 , 4 under her row for each CrewName. Then have fields for totaling each thing automatically. Is this all passible with a form or do I have to do the totals as a querie and then create a summary report? Am I making sense? The first excell image I think explains it very nice what I mean. Thanks Guys for helping me with this. "Steve" wrote: Hello Damian, Your tables are still incorrect. To start, how about for clarity naming the people Workers. The naming a group of workers Crew. TblWorkerType WorkerTypeID WorkerType TblWorker WorkerID WorkerFName WorkerLName WorkerTypeID TblCrew CrewID CrewName for identifying different crews TblCrewWorker CrewWorkerID CrewID WorkerID You can count the types of workers in a crew in a totals query that includes all the above tables on the fly. Steve "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#14
|
|||
|
|||
Table/Forms Design Question
It certainly is stalking when you track my responses to OPs and interject
false statements. Stalking is a criminal act!!! Steve "Gina Whipp" wrote in message ... Not stalking... not sure where you get that from. Here I am here now and I see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve "Gina Whipp" wrote in message ... I am a little busy right now BUT if no one gets back to you by the time I get UNbusy I will review your tables. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#15
|
|||
|
|||
Table/Forms Design Question
You added more to the description of your database and now It seems you need
to modify your tables again! Consider: TblForeman ForemanID ForemanFName ForemanLName other foreman fields you might need TblDailyJob DailyJobID DailyJobDate DailyJobDescription ForemanID other job fields you might need TblDailyJobWorker DailyJobWorkerID DailyJobID WorkerID Keep previous TblWorkerType and TblWorker. Delete TblCrew and TblCrewWorker. You can get the names in a "crew" by getting all the workers on a specific daily job. Steve "Damian" wrote in message ... Great advice. I renamed the tables and I think You are right. It will avoid confusion. So far I have this: ( http://img263.imageshack.us/img263/1...ellsample2.png ) Image for easier view and review. What my goal is: To create a form for a user which has Defined fields for WorkerType, Underneeth Worker Name, and across CrewName all there because there are only handfull of guys for each WorkerType. The User will input only a number of CrewName he/she had for that day.. So if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her. She would only enter 1 , 2 , 4 under her row for each CrewName. Then have fields for totaling each thing automatically. Is this all passible with a form or do I have to do the totals as a querie and then create a summary report? Am I making sense? The first excell image I think explains it very nice what I mean. Thanks Guys for helping me with this. "Steve" wrote: Hello Damian, Your tables are still incorrect. To start, how about for clarity naming the people Workers. The naming a group of workers Crew. TblWorkerType WorkerTypeID WorkerType TblWorker WorkerID WorkerFName WorkerLName WorkerTypeID TblCrew CrewID CrewName for identifying different crews TblCrewWorker CrewWorkerID CrewID WorkerID You can count the types of workers in a crew in a totals query that includes all the above tables on the fly. Steve "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#16
|
|||
|
|||
Table/Forms Design Question
Steve,
I do track your responses, along with others, but yours because you keep offering fee-based services in a FREE newsgroup and I feel the OP has a right to get their question answered for FREE in this FREE forum. I do not interject false statements and certainly not where it concerns you. I am not *stalking* you or anyone else, perhaps you should look up the word in the dictionary. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... It certainly is stalking when you track my responses to OPs and interject false statements. Stalking is a criminal act!!! Steve "Gina Whipp" wrote in message ... Not stalking... not sure where you get that from. Here I am here now and I see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve "Gina Whipp" wrote in message ... I am a little busy right now BUT if no one gets back to you by the time I get UNbusy I will review your tables. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#17
|
|||
|
|||
Table/Forms Design Question
stevie, you really have problems.
have you considered that if you were not harrassing the posters to these newsgroups for unreasonable work at imodest prices that Gina andthe rest of us would not be on your case? John... Visio MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... It certainly is stalking when you track my responses to OPs and interject false statements. Stalking is a criminal act!!! Steve "Gina Whipp" wrote in message ... Not stalking... not sure where you get that from. Here I am here now and I see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve |
#18
|
|||
|
|||
Table/Forms Design Question
Steve has a special dictionary. It appears that the letter "R" is missing
and he confuses Free for Fee. Actually, he is just confused. John... VIsio MVP PS: Thanks for STALKING the posters to these newsgroups and providing helpful answers to their questions. "Gina Whipp" wrote in message ... Steve, I do track your responses, along with others, but yours because you keep offering fee-based services in a FREE newsgroup and I feel the OP has a right to get their question answered for FREE in this FREE forum. I do not interject false statements and certainly not where it concerns you. I am not *stalking* you or anyone else, perhaps you should look up the word in the dictionary. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... It certainly is stalking when you track my responses to OPs and interject false statements. Stalking is a criminal act!!! Steve "Gina Whipp" wrote in message ... Not stalking... not sure where you get that from. Here I am here now and I see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve "Gina Whipp" wrote in message ... I am a little busy right now BUT if no one gets back to you by the time I get UNbusy I will review your tables. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#19
|
|||
|
|||
Table/Forms Design Question
And thank you... for the P.S. part... as for Steve well, he's just special.
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John... Visio MVP" wrote in message ... Steve has a special dictionary. It appears that the letter "R" is missing and he confuses Free for Fee. Actually, he is just confused. John... VIsio MVP PS: Thanks for STALKING the posters to these newsgroups and providing helpful answers to their questions. "Gina Whipp" wrote in message ... Steve, I do track your responses, along with others, but yours because you keep offering fee-based services in a FREE newsgroup and I feel the OP has a right to get their question answered for FREE in this FREE forum. I do not interject false statements and certainly not where it concerns you. I am not *stalking* you or anyone else, perhaps you should look up the word in the dictionary. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... It certainly is stalking when you track my responses to OPs and interject false statements. Stalking is a criminal act!!! Steve "Gina Whipp" wrote in message ... Not stalking... not sure where you get that from. Here I am here now and I see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve "Gina Whipp" wrote in message ... I am a little busy right now BUT if no one gets back to you by the time I get UNbusy I will review your tables. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
#20
|
|||
|
|||
Table/Forms Design Question
I do track your responses
I am not *stalking* you You're a hypocrtite who speaks out of both sides of your mouth. Perhaps you should look up the word stalking in the dictionary. Stalking is a criminal act and I am recording each time you interject anything destructive to one of my posts. Steve "Gina Whipp" wrote in message ... Steve, I do track your responses, along with others, but yours because you keep offering fee-based services in a FREE newsgroup and I feel the OP has a right to get their question answered for FREE in this FREE forum. I do not interject false statements and certainly not where it concerns you. I am not *stalking* you or anyone else, perhaps you should look up the word in the dictionary. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... It certainly is stalking when you track my responses to OPs and interject false statements. Stalking is a criminal act!!! Steve "Gina Whipp" wrote in message ... Not stalking... not sure where you get that from. Here I am here now and I see you provided the tables I would thank you but you would probably find a way to twist that around... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... You are too busy to answer the OP but not to busy to stalk me! Go figure??? Steve "Gina Whipp" wrote in message ... I am a little busy right now BUT if no one gets back to you by the time I get UNbusy I will review your tables. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Damian" wrote in message ... Made a mistake. Is there an Edit button here? hmm Correction on the Tables: So Far I have 3 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table so you can choose from drop down menu. Crews Data t_CrewDataID autoNumber PK t_CrewDataType will be Foreman, Workman, Laborer Crews Type t_CrewDetailID autoNumber t_CrewDetailType will be Carpenter, Surveyor, Laborman Sorry "Damian" wrote: Great Help, thanks to all for info and great links. I'm starting to get the Big Picture now. The only thing I am confused is how will I buld a Form for the guys to fill out. Maybe I should explain what I want to accomplish here. So Far I have 2 Tables: Crews Neme t_CrewID autoNumber PK t_CrewFname first name t_CrewLname last name t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table Crews Data t_CrewsDataID autoNumber PK t_CrewsDataType will be Foreman, Workman, Laborer (Now the data Value that you mentioned 1 , 3 , 2 is the amount of Foreman/Workman/Laborer each Crew had. This field is to be inserted by the user. so should I still have a DataValue field in my Crews Data table when it will be different for every t_CrewID and every T_CrewsID will have all t_CrewsDataTypes?) I have an excell for this but I want to create a databaseto do this. I took a screenshot of the excell so you can understand it and help me better. (Hope is ok to post links here like these, if not I am sorry) (http://img21.imageshack.us/img21/6924/excellsample.png) Thanks Again "John W. Vinson" wrote: On Thu, 23 Jul 2009 13:36:01 -0700, Damian wrote: I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers. ex. "Carpenters Table CarpentersName Foreman Worekman Laborer Joe 2 1 5 Bill 1 5 2 " "Laborers Table LaborersName Foreman Worekman Laborer Frank 1 1 0 " And so on (you get the picture) Now are those tables Normalized? I know I am repeating Foreman,Workman & Laborer in each one of them but each of these tables has different Names and different quantaties of people. I'd change your design completely. Putting data (the type of worker) in a tablename or a fieldname is simply WRONG DESIGN. Workers WorkerID Primary Key, perhaps an autonumber WorkerName (I'd actually use LastName and FirstName as separate fields WorkerType e.g. Carpenter, Laborer, Surveyor, ... WorkerData WorkerID link to Workers DataType e.g. "Foreman", "Laborer" DataValue your 2, 1, 5 etc., whatever they mean I created a form for Carpenters - A tabular form so I see All names for each Carpenter in seperate box and next to them their Foreman/Workman/Laborer. I also included a total column at the end which adds up each row. I can edit the fields each day and the total is changing. (thats good) The problem is I have to create a Form for Each Table seperately. Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view it and edit like I can the single Carpenters Form? I cant seem to make it work. Im reading all these access books and I cant find the answers I am looking for anywhere. I also created a Querie that sum up all Foreman for each Name each workman for each name and so on. Plus a final total Column which sums up everyone. It works great, BUT when I try to make it show up on the Form I cant. I can do it as a footer but it does not automatically update when I change the values. I have to close it and come back in. Why is that? I know I am asking a lot and I hope you guys can help me. Thank you Get your table design right first and then work on the forms. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|