Me.Filter based on particular selection

[June7]

I was afraid that might be throwing a lot at you at once. Those procedures manage not only the user login but also makes sure users have the latest version of the frontend because the project is split design. This thread http://forums.aspfree.com/microsoft-...tc-324677.html describes the versioning setup more. The good stuff starts at post 7.



No, the network login does not appear again. If computers are on a network environment, users will login. Then can run the Access frontend on their workstation (the data tables are in another Access file on the network file server - the 'backend'). The Access code pulls the user's network login username and compares with records in user table. If no match then this is user's first time in the database and they will have to enter initials. We just want initials for saving in records to document work processes. We don't do this 'login' for security reasons so no passwords. I designed the db 'login' to be automated if the user is known. I make assumption that anyone who logs into our network is a valid user of the database. The frontend of the database is actually installed only on some computers in the office. Of course, anyone can login to the network from any computer. The db 'login' is a simple form with a single unbound textbox for entering initials and some instructional labels.

1. Makes sure only 2 or 3 letters given for initials.

2. That code segment runs only if the version number in form label is not same as version number in table field. See discussion in referenced thread.

3. I can't remember why that is there. It might be left over from early code attempts to get username from network. I originally found some complicated code to do that then ran across the simple Environ function.

4. Are you asking about the UPDATE of computername in Users table? When user logs in I pull the computername from the network and save to table in that user's record so I can see what machines are hitting the db. The field is set back to null when user closes db.

An older version of my files can be downloaded from link in thread http://forums.aspfree.com/microsoft-...hs-445065.html

As stated, this is common topic and other approaches can be considered, even to require password to get in the db.

[sah]

Great June7,

Saw the link and downloaded the MD.zip file. The LabDatabase has loads of tables and MaterialsDB too includes many forms, looks like huge and great programming effort. the smileys beside the "reply to thread" doesnt include something which can compliment the db.

The update.vbs was what i was taking about, saw it in the zip file and understood it after careful study.

Thank you for suggesting all the wonderful things.

Wow, never thought ms access was so versatile and xcellent.
I feel smaller than a drop of water in this huge ocean. My interest in learning ms access has increased.
This forum is fantastic! Great learning place.