If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter Combo Box by Login ID
Our company has about 5 different computers on our Network that all have been
using their own copy of an Access db. I thought this would be fine as I like that they each only have access to their own records which are relevant to them. This is, however, creating a difficulty for me as far as updating the db or fixing any errors. I find I have to go through and do it over and over 5 times. I've read up on splitting the database but want to know if I were to create a login form for each appraiser could I then filter the records and combo boxes by their login? Also, I'm a little confused about if this will help with my programming issues since the forms and code all seem to go on the front-end which would be loaded on each computer, right? Would I still have to go and change the code on each computer?? Thanks so much for any help with this! Pamela |
#2
|
|||
|
|||
Filter Combo Box by Login ID
1. Yes, you can use the users login ID to filter data. I do this all the
time. One of the nice things about this is that users can be assigned to specific roles which you can use to determine which forms, reports, and even controls that your users may see or use. To get their login ID, use the code located at: http://www.mvps.org/access/api/api0008.htm You will need to copy this code and put it into a public code module. 2. The goal of having a Front End (FE) / Backend (BE) configuration is that all of your data will reside in a single location on a network server. It sounds like you currently have five different sets of data, and are having to merge that to get the "total picture" for your organization (which can be very time consuming). Most people that using this configuration use a separate application to update the FE application that sits on their users computers. The version I use checks to see whether the version number of the application on the users computer matches the version number of the application sitting on my server. If not, this application copies the newer version to the users computer, starts that application, and then quits. Tony Toew's has what he calls his Auto Front End Updater, located at: http://www.granite.ab.ca/access/downloadsindex.htm HTH Dale "Pamela" wrote in message ... Our company has about 5 different computers on our Network that all have been using their own copy of an Access db. I thought this would be fine as I like that they each only have access to their own records which are relevant to them. This is, however, creating a difficulty for me as far as updating the db or fixing any errors. I find I have to go through and do it over and over 5 times. I've read up on splitting the database but want to know if I were to create a login form for each appraiser could I then filter the records and combo boxes by their login? Also, I'm a little confused about if this will help with my programming issues since the forms and code all seem to go on the front-end which would be loaded on each computer, right? Would I still have to go and change the code on each computer?? Thanks so much for any help with this! Pamela |
Thread Tools | |
Display Modes | |
|
|