Hide Certain Fields wherever they appera to Read-Only Users

[PaddyIrishMan]

Hi all,
After reaching page 19 in the newsgroup, I cant go on. Its the eyes you see,
they cant see anymore

I have ReadOnly users in my db that I do not want to allow to see certain
fields wherever they appear, be it in a table, form, query or report. Its to
do with medical info that should be kept private from them.

Any ideas?

Thanks in advance

PaddyIrishMan

 

[Gina Whipp]

PaddyIrishMan,

Is there any security set p on this database? Do Users have a log-in? What
version of Access? Which version may also depend on what is available. OR
do you have an Access FE and and SQL Server back-end? As you can see a
little more information would help...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[PaddyIrishMan]

Sorry about that, I have Access2003, with the database secured. There are 10
people with the same readonly user id and password. The database is stored on
a zip drive so no front/back end.

 

[Gina Whipp]

PaddyIrishMan,

I personally have never tried to hide fields based on a log on so here's a
stab at what you might try...

If CurrentUser = ????? Then
Me.SomeField.Visible = True
Else
Me.SomeField.Visible = False
End If


--
Gina Whipp


"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Star 766hi]

Just grant the user