I am using Microsoft Access 2002 and Word 2002. I keep trying to do a mail
merge but I keep getting numbers where drop down menus are in the tables. For
example if there is a list of 4 options to choose from, in the mail merge on
word, a number is given, not the option you choose ...

Whatever file, all valid XML? Just crashes Access completely. Any ideas
appreciated!
SJ

From a form in access 2000 I have a button to create a workbook from an
excel template located on my local network. Which works OK, code below
Dim AppExcel As New Excel.Application
AppExcel.Workbooks.Add "\\server\folder1\Templates\exceltemp.xlt"

Firstly let me start by saying that I am a relative beginner to access
database development and a raw beginner to any programming. What I am trying
to do is to work out a way to store multiple data within one field. I know
that the theory is one field equals one entry and a field ...

I am getting an invalid argument when running this code.  I am trying to
import a .csv file into an access table.  
Private Sub TransferFile_CmdBtn_Click()
   DoCmd.OpenQuery "Flush_Usage_Query"

I'm new to using Automation and am missing something in my code.  My code
exports a report to Excel, formats the spreadsheet, saves and closes.  After
I run the code, opening any Excel file from Explore or desktop shortcuts
stays invisible.  I have to open a new instance of Exel ...

Can anyone tell me a quick way of importing Lotus Notes databases including
attachments into a MS Access database?

Using Access 2002, I am importing data from Excel (which is a file created
from AS400) and have used various methods, i.e. linking to the excel file,
importing the excel file, and currently using the "Transfer Spreadsheet"
function in VB.  With each method of importing the data, ...

I have excel 2003 table with first row as field names and next row (fro now)
with data. I imported to Access 2003 fine.
I noticed that if the field in excel is a number, ie. 1, access makes a
double filed, and if it is a string, ie. "dog", access makes text data type,

I am trying to import tables from one DB to another, but the tables will not
overwrite themselves.  Is there any way to do this?

I would like to import data from excel into an existing table.  However, I do
not want to append the data, as is done with the Docmd.Transferspreadsheet.  
I would like to have the data I am currently importing, replace the old
table.  

Hello Experts and Power Users
I need your help. I administer a mystery shop program and I do monthly
reporting. Each month I have to run one report for each region shopped. There
are 40 regions therefore I run the report 40 times and name/export to rtf 40

I want to select data to be exported using a query. Then "flag" or mark those
records in the main table that they have been exported so they can not be
exported again.
This is to send checks to be printed.  I would be sending to an excel file

I am using one of the Microsoft supplied templates to track our wine
collection. It is called the "Wine Collection Database".
I use it to keep records of our purchases. I have saved another copy of it
as our 'wine tasting records database.' The second one is used to keep

When I export data in fixed format to a text file from a query, calculated
character fields are being truncated.  I'm exporting around 10,000 records.  
The field should be 15 characters in length and when I use len() to check it,
that's what it is.  The first few hundred records ...