Get the ip adresse // change the opening form

[mester]

Hi everyone,
Pleaaaaase i need your help, i have two questions.
1) how to get my IP adress into a txtbox by Vba?
2) how to change the form i choose in the application opening by another form using vba (see screenshot)

 

[Gasman]

Hi everyone,
Pleaaaaase i need your help, i have two questions.
1) how to get my IP adress into a txtbox by Vba?
2) how to change the form i choose in the application opening by another form using vba (see screenshot)

See this thread for 1. https://www.access-programmers.co.u...he-ip-address-into-table.311303/#post-1691340

For 2. Use your logic in VBA to decide what to open. A password form would likely be the opening form, then depending on the user you open the next form and close/hide that one.?

 

[Deleted member 147267]

If a password form isn't being used, you could use an AutoExec macro to run a function. That function could decide on which form to open when the db opens, based on some characteristic of the user. Setting this at the Options level requires you to close and re-open the db, so that option is of no use to you.

 

[mester]

If a password form isn't being used, you could use an AutoExec macro to run a function. That function could decide on which form to open when the db opens, based on some characteristic of the user. Setting this at the Options level requires you to close and re-open the db, so that option is of no use to you.

thanks for your help

 

[mester]

See this thread for 1. https://www.access-programmers.co.u...he-ip-address-into-table.311303/#post-1691340

For 2. Use your logic in VBA to decide what to open. A password form would likely be the opening form, then depending on the user you open the next form and close/hide that one.?

thanks for your reply and your help