Can I hide a record from my users?

  • Thread starter Thread starter Gabe
  • Start date Start date
G

Gabe

I have a form linked to a query which retrieves info.
from several tables. Two of the records in my form are
for just my use, they are my own code for being able to
quickly and efficiently if the windows in the form are
linking to the right column in the right table. Is there
anyway I can hide these two records so my users don't see
them and get confused? Unhiding them only when I need to
see them? Thanks, Gabe
 
If you have access security set up, then you can show or hide fields based
on the current user logged on ( to Access ). See help on the CurrentUser()
function.

Without that, there is a Windows API call which will give you the current
user logged onto Windows, and you can use this to set visibility.
See http://www.mvps.org/access/api/api0008.htm

If you only need this for your own info occasionally, consider just making
the fields not visible normally, and when you want to see them, go into
design view and reset the properties to visible temporarily.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top