A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Filter Combo Box by Login ID



 
 
Thread Tools Display Modes
  #1  
Old January 22nd, 2010, 08:40 PM posted to microsoft.public.access.tablesdbdesign
Pamela
external usenet poster
 
Posts: 193
Default 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  
Old January 24th, 2010, 02:26 PM posted to microsoft.public.access.tablesdbdesign
Dale Fye
external usenet poster
 
Posts: 2,651
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.