Merging Data to Word 2002

H

Henry Lello

I have recently converted a database from 97 to 2002
format.

I use the database to merge data to Word documents and
have experienced the following problems...

1. All dates that are displayed in the tables and forms as
UK format BUT merge to Word in the US style. Word is set
up for UK formats.

2. Previously I would use the query "Between ([Enter Clock
Number From]) And ([Enter Clock Number To])" to define the
filter for my mail-merge, and link it to the appropriate
document. Once I open the document the Query boxes pop-up
for me to enter the clock number range.

However, upon trying the same approach on the converted
database I find I am unable to link a document to the
query as it does not show up on the list because it has no
data in the filter.

Can anyone shed some light on these issues.

Thanks in advance

Henry Lello
 
A

Albert D. Kallal

Henry Lello said:
I have recently converted a database from 97 to 2002
format.

I use the database to merge data to Word documents and
have experienced the following problems...

1. All dates that are displayed in the tables and forms as
UK format BUT merge to Word in the US style. Word is set
up for UK formats.
Click to expand...

Hum, you can always "force" the format by creating a column in the query
builder:

MyUkDate:format([InvoiceDate],'dd-mm-yyyy')

You can thus set/force the format to whatever you want.
2. Previously I would use the query "Between ([Enter Clock
Number From]) And ([Enter Clock Number To])" to define the
filter for my mail-merge, and link it to the appropriate
document. Once I open the document the Query boxes pop-up
for me to enter the clock number range.

However, upon trying the same approach on the converted
database I find I am unable to link a document to the
query as it does not show up on the list because it has no
data in the filter.
Click to expand...

Darn, I hope someone else jumps in. However, if you want, you can try my
sample word merge, and it will eliminate the above problem.

You can find my sample at:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
Top