Creating an Access Code of somesort

[ChrisSedgwick]

Hi guys,

I've hit a bit of a brick wall when completing a form build.

Basically I have created a form that allows the user to raise an installation order. The form works perfectly and takes all of the information from the form (which is stored in tables) and places it into a nice Report that looks like an invoice, however we call it an installation order. This is then sent on to a fitter, almost like an instruction or purchase order.

However, we've got to the stage now, where these are just being sent out for fun and the costs are mounting. So I'm looking for a way where as we click on a command button to preview and send the report (already in place), a dialog box pops up and asks the user for a numerical code, or password, or something that only a manager can enter. Once the manager enters the code, the user can then proceed to preview the report and send.

This way we a manager can view what is being sent to a fitter, before it's actually sent.

Has anyone ever come across something like this and can provide a solution? I'm open to alternatives.

Many thanks,
Chris.

 

[Minty]

I would add a field called AuthCode or something similar, that can only be got to on a manager access restricted form. On your normal form simply don't let the code run if the AuthCode is null , pop up the messagebox.

I would probably build the manager a "Waiting Approval" form listing all unapproved orders with a simple option for him to fill out the authority code. Saves him having to keep looking for them.

Edit - or add AuthoriseBy if you have an employee ID and a AuthDate for better tracking ?