Separate store's managers to only see their store's data

[snipe]

What's up guys,



I have "Reporting" program that is store on our server. All of our 8 store's managers have access to this program. None of them are very good with computers. Currently, the manager will type in a date range and store number and press the desired report button. The sales manager has recently found out that any manager can see any other store's reports. These reports include certain confidential data such as pay, bonuses, performance, etc.

What I would like is as follows:

At the main switchboard, you click the "Reporting" program button. A password modal pops up (no username). This password tells the program what store number to use in all of the report options.

What is the best way to accomplish this? I figured I would need to have a table with a list of passwords and store numbers. I just don't know how to actually get that store number to be used in the reports without that password having to be typed in every time (like a parameter).

[pbaldy]

One way would be a DLookup() to make sure it was a valid password and to find the associated store. Put the store number in a hidden textbox on the main switchboard (or wherever) and have the report queries use that textbox in their criteria.

[snipe]

Ah that could work.

One other question. I would like to have a master password. If used maybe it unhides that textbox so the user could type in whichever store they want; or something similar. How could I do that?

[pbaldy]

You could make the store number for that password "Master" or 77777 (or whatever, depending on whether your field is text or numeric) and test for the result of the DLookup() equaling that. If it is, unhide the textbox.

[snipe]

Nice! That should work great. I'll post if I have any issues. I appreciate the help!

[snipe]

Is this the best way to do this:

I have 2 forms: F_Password and F_Reports
F_Password is a small form with a text box, log in button, and cancel button. Modal is set to yes. The code attached to the log in button has the dlookup (which works great, thanks again) and a docmd to open F_Reports. The dlookup stores the result as StoreValue which globally declared (I think that is what it is called... its at the top of the code, before any of the subs).

In the On Load event for F_Reports, I was going to have a Select case for the StoreValue string. The outcome of the cases would be to set the store value as the hidden text box, or to unhide the text box.

Should that work? Is there a better way?

[snipe]

I'm stuck. I can't get StoreValue to get read by F_Reports.

Also, what's the easiest way to make it so after typing a password, pressing Enter does the same thing as clicking the Log In button?

[pbaldy]

You can use the after update event of the textbox to avoid having to click on a button. As to the variable, it shouldn't be in the form module, it should be in a standard module and declared like:

Public VariableName As DataType

[snipe]

Figured the module issue out a few minutes ago, then just hit F5 on here. I ended up using openargs on the docmd.openform and everything is working like a charm! I really appreciate all of the help!

[pbaldy]

Happy to help!