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" <(E-Mail Removed)> wrote in message
news:0943CE81-2CFE-4A9B-91A5-(E-Mail Removed)...
>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
<(E-Mail Removed)> 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
(E-Mail Removed)


"chynewalker" <(E-Mail Removed)> wrote in message
news:0943CE81-2CFE-4A9B-91A5-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
news:O$(E-Mail Removed)...
> 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
> (E-Mail Removed)
>
>
> "chynewalker" <(E-Mail Removed)> wrote in message
> news:0943CE81-2CFE-4A9B-91A5-(E-Mail Removed)...
>>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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:O$(E-Mail Removed)...
>> 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
>> (E-Mail Removed)
>>
>>
>> "chynewalker" <(E-Mail Removed)> wrote in message
>> news:0943CE81-2CFE-4A9B-91A5-(E-Mail Removed)...
>>>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > news:O$(E-Mail Removed)...
> >> 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
> >> (E-Mail Removed)
> >>
> >>
> >> "chynewalker" <(E-Mail Removed)> wrote in message
> >> news:0943CE81-2CFE-4A9B-91A5-(E-Mail Removed)...
> >>>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" <(E-Mail Removed)> wrote in message
news:83A45F25-3D78-4E17-8081-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> > news:O$(E-Mail Removed)...
>> >> 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
>> >> (E-Mail Removed)
>> >>
>> >>
>> >> "chynewalker" <(E-Mail Removed)> wrote in message
>> >> news:0943CE81-2CFE-4A9B-91A5-(E-Mail Removed)...
>> >>>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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.