Input Mask Issues

  • Thread starter Thread starter James
  • Start date Start date
J

James

Yeah it seems like a good Idea its just tht I have set up
the security myself through code... thats why I need the
input mask plus its only a couple of records I dont need
certain users to see they can see the rest just not a
specific few depending on the user...

Thanks

James
-----Original Message-----


Use different forms, or even different front end mdbs for users with
different security levels. You must have some idea of how frustrating it is
to be shown greyed-out controls because you are the wrong sort of user. It
is kinder just to show them what they are able to interact with.

HTH


Tim F
Click to expand...

Hello I have a database where I wish mask some data from
certian users... so for exaple if I put in teh code for:

If UserID = Joe Bloggs then
DATAHERE = inputmask.password

Or something?

How could I achieve this?

Thanks

James
 
How could I achieve this?
Click to expand...

As I said above: the definitive answer is to use Access security, which
will enable you to limit users' access to data by record and by column. It
is not for the feint-hearted, however, and you will need to do a lot of
reading and a lot of preparation first.

A simpler way, particularly if you have unsophisticated users, is just to
give them their own front ends that only display the information they are
entitled to see or update.

Hope that helps


Tim F
 
How would I create multiple front ends? and also is there
no way of doing this through coding?

Thanks

James
 
How would I create multiple front ends? and also is there
no way of doing this through coding?
Click to expand...

File... New... Empty database... start creating forms.

In my experience it is easier to maintain and debug a set of mdb's with a
few simple forms, than one massive multi-purpose bloated monstrosity that
keeps breaking.

I have also used databases and web forms where it has been decided that I
cannot see some information (fair enough) but I still get to see the empty
grey boxes to remind me of the fact (not fair, not nice and shouldn't be
done). It is better just to create a new form with only the fields that are
actually in use.

(This paragraph has been hidden because you just might not be clever enough
to understand it or have enough security clearance to see it....)

And that is why I said what I said.

Hope it helps



Tim F
 
Ok thanks for that....

Is there a way of selecting a specific part of any
records? Like for example...

If I were to have a records with names address and date of
birth... for example... could I not say on Joe Bloggs's
record password (input mask) his date of birth for one
reason or another?

Thanks

James
 
If I were to have a records with names address and date of
birth... for example... could I not say on Joe Bloggs's
record password (input mask) his date of birth for one
reason or another?
Click to expand...

You can do anything you want, and the OnCurrent event would be suitable if
you really feel that this is a good way to present the user interface.

<sigh>

Tim F
 
Back
Top