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 |
#1
|
|||
|
|||
designing an engineering drawing db
I am designing an engineering drawing db
I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. |
#2
|
|||
|
|||
designing an engineering drawing db
"chynewalker" wrote in message
... I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. Why not have a % progress complete field which, when 100 is entered, the current date is auto-recorded? Failing that, trigger the date from "complete" being chosen from a combo box. Keith. www.keithwilby.co.uk |
#3
|
|||
|
|||
designing an engineering drawing db
On Mon, 1 Feb 2010 08:32:01 -0800, chynewalker
wrote: I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. Two fields is the correct design (I think we've discussed this in another newsgroup). If (as you should!) you use a Form to enter and edit the data, you can set the date field in the AfterUpdate event of the status field. I'd use a Combo Box to select the status; you could use a macro in its AfterUpdate event to set the datestamp field. Use the SetValue action and set the field to =Date(). -- John W. Vinson [MVP] |
#4
|
|||
|
|||
designing an engineering drawing db
Hello,
I am an engineer. I have done several databases for managing drawings. For Status, use an option group. You don't need "not started". If a drawing has no status, it is not started. I recommend that you enter a date for each status. This will tell you when a drawing was started, when it began to be checked (preliminary completion) and when it was done. So an option group and a date text box is what you need. Steve "chynewalker" wrote in message ... I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. |
#5
|
|||
|
|||
designing an engineering drawing db
Yes, I am using a form... thanks for the input, I will try the suggestions out
"chynewalker" wrote: I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. |
#6
|
|||
|
|||
designing an engineering drawing db
Would this approach require a total "remodel" every time a new status code
was introduced? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message ... Hello, I am an engineer. I have done several databases for managing drawings. For Status, use an option group. You don't need "not started". If a drawing has no status, it is not started. I recommend that you enter a date for each status. This will tell you when a drawing was started, when it began to be checked (preliminary completion) and when it was done. So an option group and a date text box is what you need. Steve "chynewalker" wrote in message ... I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. |
#7
|
|||
|
|||
designing an engineering drawing db
Engineering drawings are done in three stages:
1 In process 2 Check 3 Completed Revisions go through the same three stages. There is no "revision" stage. In my many years of engineering experience working with small and very large engineering firms, I have never seen any other status code. Structly speaking though, you are correct! Steve Jeff Boyce" wrote in message ... Would this approach require a total "remodel" every time a new status code was introduced? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message ... Hello, I am an engineer. I have done several databases for managing drawings. For Status, use an option group. You don't need "not started". If a drawing has no status, it is not started. I recommend that you enter a date for each status. This will tell you when a drawing was started, when it began to be checked (preliminary completion) and when it was done. So an option group and a date text box is what you need. Steve "chynewalker" wrote in message ... I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. |
#8
|
|||
|
|||
designing an engineering drawing db
I am not an engineer but I have had the privilege of reviewing their work for
so odd 25-30 years and have seen many other status like -- Propose Proposed REV As-Built Final The Floor Plan might have five revisions, three proposed revisions, and 2 as-built in the works at any one time. Kinda a nightmare for QA to verify the configuration for audit or checking as-built to the plant. -- Build a little, test a little. "Steve" wrote: Engineering drawings are done in three stages: 1 In process 2 Check 3 Completed Revisions go through the same three stages. There is no "revision" stage. In my many years of engineering experience working with small and very large engineering firms, I have never seen any other status code. Structly speaking though, you are correct! Steve Jeff Boyce" wrote in message ... Would this approach require a total "remodel" every time a new status code was introduced? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message ... Hello, I am an engineer. I have done several databases for managing drawings. For Status, use an option group. You don't need "not started". If a drawing has no status, it is not started. I recommend that you enter a date for each status. This will tell you when a drawing was started, when it began to be checked (preliminary completion) and when it was done. So an option group and a date text box is what you need. Steve "chynewalker" wrote in message ... I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. . |
#9
|
|||
|
|||
designing an engineering drawing db
These are not status! The first three are attributes of drawings and "Final"
is the same as "Completed". It's not a nightmare for QA at all! Steve "KARL DEWEY" wrote in message ... I am not an engineer but I have had the privilege of reviewing their work for so odd 25-30 years and have seen many other status like -- Propose Proposed REV As-Built Final The Floor Plan might have five revisions, three proposed revisions, and 2 as-built in the works at any one time. Kinda a nightmare for QA to verify the configuration for audit or checking as-built to the plant. -- Build a little, test a little. "Steve" wrote: Engineering drawings are done in three stages: 1 In process 2 Check 3 Completed Revisions go through the same three stages. There is no "revision" stage. In my many years of engineering experience working with small and very large engineering firms, I have never seen any other status code. Structly speaking though, you are correct! Steve Jeff Boyce" wrote in message ... Would this approach require a total "remodel" every time a new status code was introduced? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message ... Hello, I am an engineer. I have done several databases for managing drawings. For Status, use an option group. You don't need "not started". If a drawing has no status, it is not started. I recommend that you enter a date for each status. This will tell you when a drawing was started, when it began to be checked (preliminary completion) and when it was done. So an option group and a date text box is what you need. Steve "chynewalker" wrote in message ... I am designing an engineering drawing db I need to have a drawing status feild that i can choose "not started" "in process" "in checking" and when it is done "complete", but when it is complete i want a date How can i do this? right now we have an old clunky db that has 2 feilds, so when you complete the job you have to change "in process" to "complete" and then give it an approved date in another field. . |
#10
|
|||
|
|||
designing an engineering drawing db
"Steve" wrote in message
... Engineering drawings are done in three stages: 1 In process 2 Check 3 Completed Revisions go through the same three stages. There is no "revision" stage. In my many years of engineering experience working with small and very large engineering firms, I have never seen any other status code. Then you have very limited experience indeed. I work for a huge engineering multi-national and the drawing production process varies between business units. I have seen many variations but never the one you describe. That's not to say it's invalid but it is also not a global standard. |
|
Thread Tools | |
Display Modes | |
|
|