UserSeesOnlyHisRecords.mdb (beginner) |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 15 Jul 2008 at 10:43pm |
Please consider donating $1 per sample downloaded, find out why here.
UserSeesOnlyHisRecords.mdb
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. DownloadAccess 97 (18 KB): UserSeesOnlyHisRecords97.zip Access 2000 (31 KB): UserSeesOnlyHisRecords2k.zip |
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
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 |