PIN and related info

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

I have a database shared by several users. To intiate the
db the user types in a 6 digit PIN. My question is this.
Is there a way to link the PIN that is entered in the "Log
on" window to information in the db?
Can you use the PIN entered in the log on to indicate what
information to display in a given window in the db?
Its much like when you set up parameters for a report or
query. I would like the PIN entered in the begining to be
used to display just the information that relates to that
PIN. (the PIN is also used when the employee enters
individual productivity stats) ie...the information
displayed on the initial pop up form is only information
entered in by the PIN.
 
Antonio said:
I have a database shared by several users. To intiate the
db the user types in a 6 digit PIN. My question is this.
Is there a way to link the PIN that is entered in the "Log
on" window to information in the db?
Can you use the PIN entered in the log on to indicate what
information to display in a given window in the db?
Its much like when you set up parameters for a report or
query. I would like the PIN entered in the begining to be
used to display just the information that relates to that
PIN. (the PIN is also used when the employee enters
individual productivity stats) ie...the information
displayed on the initial pop up form is only information
entered in by the PIN.
Click to expand...

You can use a global variable, or even better an open, but hidden, form to
store the PIN. Filter your queries by using a reference to the control on
the hidden form in the criteria box: Something like:

Select * From tblWhatever Where PIN = "AM1234"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You can create atble that will contain:

FormName SecuredFormElement PIN number

Then based on the global variable, like Arvyn suggested - turn the form
elements to not visible on the FormOpen event associated Sub.
 
i'd use a private variable in a module with 2 public functions: 1 getter, 1
setter; to act as a class.
so you can call public functions anywhere in your database such as in a
query.
 
Back
Top