Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-03-2012, 07:37 AM
Tomtheappraiser Tomtheappraiser is offline Option for running SQL repeating before I can open report Windows 7 32bit Option for running SQL repeating before I can open report Office 2010 32bit
Novice
Option for running SQL repeating before I can open report
 
Join Date: Mar 2012
Posts: 3
Tomtheappraiser is on a distinguished road
Default Option for running SQL repeating before I can open report

I have a template report in MS Word that I am using a mail merge in it runs from a query out of MS Access. I have added some fields in the query, and everytime I add them to the template the box that says:


"Opening from this document will run the following SQL command:
SELECT * FROM 'qryAppraisal'
Data from your database will be placed in the document. Do you want to Continue?"

Then, when I open a new report from the template, this box pops up 10-15 times before it lets me open the report.

What am I doing wrong here? Is it that you can't add fields to a template (via editing: i.e. right clicking the template and selecting open) after it has been created?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeating Bookmark Text BECKTHOMO Word 1 03-27-2012 08:34 PM
Does Word have an option to update fields AUTOMATICALLY at open??? Jamal NUMAN Word 17 01-27-2012 12:57 AM
repeating text in a document Stevejd58 Word 20 11-07-2011 01:07 PM
Outlook 2010 won't open links if Internet Explorer 8 is already running Svart Testare Outlook 0 01-28-2010 11:35 AM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft