I have a table with columns called Part1,Part2,Part3,Part4 and I would like
to export them to Excel but have each column called Part.  Is this possible
without doing it manually?  I would like the columns either in the table
renamed to Part or the columns in the exported table ...

I have, until recently, had Access 2003 and 2007 installed on the same
PC, as I need to use both versions.
Following a number of crashes in Access 2003 ("Access has stopped
working...") I decided to remove Office 2003, and, in order to ensure

I have a form with a button which is supposed to open an Excel file (With
lots of Macros /VBA) in it. The Excel file gets it's data from the Access
program
Here is the code

Luke Chung at FMS Inc provide this link in another thread that provided
a really helpful .pdf file error listing:
http://www.fmsinc.com/MicrosoftAccess/Errors/ErrorNumberAccess2007-2000.
pdf

Is there a way to disable the maximize, minimize and restore buttons
of the Access window in A2K7? I can't seem to find one. I am setting
up an application that will be launched via Terminal Services but
don't have seamless windows so I need to make sure the users can't get

I get the errors
1) No current record
2) The search Key was not found in any record
while deleting data from a table

Good Morning,
I'm making a report with grouped data with access 2003.
Unfortunately, Access print in this report groups with empty data to
fulfill all level.

I have created two combo boxes in a subform....
For example
1. Combo Box State
2. Combo Box City

If I'm using the following in a procedure...
DoCmd.GoToRecord acDataForm, "FormName", acNext, 4
... how can I recognize the EOF condition? Using GoToRecord,
I find myself lost when trying to determine when EOF is reached.

I have a new database created in Access 2007.  Things were going
swimmingly (or as well as they do for an amateur like me) when
suddenly calculated fields on a form started giving me "?Name# as
their result. Also on click events (eg to open another form) stopped

I have a computer running Windows XP SP2. I get the message "The
'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local
machine".
Microsoft provides instructions for obtaining the Jet components in

All your help is appreciated in this problem.
I am running a macro to execute certain queries and the macro is
started to run by a windows task scheduler. However, after the macro
runs the database will remain open. Instead I would like to close the

If I drop Like "*ABC*" in a QBE grid criteria cell,
the records returned include mixed case. Can I
force the uppercase limitation in a QBE grid?

I am using DAO transacation in my code and everything is running
perfectly alrite. but it is not commiting my transacation. and whole
code is running without any errors.At the end of code its commiting
transacation but there is no effect on database.

SO = Sales Order
PO = Purchase Order
PO Rules
An SO can have many lines.