Choice of Starting Access.

  • Thread starter Thread starter TerryM
  • Start date Start date
T

TerryM

I have a mailmerge document which uses an Access2000 DB as
it's data source. I had created an autoexec macro to
import data, validate, clean it, etc. However it takes
too long for the mailmerge to work to I thought I should
split it into two parts.

1 - Manually import/update the data.
2 - Do the mailmerge without doing anything to the data.

How can I start the DB in the two different ways? I've
tried using the /cmd and /x options but I cannot get them
to work!!

Help.... please.
 
Terry,

Open the database normally and present the user a form with
two buttons giving them a choice of what to do. Move your
code out of the Autoexec and behind each appropriate button.

Gary Miller
Sisters, OR
 
Thanks for the suggestion but ... I have the database as
the source for mailmerge. The Word document opens the
Access DB and links the data. I dont want to give the
user a menu to choose from. If however they want to run
the database outside the mailmerge then I can certainly
display a menu system.

Can you see my problem?
 
Terry,

No, I guess I really don't understand the problem.

When you say....
... I assumed that you were opening the database. Where is
the autoexec you refer to? In Word or Access?

I have never seen just linking to Access tables from a Word
Merge trigger an Autoexec in Access. Are you doing the
cleanup on the Word end???

Maybe a little more info would give a clearer picture.

Gary Miller
 
Back
Top