I have one table with company information, linked to
another table with application information received from
said company based on a RFP.  We are creating a 2nd round
of applications which would include some of the same

In Access 2003, I have a data field into which I enter a hyperlink to
a PDF document. The hyperlink shows as a network path to drive G on
Server1, which is the actual location of the docs.
I will have thousands of these docs, and each will have its own

My OS is Win2000, version 5.0, SP3.  I'm using Access 2000,
and it seems that there are only two options for sorting a
field - Sort Asending, or Sort Desending.  I have a field
(Primary Key) that contains capacitor values.  What I would

I am trying to design a db to hold:
Patients Name, general Patient info and diagnosis
information. I am fairly new at the db thing and just
needed someone to get me started. Each patient can have

I posted a request for advice on table design and
received a reply from "Henry" who kindly suggested I
should attach a copy of my db to him.
I realise no-one wants to post their email address for

what is the best field type for a zip code?
Thanks,

I am attempting to put our paper daily log book into
Access. I have twenty beds that have guests checking out
and checking in and I need to keep track of the whole set
on one sheet. I know how to do this in a spreadsheet, but

I'm have atable with various columns containing
information in euros. For some reason it will not let me
use cents because it always rounds them up or down to the
nearest euro. I have gone into table design and changed

I would like to keep track of the transfers of assets
between employees.
     tblEmployee (one to many with tblHistory)
         EmployeeID

Ok..I've taken three classes on Access now and not one
has addressed those lovely pop up switchboards. I would
LOVE to know how to make one..any help out there???
Thanks!

I would like to see how long I have a product in
inventory, sitting there, since I bought it.
And didn't know if it was possible to have Acess
calculate the total number of days it is there since the

Dinfinition of Claim system : A system whereby it will automatic calculate
the amount of claim allows and determine whether the claimant qualify for the
claim based on a set of criteria.

I have a table in Access2000 that includes an OLE data
field which I was hoping to include small (75-500k) jpeg
objects, embedded, not linked.
However, when I insert a jpeg image the database expands

The requirement is for a database that holds boolean data for a large 2-d
matrix. It seems to me there are two approaches:
First: create a table with enough fields for all the columns, add rows
corresponding to each row in the matrix. This is easy but wasteful because

I want to write a code as follows for the table :
 CheckCriteria = Forms![ENTER METRIC TO INPUT METRIC]!
[ENTER METRIC TO INPUT METRIC Subform].Form!IM_Name
I have a checkcriteria function which refrences to the