How can I mask data in a query?

[Francis Debrabandere]

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.

[Mal]

Re: How can I mask data in a query?

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" <francisdebraba ndere@hotmail.c om> wrote in message
news:48b4de9e.0 403060821.4d81f 9fb@posting.goo gle.com...[color=blue]
> 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.[/color]

[Alan Webb]

Re: How can I mask data in a query?

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" <francisdebraba ndere@hotmail.c om> wrote in message
news:48b4de9e.0 403060821.4d81f 9fb@posting.goo gle.com...[color=blue]
> 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.[/color]