Help with bug fix!

[paulreed]

I picked up a sample db from this forum which creates a security log-on for users to access databases, and although it can no doubt be easily overridden, it is ideal for what I need.
Unfortunatly, the app has a bug which I cannot fix, and would appreciate help.
The app creates a log of 'users', log-on times, and log-off times, but for whatever reason, it fails to record the 'log-off' time/date in the tblLogTimes, and the log errors when you try and view it. Otherwise it works fine.

I have attached the db and would appreciate your help.

 

[pdx_man]

The field names have changed from LoggedOn/LoggedOff to LoggedIn/LoggedOut. Make the changes in the query and the Sorting and Grouping in the Report.

 

[paulreed]

Brian from St Louis, USA, has also found another bug in the baslogon module;

In the Module "basLogOn" go to the "LogUserOff" routine and change this:
rst!LoggedOff = Now()
to this
rst!LoggedOut = Now()

If you amend this code, it will record the log off times as well.

Thanks to Brian.

 

[Oldsoftboss]

That example is one I came across and posted. Can you post the thread so I can correct the errors and have a correct example.

Dave

 

[Oldsoftboss]

You might be able to include the encription from Mile-O-Phile at this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=61761&highlight=security

Dave