2 start up forms

[lasitha]

Hi All,

I have 2 start-up forms. I want to pop-up one form according to logon user. Is it possible to do this through the vba code?

Thaking you all,

Lasitha.

 

[KenReay]

Hi

Yes

Actual vba code depends on if you are talking about the Users Network Login id, or their Access (security) log in

For Access login id you can use CurrentUser() - but this is only practical if you have implemented Access Security, or at least the log in portion of it, otherwise it will always return "Admin"

If you want Netork login id see

http://www.mvps.org/access/api/api0008.htm

Basically what you need to do is to set your start up options to run some code

the outline of what you need in that code is

If CurrentUser() = "A UserId" Then
' open form 1
Else
' open form 2
end If

in practice if you have several users and / or to make it so that adition of new users or removal of old users does not require changes to the code, you may wish to consider havinga table which lists the users and tells you which start up form is applicable to them. Then look up the user in the table and open the appropriate form


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK