UserSeesOnlyHisRecords.mdb (beginner)

Please consider donating $1 per sample downloaded, find out why here
Download
UserSeesOnlyHisRecords.zip
Access 97 (18 KB)

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.

 

Feedback

 

Need Winzip?

Return to Main Page