I have four tables that contain four different file types
that are stored in my file room.  I want to create a
database (MS Access 2002) that will allow users to 'check
out' a file that is contained in one of my tables.  I was

How do I set up a yes/no data type with a check box?  I
want a yes/no data type with a drop down box so then I can
select yes or no depending on the data I am entering.  
Thanks for help!

One field in my master table is a lookup based upon
column 1 another table.  Another second field in my
master table is based upon the same lookup table but at
column 2. I would like to have the user choose a

Hi-I'd appreciate if anyone can help on this.
I am trying to create a query that inserts the top25
results to a table with an autonumber column for ranking
purpose.

I have microsoft access 2003 and Windows xp. I have install access. When I
try to use the wizard in the program I get the fallowing message
Microsoft office access can't start the wizard or add-in. When Ipush OK it
comes back with. Microsoft office access could'nt launch the ...

I am building an application in Access 2000 that includes so far 10
databases and various report and query functions.
It has been suggested to be that for distribution, I would make more
if I converted it to a stand alone aplication. So I did some reading

Looking for a way to remove extra barcode characters
without using thirdparty software in access

PLEASE HELP ME!  I have been tasked with designing an
Access database to track our firm (Broker/Dealer)'s
trading activity.  Here's my question:
If you design a query that includes (for example)

How do I create a calculations so that I receive a final
total?
Example:  I created columns named: Quantity Ordered, Sum
of Unit Price and Sum of total Cost.  I need to calculate

Why is MS Access often a good candidate to use in story boarding/protyping
the user interface presentations screens and basic database functionally for
new database development?

Does anyone know how a way to check two different Access
Databases to make sure that the table structure is the
same? I am using Access 97.

I have a back end with a table that is growing very big
and I am having to move it to a different back end and
link it to the same front end. How can I keep the
referential integrity intact.thanks

I have a table with a fe for users and be that holds just my tables
I have code that will create tables, but it creates them in the be and links
them, not in the fe where I want them to be used as temp tables and deleted
on opening and closing of the fe.

OK, I have developed a table with multiple drop downs,
when I go back and look at the table the drop down
information is there, but once you make a selection a
number populates the table. When I go back to try and

Is there any constraint on the maximum DB size supported
by Access 2002. IF so, could you please let me the size
limit?