95
I have 140 concurrent users using GP ver 9.0.
I need to validate the users logging in to GP with an attendance system running in the office. Any user who has not marked his attendance should not be allowed to log in and use GP.
What exactly I am looking is to capture the login name at the earliest possible point during the login process.
Any help is
highly appreciated.
thanks
Jubith Kariyath
*This post is locked for comments
Hi Jubith,
You could set a trigger to the ACTIVITY table in the DYNAMICS DB... a new entry is created each time a user logs into GP and soon as the company is selected and confirmed, the record is created in the ACTIVITY table... with the trigger, you have all the flexibility that you want without having to modify anything on the GP client side (which could be quite complex if you start to use VBA and want to deploy this to all 140 users, unless you're using Citrix, and still the code has to be deployed into the GP client).
I use this mechanism to send me alert when reaching a certain amount of concurrent user licenses and keep a stats about my entries. With a history table I know this way my average consumption of user licenses every day.
Hi Jubith,
You can customize the login screen to using vba code to validate the users logging. To add the Login screen in vba
1. Open the login window; click Ctrl+F11 to add the window in visual basic.
2. Click shift +F11 to add the field to visual basic. Select the user name textbox or any other field you want to add
3. Click Alt+F11 to open the visual basic editor.
The login window will be available as WelcometoMicrosoftDynamics in the visual basic. You can write your code for validation on UserID field change and prevent user from login, if he/she is not present in attendance list.
For further details about using vba in customization refer to posts by Mariano Gomez
dynamicsgpblogster.blogspot.com/.../workshop-day-2-setting-up-vba-project.html
Rubal,
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
