MS Access query

[junmar4]

---

Mga peeps,

I have an access database that I use along with my office, and I would like a screen that pops up when I start Access and asks if I am a user or admin, and then prompts for a password is I am an admin. If a user is selected, it will go to a form (already created) for users, or a different form for admins. Once the admin is authenticated, I would like for him to have full access to all menus and design elements, but the users should not.

Possible ba ni? Unsaon?

[nullpointer]

Its possible sir. You look for a VBA programmer or you study VBA programming...

[san_cristobal]

Pwede ra na macro sa ms access... ang mka tabang na lng jud nimo Pre kay Google.

sample: MS Access Tutorial - Forms

[rugby_boys]

mahimo jud na siya....naa ra kay irestrict ana...

[michaelocana]

set a startup form bro then in that form insert a controls nga mo select sya as admin or users then show/hide nalang
ang controls for username and password after click sa login..mo adto dayon sa main form/menu nmo....

good luck!

[sanggano_boy]

there's a solution:

1. you can use workgroup( where you can ceate users and set user rights for tables,forms and queries)
2. or you can create you customize user security form
3. i can program it for you