This has happened before and I found the solution, but cannot remember what I
did.  When I go to use the Wizard to help create a form, table or query I get
the message "ActiveX component cannot create object."

I have a field that takes a value linked to a description and is supposed to
multiply by the quantity.  The related field holding the value rounds to an
even dollar, sometimes up and sometimes down!  All the end values are whole
dollars.  Why is the data getting rounded?

Please tell me how can I create a querry in access 2002 where the results are
ordered by a specific field.  I need to create a mail merge document to print
a thank you letter every time I enter a payment.

I hope this is a slightly new twist, as I've actually looked for an answer
in past posts, but have found nothing that helps.  Or, found nothing I
understand well enough to apply.
So, I have a Date/Time field in a table, the entries of which I'd like to

Hi gang,
I've already been here:
http://www.mvps.org/access/datetime/date0004.htm
I have 2 time fields, "Time In" and "Time Out".  I have a

Hello, I work for a non-profit organization, where I'm working on a
survey database.
I need to survey houses and their residents. Houses can be in different
categories, each category having its own questions, and then the

Whew!, I have 45,000+ images in a folder all named by a code (i.e.,
4567.tiff), I have an access table with descriptions for each of the photos.  
I need to create a may to many relatioship, which I beleive I can do (since
one description can go to many photos and many ...

I have a problem with a one 2 one relationship.
I am working on a database where Exhibitors can enter many different
classes, for each of these there is different information required at the
exhibitor level, so rather than haveing a huge table I am trying to split it

What are the expansion capabilities for MS Access?

How do I get a field to calculate a date 60 months in advance of another
date field.
I can do it in Excel but not in Access.
Thanks

I am trying to design a database to track a commission sales on a weekly
basis. The commission sales is a variable, that is it may change in value
from time to time.

OK.  I am belatedly convinced of the advantages of an autonumber primary key,
that it is smart to have a dumb primary key.
How do I do this after the fact?  I have been using a combination of fields
as a primary key, and there are several hundred records in the system. (at

In access I'm trying to * 1000 by.015% and it is not working

I have an access database controlling information and creating details for an
estate agency. To create housing details pages, I need the photo's to be in
the database so they can be linked to reports. I have around 200 records
already in the database, all which require ...

I am building a database which will store client details for counselling.
Each client is given a sheet than contains a large list of the sorts of
problems they are facing from which they can choose 3 that are the best
match. In the database this static data is stored in one table ...