Msg Box Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donbenz - 26 May 2006 16:22 GMT

I am using a message box Macro in designing a database to keep track of
incoming shipments. We check every 10th part we receive to make sure that
it passes inspection. So every tenth peice of data I need the msg box macro
to appear and ask if the part has passed inspection. If the answer is yes
than it will return to the original form. If the answer is no I need to know
how to send it to another database recording all of the faulty parts we
receive. Any help would be appreciated.

Reply to this Message

Steve Schapel - 26 May 2006 20:42 GMT

Donbenz,

It will be very difficult to detect "every 10th part" unless it's based
on actual data. Therefore you could add (if you don't already have) an
incrementing number field to the table. Then you could use a Condition
in the macro, something like this...
[NumberID]/10=[NumberID]\10

Signature

Steve Schapel, Microsoft Access MVP

> I am using a message box Macro in designing a database to keep track of
> incoming shipments. We check every 10th part we receive to make sure that
[quoted text clipped - 3 lines]
> how to send it to another database recording all of the faulty parts we
> receive. Any help would be appreciated.

Reply to this Message

Donbenz - 26 May 2006 21:03 GMT

Steve,

I do have an incrementing number field to my table. My other question is on
the msg box what code should i use to say if the no button is clicked I want
my form Check 5 Lot to come up.

Donbenz

> Donbenz,
>
[quoted text clipped - 11 lines]
> > how to send it to another database recording all of the faulty parts we
> > receive. Any help would be appreciated.

Reply to this Message

Steve Schapel - 26 May 2006 23:54 GMT

Donbenz,

You will need to do this in 2 steps. If I understand you correctly,
your macro might look something like this...

Condition: [NumberID]/10<>[NumberID]\10
Action: StopMacro

Condition: MsgBox("Pass muster?",36)=7
Action: OpenForm
Form Name: Check 5 Lot

By way of explanation, the 36 is comprised of 4 (the code for Yes and No
buttons on a messagebox) plus 32 (the code for a question mark icon on
the message box), and the 7 is the code for a No response.

Signature

Steve Schapel, Microsoft Access MVP

> Steve,
>
> I do have an incrementing number field to my table. My other question is on
> the msg box what code should i use to say if the no button is clicked I want
> my form Check 5 Lot to come up.

Reply to this Message