Can I disable this message on start up

I

ILIR ISTREFI

I have a small problem that I culd'nt resolve

The situation is like this:
I have about one hundred pay slips in Word doc. for the same amount of
employees. These files have Merged fields from the database. Now I tried to
select all word files and right click and then click on option Print. On
Opening every file one after other, the following message keeps popping up:


Opening this document will run the following SQL command:

SELECT *FROM `Table1`

Data from tour database will be placed in the document. Do you want to
continue?

Yes No

How can I disable this message so I can leave computer printing on late
hours, without having to monitor the prining my self.
 
S

Stephen Glynn

ILIR said:
I have a small problem that I culd'nt resolve

The situation is like this:
I have about one hundred pay slips in Word doc. for the same amount of
employees. These files have Merged fields from the database. Now I tried to
select all word files and right click and then click on option Print. On
Opening every file one after other, the following message keeps popping up:


Opening this document will run the following SQL command:

SELECT *FROM `Table1`

Data from tour database will be placed in the document. Do you want to
continue?

Yes No

How can I disable this message so I can leave computer printing on late
hours, without having to monitor the prining my self.

Why not use the option 'merge to new document', which will give you the
hundred pay slips on separate pages in one document, and then print the
file? You can later either find the individual pay slip in the file if
you ever need to print a duplicate or, if you need to, run a separate
SQL query to retrieve the individual's payslip (or all his payslips)
from your database.

Steve
 
I

ILIR ISTREFI

Stephen Glynn said:
Why not use the option 'merge to new document', which will give you the
hundred pay slips on separate pages in one document, and then print the
file? You can later either find the individual pay slip in the file if
you ever need to print a duplicate or, if you need to, run a separate SQL
query to retrieve the individual's payslip (or all his payslips) from your
database.

Steve



Thaks for replying but this solution does not resolve my problem.
The problem on this issue is that not all pay slips have same text which
text is not on the database but on the paticular word doc. Text varys on job
positions, grades and other data relevat to the paticular job positon. And I
have to use current pay slip forms, I am not allowed to change the design.
so the only way of using data from the database is merging fields to
multiple word doc. forms.

Ilir
 
S

Suzanne S. Barnhill

You may find help in "Opening This Will Run the Following SQL Command"
Message When You Open a Word Document
http://support.microsoft.com/?kbid=825765

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top