I work at a health center where there are numerous research studies
done.  Part of my job is software support, and while I keep reading
everywhere that one-to-one relationships are rare, I keep encountering
needs for them here.

I have designed many Access Client Server Applications before where I have
the 1 MDB file on the Hard Drive & the data MDB file on the server & have the
Tables Linked.
For this one client when I do the same when 1 user logs in they are fine.  

Please help me how to design table for FIFO method calculation.
Thanks.
Regards,
Vensia

I am setting up a database for employee training records and need some advice
about relationships. How should I set up the relationships?  Our training
records are called SOPs.  There is one employee to many SOPs.  The training
frequency can be 6 months, annual, etc.  Should I ...

I am using Access 2002 and I am trying to put accounts numbers in a field
call account number, the only problem I have is that I am unable to put
017108, all I get is 17108.  my field is a number and is a double type.  How
can I have 017108 show in my table?  Any help will be ...

I have created and APD in Access 2003 connecting to a database in MS SQL
Server.
When I try and ceate a query and save it, I get a message :
'This version of Office does not support design changes with the version of

I have a database with parent-child tables where users enter text and numeric
information in a form.  The form source is a query linking the parent-child
tables.
Upon entering 40 records in the parent table and 41 records in the child

I am building a data base for a reality company and they need to select
multiple appliances that are included with the sale, how do I create such a
list in access?

When selecting a modelID for a related table I have all the fields show from
the lookup of the Models table because I have many different years and makes
related to a model type, but when selecting the correct model only the year
shows in the field of the related table.  Is there ...

I am looking for an easier way to replace a large amount of text ie A to 01,
B to 02 etc.... within two fields, currently i do this outside the datbase
within execl but i am looking for a way to code. struggling I am! could any
one help!!

How can I use DLookUp or other function in a Form to display data (say a
persons name) as soon as the person's ID is entered in the transaction form?
Or is their a different way to do this?

Can anyone tell me how to implement an ER model generalization in an access
database?

This connection string I copied from "ASP.NET and ADO.NET" by Esposito is
very interesting (see below). It works when my perl programs are not trying
to use ODBC to simultaneously access my database. It does not work when they
are using "SELECT", "UPDATE", "INSERT".

I would like to help to the following problem:
HOW CAN I CREATE AN INPUT MASK IN A FIELD OF AN ACCESS TABLE, IN ORDER TO
HAVE ONLY THE FIRST LETTER CAPITAL AND THE OTHER CHARACTES LOWER?

I have a report with 691 clients with each assigned one Account Officer (AO).
There are 74 Account Officers. I currently have a query based report that
prompts for a [Enter Account Officer] parameter. If I want to print out a
list of clients for each Account Officer, I have to enter ...