I did put most merge documents into the database, but this merge document
creates an anniversary card. I'm merging a name, anniversary date, and years
of service--just 3 simple pieces of information. I'm using a graphic and
rotating text--I don't know how to do this in report or if it can be done.
It was working, but I revised the database and changed the query name that
it was accessing. When I click "Browse" to select the query, instead of
listing over 100 queries in my database, it's just giving me a few table and
about 7 queries (not the one I need).
Yesterday I click [x] confirm at startup--or something like that in Word. I
thought I tried merging again, but it still didn't list the queries. Today I
tried it and it worked!!!!! I'm not sure why though. When I open data source,
I need to select "Ms Access Databases vis DDE" for Access to display all my
queries.
I'm glad it's merging now, but I'd like to know what you have to do. I
created the database 13 years ago. I vaguely remember calling Microsoft (and
paying $100) for them to tell me I need to select DDE. Something about the
database being creating with an earlier version. I thought with upgrades
everything would be fine, but apparently since it was created in Access 97 it
used a different technology????
I design databases for a nonprofit, so they're slow to upgrade. We're
currently using 2003.
