Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2004

Tip: Looking for answers? Try searching our database.

Access merge problems

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jordan - 22 Jun 2004 17:45 GMT
A good number of my documents seem to have a problem with
holding their data source location.  Every time I open
the documents, they say "Data source cannot be found..."
and then I relocate it and specify it.  I then save the
document to lock that location.  But then the next time I
open it, it says the same thing!  Why won't it hold the
location?

The other problem I seem to be having is with a
calculated field.  My documents are merged to a query
that has calculated fields.  On certain records, one
particular field returns a dollar amount of zero when the
query which it is merged shows a positive amount.  Why
isn't it merging properly?
Doug Robbins - Word MVP - 23 Jun 2004 10:34 GMT
Try changing the connection method.  To do this, check the "Confirm
conversions at Open" box under Tools>Options>General.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> A good number of my documents seem to have a problem with
> holding their data source location.  Every time I open
[quoted text clipped - 10 lines]
> query which it is merged shows a positive amount.  Why
> isn't it merging properly?
- 23 Jun 2004 16:27 GMT
I have them all as OLE right now.  What should I switch
them to, DDE?  The only annoyance with DDE is that it
takes forever to do a Find Record and that it opens
another copy of Access.

>-----Original Message-----
>Try changing the connection method.  To do this, check the "Confirm
[quoted text clipped - 16 lines]
>
>.
Cindy M  -WordMVP- - 24 Jun 2004 10:34 GMT
> I have them all as OLE right now.  What should I switch
> them to, DDE?  The only annoyance with DDE is that it
> takes forever to do a Find Record and that it opens
> another copy of Access.

Does ODBC give you reliable results? That would be faster
than DDE, but avoids many of the problems OLE DB has.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.