Vista question

  • Thread starter Thread starter CD Tom
  • Start date Start date
C

CD Tom

I have a form that extracts data to a file and then starts MS Word with a
template that is setup to merge the extracted data. When using Vista when MS
Word starts there is a message box that request a answer, the problem is that
the message box is hidden behind the Access form and there is not way to
answer it. I can't minimize the access form and it doesn't show up on the
task bar. The word message is "Opening this document will run the following
SQL command Select * from etc. Data from your database will be placed in the
document. Do you wan to continue?" I know there is a way to get away from
this message but I have other users and most of then are not very computer
savy. Is there any way to correct this problem. Any help would be
appreciated.
 
Did you already try adding the folders where your application runs and where
your data lives as trusted locations in MS Office, assuming you're running
Office 2007? If the data is on a network share, you also need to specify
that Trust is allowed on network shares.
 
Try adding at the beginning of the vba code - docmd.setwarnings false
and at the end of the code - docmd.setwarnings true
 
Back
Top