Search results

Yes! I tried the conditional part o the macro (there's a WHERE field) but it didn't work, I don't know why.

I created a form to do the work of the autoexec macro the way you suggested and it works!!! Didn't think about that before... Thanks a lot! :)

Humm.... by using the MsgBox "CurrentUser = " & CurrentUser I see that my users are indeed loging correctly and that I have their correct usernames. Maybe I was not clear when I explained my problem. I don't want to add the call on my form but would rather have it on the Autoexec macro so the...

Hi, I'm trying to get specific forms to open automatically based on the user that is using the database. I tried creating an Autoexec macro and having the following as parameters: Action: open form Form name: Welcome John View: Form Where condition: CurrentUser()=[john] Window Mode: Normal...

I'll take a look at the FAQ. Thanks a lot!

Shortcut? Humm... I haven't noticed any shortcuts on my desktop created by access. Maybe that's the problem. Anyways, what I tried to do is the following: 1. I went to User and Groups Accounts and created my users 2. Then I went to the User and Group permissions and selected for each user a...

Hi! I've been trying this now for some time and am getting frustrated. Any help is greatly appreciated :) I have a database with several forms and I'd like to limit access to the forms based on the user that logs in. For example, I want to set the following security: User: Sales Opens only...