Startup with Security

[accessman2]

Hi,

I setup 2 users security.

I want to setup startup page for 2 users, but different startup page.

I want to setup one startup page for user 1
I want to setup another startup page for user 2.

How can i make that? Because there is one option to fix the startup page.

Thanks.

 

[Smart]

On your start up page you can check which user is logged in if user 1 is logged in open user 1 form close startup form
if user 2 is logged in open user2 form close startup

 

[accessman2]

I don't get it.

I open my startup form,

it only have Application Title, Display Form/Page, Application Icon, shortcut menu bar, and menu bar option..

Where Can I set user ?

Thanks.

 

[GUIDO22]

Hi,

I setup 2 users security.

I want to setup startup page for 2 users, but different startup page.

I want to setup one startup page for user 1
I want to setup another startup page for user 2.

How can i make that? Because there is one option to fix the startup page.

Thanks.

You have already stated that you have set up 2 users - by this I presume you mean you have defined a 'UserGroup' and created each user within that UserGroup????

If that is the case - I would use one form and simply use create two sets of controls for each user on the one form. When the form loads - check the usergroup of the user and hide/display the controls accordingly.....

 

[accessman2]

So,

when the form load, how does the form detect the user?

Do I need to write about the Security code?

Thanks.

 

[ghudson]

Do I need to write about the Security code?

NO, you need to "read" about the Security code.

You need to do a little research and search the forum and read how to setup security and also how to disable/enable & view/hide your database objects based on your users security.

The answers are out there. User the forums search function and try to learn something instead of just posting your lazy questions.

 

[Laurentech]

application.currentuser will give you the username of the currently logged in user.

Larry

 

[oxfordian3]

autoexec macro

You might set up a macro named "autoexec" to call a Sub when the
database is opened. The Sub would open the initial form, so you would not set up an initial form via the Startup options.

The Sub might use application.currentuser mentioned in the previous post to set up the proper initial interface.

Of course, any of these startup techniques can be easily bypassed, so they are not really "secure" solutions.