I am working with a full version of Microsoft Office 2003 and have interests
in MS Access. Currently, I am trying to use the Microsoft Common Dialog
Control, version 6.0 in the designer. Everytime I drop the control onto my
form, a message appears indicating to me that I should ...

Help!! I'm a beginner with access and I should do a questionnaire. By
reading your conversations I understand that i should have 4 tables.
But i don't still understand how to create the question's table??? Am I
supposed to put a question in every field of this table??? Boh... This

I am developing a database to track my coin collection. I was wondering how I
would add pictures of my coins in jpg or jpeg and even bmp files? Please
advise. pics will be about 3x4.

One of my tables has managed to get above the visible portion of the
Relationships Window.  I can't find a way to lower it into the visible
portion.  I know I can put another copy of the table on and relink and delete
the other links (I can see them where they stick out from ...

Thanks to all of you for all of your help.
I have a small backpackers hostel and I am currently working on a database
to help me keep track of all of my guests.
These are the two basic design issues that I am running into.

Dear Highly Esteemed Access Gurus,
Thanks for reading my post.
Ok, the situation is that I have a database with a one-many relationship. So
one customer, with one customer reference can have many items of different

What I am trying to do is have two separate tables.  One is for current
inventory and one for inventory disbursement.  I would like to have the
quantity column in the current inventory table updated automatically when
inventory is used (which info would come from the inventory ...

My Problem is that i have several fields of currency ..and i wish that when
entering for example the Dollar Currency in one field, the Euro value will
appear automatically in another field and vice versa. So i think its like a
kind of linking of fields we a mathematical filter ...

I need to link up four other workbooks up to a master work book which will
hold all the data. I also need to be able to update all the fields through
both wyas, through the master and through the smaller more specialised
workbooks.  I already know how to update hte spreadsheet ...

I cannot access records from my table after they have been entered via a
form. I can enter the information in the form and when I click the preview
report button (which I have coded to only show the current record) the
information is correct. When I close the form and reopen it, ...

is it possible to assign a hot ket to a switchboard button??

I'm working with work breakdown structure codes: 1.0.1.123 or 1.23.32,
etc that seem to be very difficult to sort as text.  So I broke them
down and converted them to integers into an array so that 1.0.1.123 as
text became

For verification that my clerical staff are inputting our client data on the
date the client first came, I need an automated date stamp, that will return
the date the data was input.

Hi. Part one - my problem may be my design. I have a db with tables:
tblSystem (*SytemID, CustomerID, lots of detail fields)
tblCustomer (*CustomerID, name and address info...)
tblDatesAndServices (*ServiceNumber, SystemID, InspectionNumber, CustomerID

I am designing a simple database and can't decide or figure out how exactly
to design a certain aspect.  I have started it 2 different ways so far.
The database is mainly a history tracking and simple info viewing database.  
I have a bunch of physical sites that each have a ...