I am using Access 2000.  I am using INSERT INTO syntax that works most
of the time, but sometimes it doesn't insert the record. The data base
has been heavily used for five or more years now.  There have been many
deletions of records and additions in that time.  The AutoNumber ...

I preview a report and click the button to publish the report to
Word or Excel document. It works correctly until today. It
produced below error message.
Microsoft Office Access can't complete the Output operation.

My application is mostly about performing analyses on data: looking for
errors/problems/potential savings, etc.
I would like to create a form where a user can create action items for
themselves, so that the next time they open the app, they will be able to see

A comment and a question
To anyone who is using conditional formatting, beware that in Access
2007 the color pallette is not the same as the color pallette in Access
2003.  So if you have a particular color you were using as a standard

A while back I had found a link to a popup calendar that had a small
button that was placed to the right of any text box.  By clicking on
the icon and selecting a date the text box was updated with that date.
You were able to use the icon (button) on multiple text boxes on the

I have two versions of Access installed on my machine, XP and 2003. I
am trying to automate the process of creating an ADE for distribution
to end users running a mix of XP and 2003.  I do all my development
work in 2003 but create final ADE's using XP.  I'd like to create a

SQL String #1
DELETE * FROM tblPreliminaryVINs Where PVIN In (Select SerialNum From
tblVehicleJobs);
SQL String #2

I would like to have a combo box on a form that shows the results of a
query, however the query is variable and i am unsure how to do this. I
have NO knowledge of code so very basc instructions would be
appreciated!

Was wondering if anyone has constructed a progress bar out
of colored rectangle to go on a form, varying its width say between
zero and 3-inches with the actual width being directly proportional
to the percentage calculated by calculating the form's current rec

I'm using Tony Toews update utility.  It works great but I have two
identical machines running windows xp with all the latest windows
updates where I receive a "Automation Error Object already exists" when
trying to run the updater.  I'm fairly certain it may be some type of

I am using the following code during an On Click event for a button.
It works properly to create a query for a report:
Private Sub Command14_Click()
If IsNull(Me.Text30) Then

Hi I have MS access form which has some text on it in four paragrpahs.
Text in first two prargraphs can be changed if I want to and last two
paragraphs are not modifiable. When I go to Design View, I see that
first two paragraphs shows me as Unbound and text is not displayed. Can

I have a dialog box to find a specific record in a form by Name  Can
anyone tell me how to link it so that when i move out of the dialog
box, it pulls up that persons specific record.  Mine keeps popping up
as the 1st record of the form and i can't seem to figure out how to

I am trying to incorparate the win zip command line processor in my
code on an Access 2003 database form.  The code that I downloaded made
a call to the windows api.  It requires that you use short names
because it works in the command window. The call is to

I have this combo box which gets its data from:-
SELECT customer.customer_id, (nz(customer.first_name,'')+'
'+nz(customer.middle_name,'')+' '+nz(customer.last_name,'')) AS name
FROM customer;