Further advice on the code below

[Irshad Alam]

Earlier posted, problem not solved.

Please advise on below :

I viewed the website and hopefully I will be able to get the username But
please advise further how/where to do the coding of the startup so that it
will change the custom menubar and toolbar accordingly, as it has to be same
for that user for his login.

Regards

Irshad



:

Click to show or hide original message or reply text.

 

[pietlinden]

Earlier posted, problem not solved.

Please advise on below :

I viewed the website and hopefully I will be able to get the username But
please advise further how/where to do the coding of the startup so that it
will change the custom menubar and toolbar accordingly, as it has to be same
for that user for his login.

Regards

Irshad

:

Click to show or hide original message or reply text.

so put the Menubars and logonID's in a table and then when the
database loads, read the logonID, get the associated menubar, and show
the thing. How hard could it be? use DLookup or a recordset or
whatever...

 

[Irshad Alam]

Sir,

Thank you for your reply.

Sorry to say that I am not very good in VBA to do the coding for this
situation.

As you advised, I will make a table in which I can store the LogInId and
MenuBar Names (It will be about 4 LoginID and 4 Menubar Name).

Secondly the earlier advised code will give me the windowslogId name

But what code to write and how to call the code so that the menubar will
change according to loginID

If possible, any sample you can advice.

Pls. advice

regards

Irshad

 

[Irshad Alam]

waiting for your advice

Irshad

Sir,

Thank you for your reply.

Sorry to say that I am not very good in VBA to do the coding for this
situation.

As you advised, I will make a table in which I can store the LogInId and
MenuBar Names (It will be about 4 LoginID and 4 Menubar Name).

Secondly the earlier advised code will give me the windowslogId name

But what code to write and how to call the code so that the menubar will
change according to loginID

If possible, any sample you can advice.

Pls. advice

regards

Irshad