Re: MSGBOX

Tech-Archive recommends: Fix windows errors by optimizing your registry

For the code to save and print the record, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

To lock your form so that no edits are allowed after a record has been
entered, set the form's AllowEdits property to No. You probably want to set
AllowDeletions to No as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <johnlee2509@xxxxxxxxxxxxxxx> wrote in message
news:OsjdBi6BGHA.312@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> I would like to implement a POP Up MsgBox on my form when I select a
> Command Button called "Print"
>
> It should show 3 lines of text, 2 Buttons, a title and an Icon
>
> i.e.
>
> ----------------------------
> On Clicking the print button...
>
> You are about to print this record
> Doing so will also lock the record for any further editing.
> Are you sure you want to do that?
>
> vbOk vbCancel
>
> Exclamation mark Icon
> -----------------------------
>
> vbOk button should print a report called rptSalesReceipt
> vbCancel should cancel the msgbox and printing events.
>
> Any help Please
>
> Regards
>
> John


.

Quantcast