Jordan

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access Mail Merge Problems - 07 Jul 2004 15:37 GMT

Sorry to post this again, but I wanted to get it back to
the top level because I need the problem resolved as soon
as possible. The main problem I'm having is that when I
use OLE DB to link my many documents to an Access query,
in some of the records, the calculated field data comes
in as zero instead of the correct value. I really have
no idea what the problem could be. Anybody have an idea?

The second problem is that upon reopening a document
after saving my documents with the mail merge
information, it says that the data source cannot be found
even though I haven't moved the data source or the
documents location. This, again, is with the OLE DB
link. Could this be caused by my replacing the front-end
database, even though it has the same name and location?

The only reason I'm concerned about using OLE DB is that
I would prefer to use it over DDE because DDE opens a
second copy of the database and also seems to take longer
to search through the records, even when using Query
options. Thanks in advance.

Reply to this Message

Peter Jamieson - 07 Jul 2004 19:56 GMT

> Sorry to post this again, but I wanted to get it back to
> the top level because I need the problem resolved as soon
[quoted text clipped - 3 lines]
> in as zero instead of the correct value. I really have
> no idea what the problem could be. Anybody have an idea?

Is the calculation being done by the Access Query or by a Word { = }
field? In addition to all the questions Cindy had, I'd want to know
whether or not the underlying fields in your Access db are Currency
fields, as they can cause a number of calculation and display problems.
If they are, I'd consider converting them explicitly using e.g. CDbl.

> The second problem is that upon reopening a document
> after saving my documents with the mail merge
[quoted text clipped - 3 lines]
> link. Could this be caused by my replacing the front-end
> database, even though it has the same name and location?

There are some errors (unfixed AFAIK) in Word 2002 in this general area,
but if the full pathname of your database is long I would be inclined to
try reducing it and see if that makes any difference.

Peter Jamieson

Reply to this Message

Jordan - 07 Jul 2004 20:39 GMT

The calculation is being done by an Access query, and
then merged with Word. The fields that these
calculations are based do include currency fields. The
numbers and calculations show correct when I view the
query, they just don't display properly in Word. They do
display properly when I use a DDE link, so I'm guessing
the problem is with OLE DB.

My database file name is "Patient Records". The problem
only seems to occur whenever I replace the front-end with
a new version. Does it make sense that this would be a
problem? Or might that just be a coincidence and the
problem is elsewhere?

Thanks a lot.

>-----Original Message-----
>> Sorry to post this again, but I wanted to get it back to
[quoted text clipped - 25 lines]
>Peter Jamieson
>.

Reply to this Message

Peter Jamieson - 10 Jul 2004 11:53 GMT

> They do
> display properly when I use a DDE link, so I'm guessing
> the problem is with OLE DB.

Based on your evidence, that would be my initial assumption as well.

The only things I can suggest are
a. if you aren't using explicit conversion functions (CDbl or whatever) in
your query calculations, I would try using them wherever a currency amount
appears.
b. just as an experiment, try recreating the relevant table structures
using double types rather than currency, and see if the same problems occur.

Signature

Peter Jamieson

> The calculation is being done by an Access query, and
> then merged with Word. The fields that these
[quoted text clipped - 58 lines]
> >Peter Jamieson
> >.

Reply to this Message

Rate this thread: