I would like to export my query to Excel format.  I know how to write export
specification.  I don't know how to bring SAVE dialog in my VBA code so user
can select the path.  I would like not to hardcode the code.
Can you assist?

I have an Access database which currently has over 65'536 rows in it.  I need
to export this into an Excel file every month, but as it cuts off at 65'536
rows, I just want to keep the newest records which come under a heading in
the database called 'date input'.  

I have designed a form but when I click over to form view nothing is there.  
I have saved, closed and reopened thinking that would do it.  All the boxex
are in design view but there's no form to enter data in form view.  Why?

Hi, I have several excel spreadsheets, completed by the business (they are
not in the same format) I need to be able to import (as automatically as
possible) all these sheets into one main table to use in the database, I also
need the data to overwrite the existing data, so for ...

I am a relatively new Access user and am seeking assistance in generating
automatic e-mails from Access 97 via Outlook 2003.
I am currently using two tables:
1). tblData: This is a large (110Mb) linked dBase IV table that is generated

Hello & thank you in advance,
I am trying to merge 2 existing Access databases & am having difficulty
because one of the forms contains a subform that I can not seem to transfer
over.  How do you import a subform?

I am not sure if this is the correct board for this question.  Basically, I
am using a database to send letters regarding violations at a homeowners
association.  I guess I will just write out what I would like to beable to
do, and if anyone can tell me if this is possible that ...

when importing text data how do I move from field to field on screen 4 of the
import wizard to skip fields, change field names or change the data type.  I
can do this in the first field (column) but cannot advance to the next field
for changes.

I have a user with a beloved old Filemaker database. The db is useful and
_another_ user looks at it from time to time. The second user has Access
2003 and I want to set up an easy import or link facilty for them. At this
point I'm stuck - is there any way of pulling FP3 data ...

Access 2000
I'm trying to output a report containing a memo field to a text file using
the command:
DoCmd.OutputTo acOutputReport, "reportname", acFormatTXT, "C:\textfile.txt"

Is there anyway that I can define a field (attribute) in a database in
access and attached an outlook mail?
Guidance and helpfull hints will be helpfull.
Luis

I have folled the instructions in Allen Browne's website (see code below) -
http://allenbrowne.com/func-02.html.
But the problem that I am having is taht when I attach the function to the
listbox ,it runs okay the first time,But when the form is loaded again it

Using Access 2003 I can easily export related tables to XML, however I need
to add additional element tags in the XML file to allow another custom
program to easily read in the XML file.  
For instance, in the example below I need to add the "Entry" element tags to

I am using the docmd.transfertext command to load a csv file into my
database.  
DoCmd.TransferText acImportDelim, "CsvImpSpec", strTable, strFile, False
The file I am loading has 4 records that violate the primary keys in the

I need to use Access and ODBC to insert text into a linked SQLServer table
where the field is stored as an ole object.  Currently I'm using an unbound
form control and an append query.  When I do it now the data is stored and
retrieved as unicode text and the extra spaces is ...