When I try to use the wizard to create a new Access form, I get the error
message: ActiveX component can't create object.

Posted on Access group as per recommendation from other user that
Excel wouldn't be the best tool for this.
I have a requirement, however after some help on how I should be
looking to approach this or if anyone knows of any examples that

I have a form, based upon a query, which used to update OK but somewhere
along the line it has stopped being updatable and I cannot work out why. Can
anyone help? The SQL generated is...
SELECT ExpenseDtl.ExpenseID, ExpenseDtl.ActivityDate, ExpenseDtl.Client,

I have 2 tables/query that i would like to combine to make a simple
form/report for.  The data was downloaded from the system and I am not
able to change the format.  What i need to do is make a simple report
that compare the 2 queries result that show that there is no

I'm new to access, but have Oracle exprience.  What is the syntax for the
where clause 'between date1 and date2'
In Oracle I would say date_column between
to_char(to_date('01/01/2007,'mm/dd/yyyy')) and

I have a field of 1 to 3 digit numbers.  I'd like to add leading zeros to
each to make them 6 digits.  For instance:
4 becomes 000004
10 becomes 000010

I have some code that is based on a piece of sql code generating a
query. In the code I added some fields that have to be shown in the
final result i.e. a query.
Can somebody tell me what I have to do in order to show the result

I am trying to create a database in Access using a Table.  I'm trying to set
the DateDiff function to calculate the Last Day Worked and Now for every
entry.  How and where do I enter with information.

I have created three tables recording donations received, Donations, Large
Donations and Large Cash Donations. I now need to get the average of the
large cash donations.  I've read the Builder 'help' section several times,
but can't get the expression right.  Pls Advise.

Hello experts,
I have a form witha subform, I need to append the records from the subform
into a table. I set it up and it seems to be fine but there is a problem.
Only one record from the subform is appended into the table and it is always

I have a database set up for our company newsletter. I have a query that
allows me to see how many people receive multiple copies. The "copies" column
in this query displays numbers like 2, 20, 35 etc. However when I opened it
today there are records where the copies cell is ...

I have a query that I am using in a sub procedure and I am opening a
recordset using that query as the recordsource. The query has a parameter
that references a field on the form that the sub procdure is run from.
Problem is I am getting an error message all the time that says too ...

Is there an easy/simple way to select all records from table A that DO NOT
have a match in table B?

INSERT INTO Employee_Status ( [Employee Name], [Employee ID] )
SELECT [Employee List].[Employee Name], [Employee List].[Employee ID]
FROM [Employee List]
WHERE ((([Employee List].[Employee ID]) <> [Employee_Status].[Employee ID]));

I am trying to use a form to allow users to generate query results in my
database. The more fields the user enters into the form the more narrow the
query results. My problem is this: I want the user to have the option the
fill in as many or as few of the form fields as they want ...