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.

"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

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]

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.

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.

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.

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.

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.






.

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.






.

"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.