User Opens DB to a specific form

  • Thread starter Thread starter David Portwood
  • Start date Start date
D

David Portwood

I have three groups of users (representing three distinct sales orders
processing stages, if it matters) and a form for each group. Assuming I have
Workgroup Security set up properly (I'm still trying to understand this -
let me study it a little more) can I have the appropriate form come up
automatically when a member of a processing group opens the database? Also,
can I apply a filter so that the individual only sees his own records in
that group?

Since I'm asking for the Moon, I may a well ask for the Stars, too. Each
form has buttons taking the user to any of the other forms in the database.
When the user is a member of one of the aforementioned specific groups, I
don't want him to be able to click a button and go to another form that's
not applicable to him. How can I do this?
 
David,
Do a Google Access Groups serach on "public.access' "determine" "user group"
You get a lot of hits, (with code) that use several techniques to determine what
group/s a user belongs to.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
dude hell no

do you dipshits really use Access Jet Security?

WHat a joke

move to SQL Server you ****ing kids are retarded I mean jesus friggin
christ
 
Back
Top