|Please consider donating $1 per sample downloaded, (find out why here)|
Joined: 20 Feb 2008
Posted: 15 Jul 2008 at 10:43pm
Please consider donating $1 per sample downloaded, find out why here.
This sample shows how you can restrict data being displayed to just those records that match the user's network Login ID.
Here's how it works:
The autoexec macro opens then hides the FLogin form. You could even use a splash screen if you want, just HIDE it instead of closing it in the Timer event.In the OnOpen event of the FLogin form, there is code that populates the textbox with the users login name. It calls the GetCurrentUserName() function in the UserComputer module.
Notice the query returns 0 rows, because you are not in the database. Change one of the records in the table to your name and loginid, and try it again.
You will need to import the module and the FLogin form into your application and change the autoexec macro to include the steps that mine has. You will also need to change all of your queries to reference the textbox on the FLogin form, just like my query does.Download
Access 97 (18 KB): UserSeesOnlyHisRecords97.zip
Access 2000 (31 KB): UserSeesOnlyHisRecords2k.zip
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum