By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

How can I mask data in a query?

P: n/a
Hi all,

I'm a beginner in ms access, and I'm working on my first real
application. But to finish it up I'm facing a problem. I'm not able to
solve and maybe someone can help me.
I have made a database that can be divided in two major parts:
1. entering data
2. reading the entered data.

Everybody who uses the database has access to the second part. The
first part is reserved for a couple of users. They only have access to
a predefined section of the database. To enter this section they need
to enter their individual password. I have built this feature based on
a query, that asks for a password, as soon the query is started. When
then pasword is entered, the user only get access to those elements
that are linked with that password in a table.
It's no problem to store these passwords in a table, and make them
unreadable for other people, if they should ever get in the table
section. I have used the option 'password' in the input-mask of the
password field. But what doesn't work is the following: when the user
enters his passwoord in the pop-up screen of the query, he can read
what he's entering. I would like to mask this input with '*', as
usually when a pasword is entered.
Does anyone know how I can do that, or do I have to go a completely
different way to make such thing work?

Francis.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Mal
Use a form (even a very small one - just for entering this info) and have an
unbound text field. You can set its mask to password and you'll get what you
want.
When "Ok" or "enter" is hit (a button you add to the form) the query is
launched
instead of having a [Enter Password] as the query criteria, you refer back
to the form
[forms!someForm!myPasswordField] as the criteria.

HTH
Mal.
"Francis Debrabandere" <fr*****************@hotmail.com> wrote in message
news:48**************************@posting.google.c om...
Hi all,

I'm a beginner in ms access, and I'm working on my first real
application. But to finish it up I'm facing a problem. I'm not able to
solve and maybe someone can help me.
I have made a database that can be divided in two major parts:
1. entering data
2. reading the entered data.

Everybody who uses the database has access to the second part. The
first part is reserved for a couple of users. They only have access to
a predefined section of the database. To enter this section they need
to enter their individual password. I have built this feature based on
a query, that asks for a password, as soon the query is started. When
then pasword is entered, the user only get access to those elements
that are linked with that password in a table.
It's no problem to store these passwords in a table, and make them
unreadable for other people, if they should ever get in the table
section. I have used the option 'password' in the input-mask of the
password field. But what doesn't work is the following: when the user
enters his passwoord in the pop-up screen of the query, he can read
what he's entering. I would like to mask this input with '*', as
usually when a pasword is entered.
Does anyone know how I can do that, or do I have to go a completely
different way to make such thing work?

Francis.

Nov 12 '05 #2

P: n/a
Francis,
Access' QBE grid allows captions and input masks to be defined for queries.
If you right-click on a column in the QBE grid and select properties, it's
one of the properties on the property sheet that shows up. You can also
define your input mask in the design view of a table created in Access.
Another poster here talked about forms but from your post it appears that
users are attempting an end-run around your forms and trying to open the
data directly--bad user--but it happens. Define the input mask in the query
and you should be fine.

"Francis Debrabandere" <fr*****************@hotmail.com> wrote in message
news:48**************************@posting.google.c om...
Hi all,

I'm a beginner in ms access, and I'm working on my first real
application. But to finish it up I'm facing a problem. I'm not able to
solve and maybe someone can help me.
I have made a database that can be divided in two major parts:
1. entering data
2. reading the entered data.

Everybody who uses the database has access to the second part. The
first part is reserved for a couple of users. They only have access to
a predefined section of the database. To enter this section they need
to enter their individual password. I have built this feature based on
a query, that asks for a password, as soon the query is started. When
then pasword is entered, the user only get access to those elements
that are linked with that password in a table.
It's no problem to store these passwords in a table, and make them
unreadable for other people, if they should ever get in the table
section. I have used the option 'password' in the input-mask of the
password field. But what doesn't work is the following: when the user
enters his passwoord in the pop-up screen of the query, he can read
what he's entering. I would like to mask this input with '*', as
usually when a pasword is entered.
Does anyone know how I can do that, or do I have to go a completely
different way to make such thing work?

Francis.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.