VB Form Security

Yahoo Archive
1
What you could do is to setup a progress procedure to capture the value of the field when the VBform is opened. Then have another progress procedure attached to the close/save/OK button that checks the DCD users ID, if it is not the allowed user, then compare the VBform field screen value to the saved value upon form entry. If they are different, reset the screen value (voiding the change) and pop up a message telling the user he/she is not allowed to edit that field and that it has been reset to it initial value.

Other than that, I don't think you can lock out users from the VBform or fields. The field layout is stored in the database "VBFormDetail" and the fields are created/displayed upon accessing the form.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Moore, Jim (Anniston)
Sent: Friday, June 03, 2005 9:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] VB Form Security


Does anyone know if it is possible to add security to a VB form.
We have a VB form for each of our Vendors listing what type business they
are, small, veteran ect.
I don't think there is a way to set the security via Vantage, but can anyone
tell me if it can be done via Windows security?
I would like to give only one user the ability to make these changes.
Where would I find the VB file if I could?
Any help is much appreciated.

Jim Moore
GD-OTS
2
Does anyone know if it is possible to add security to a VB form.
We have a VB form for each of our Vendors listing what type business they
are, small, veteran ect.
I don't think there is a way to set the security via Vantage, but can anyone
tell me if it can be done via Windows security?
I would like to give only one user the ability to make these changes.
Where would I find the VB file if I could?
Any help is much appreciated.

Jim Moore
GD-OTS


[Non-text portions of this message have been removed]