Supress "Opening this document with run the following SQL command"

  • Thread starter Thread starter Chris K
  • Start date Start date
C

Chris K

I know this must be asked 1000 times per day - so hopefully there is a
solution

Can I stop word telling me what it's told me a million times before? namely
"Opening this document with run the following SQL command"

It's causing havoc - I am trying to open a document from an Access Form

I can not answer the prompt because it is popping up underneath the modal
form - the form will not budge because it's waiting for the prompt to be
answered

Only solution is CTRL+ALT+DEL
 
I'm not in a position to modify registry on company computers but thanks

So the short answer is that Access cannot be used to open an MS Word Mail
merge

P.S. Social Answers forums can not replace the current newsgroups
currently - just took a peek and the existing forums barely scratch the
surface of office apps (Access is hardly mentioned)

Maybe in next 5 years



Doug Robbins - Word MVP said:
See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

Note these newsgroups are no longer hosted by Microsoft and are now
orphans
in the wilderness.

As a replacement for the newsgroups, Microsoft has created forums that can
be accessed at:

http://social.answers.microsoft.com/Forums/en-US/category/officeword


--
Hope this helps,

Doug Robbins - Word MVP
dkr[atsymbol]mvps[dot]org

Chris K said:
I know this must be asked 1000 times per day - so hopefully there is a
solution

Can I stop word telling me what it's told me a million times before?
namely "Opening this document with run the following SQL command"

It's causing havoc - I am trying to open a document from an Access Form

I can not answer the prompt because it is popping up underneath the modal
form - the form will not budge because it's waiting for the prompt to be
answered

Only solution is CTRL+ALT+DEL
Click to expand...
Click to expand...
 
If you don't make the registry change, you merely have to acknowledge the
prompt.

There's a macro at http://www.gmayor.com/word_vba_examples.htm which will
toggle the prompt on/off, but as it writes to the registry, I don't suppose
your company IT Nazis will approve of that either? Software does however
write to the registry all the time.

Agreed, the forums are poor, but they are the future ... unless everyone
come back here ;)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



Chris K said:
I'm not in a position to modify registry on company computers but thanks

So the short answer is that Access cannot be used to open an MS Word Mail
merge

P.S. Social Answers forums can not replace the current newsgroups
currently - just took a peek and the existing forums barely scratch the
surface of office apps (Access is hardly mentioned)

Maybe in next 5 years



Doug Robbins - Word MVP said:
See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

Note these newsgroups are no longer hosted by Microsoft and are now
orphans
in the wilderness.

As a replacement for the newsgroups, Microsoft has created forums that
can
be accessed at:

http://social.answers.microsoft.com/Forums/en-US/category/officeword


--
Hope this helps,

Doug Robbins - Word MVP
dkr[atsymbol]mvps[dot]org

Chris K said:
I know this must be asked 1000 times per day - so hopefully there is a
solution

Can I stop word telling me what it's told me a million times before?
namely "Opening this document with run the following SQL command"

It's causing havoc - I am trying to open a document from an Access Form

I can not answer the prompt because it is popping up underneath the
modal form - the form will not budge because it's waiting for the prompt
to be answered

Only solution is CTRL+ALT+DEL
Click to expand...
Click to expand...
Click to expand...
 
In message <[email protected]> of Sat, 21 Aug 2010
16:10:40 in microsoft.public.word.mailmerge.fields, Graham Mayor
If you don't make the registry change, you merely have to acknowledge the
prompt.

There's a macro at http://www.gmayor.com/word_vba_examples.htm which will
toggle the prompt on/off, but as it writes to the registry, I don't suppose
your company IT Nazis will approve of that either? Software does however
write to the registry all the time.

Agreed, the forums are poor, but they are the future ... unless everyone
come back here ;)
Click to expand...

I hope the forums are not the future, but fear I will be wrong.
On reading Doug Robbins recommendation, I followed the link.
I don't think he model does not give me what I have traditionally had
with newsgroups and I don't like what I do get. e.g.
1) one line per thread subject.
2) threading so I can tell the relationship between posts.
This thread is not a good example, as it consists of 4 messages:
a) Chris K posted the first message;
b) Doub Robbins replied to message a)
c) Chris K replied to message b)
d) Graham replied to message c).
3) I normally open a window in which threads containing new messages
appear first and others in which I retain an interest are then shown.
I can mark all messages as read, mark messages as interesting, and/or to
be retained. I can zap old messages when I choose.
4) I can batch download messages for future attention. I don't need an
Internet connection except when sending messages or grabbing them.
5) Cross-posting is supported. Used well, it can be helpful.
5) I can use Google groups to search a vast history of messages.
6) Group, and message creation is largely anarchic.

There are probably virtues in the forums. All I can see to date is
1) They are promoted by Microsoft.
2) Their Traffic is likely to be heavier than in traditional newsgroups
now that they exist.
3) Less spam - I assume this is true.
 
Graham Mayor said:
If you don't make the registry change, you merely have to acknowledge the
prompt.
Click to expand...

as mentioned, the prompt appears underneath the calling form, the form wont
budge (and Word wont open) until the prompt is answered - chicken + egg =
CTRL ALT Del

There's a macro at http://www.gmayor.com/word_vba_examples.htm which will
toggle the prompt on/off, but as it writes to the registry, I don't
suppose your company IT Nazis will approve of that either? Software does
however write to the registry all the time.

Agreed, the forums are poor, but they are the future ... unless everyone
come back here ;)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



Chris K said:
I'm not in a position to modify registry on company computers but thanks

So the short answer is that Access cannot be used to open an MS Word Mail
merge

P.S. Social Answers forums can not replace the current newsgroups
currently - just took a peek and the existing forums barely scratch the
surface of office apps (Access is hardly mentioned)

Maybe in next 5 years



Doug Robbins - Word MVP said:
See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open
a Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

Note these newsgroups are no longer hosted by Microsoft and are now
orphans
in the wilderness.

As a replacement for the newsgroups, Microsoft has created forums that
can
be accessed at:

http://social.answers.microsoft.com/Forums/en-US/category/officeword


--
Hope this helps,

Doug Robbins - Word MVP
dkr[atsymbol]mvps[dot]org

I know this must be asked 1000 times per day - so hopefully there is a
solution

Can I stop word telling me what it's told me a million times before?
namely "Opening this document with run the following SQL command"

It's causing havoc - I am trying to open a document from an Access Form

I can not answer the prompt because it is popping up underneath the
modal form - the form will not budge because it's waiting for the
prompt to be answered

Only solution is CTRL+ALT+DEL
Click to expand...
Click to expand...
Click to expand...
 
Agreed, the forums are poor, but they are the future ... unless everyone
come back here ;)
Click to expand...

Glad to see you back here -- do you have any idea why the macro you
(I'm pretty sure) provided for transposing two letters works _nearly_
immediately on Word2007 on Vista, but very very slowly on Word2007 on
Windows 7, on the laptop whose CPU is otherwise rather faster than the
CPU in the old IBM ThinkCentre desktop?

[followup set]
 
If you use the Community Bridge to access the newsgroups via an NNTP
newsreader, the experience is much the same as that to which you are
accustomed.
 
There are probably virtues in the forums. All I can see to date is
1) They are promoted by Microsoft.
2) Their Traffic is likely to be heavier than in traditional newsgroups
now that they exist.
Click to expand...

Much lighter, at least so far. MS is not prominently publicizing these groups,
and they seem to be harder to find than the newsgroups.
3) Less spam - I assume this is true.
Click to expand...

That at least appears to be the case - there are moderators who do remove
blatant spam promptly. The registration requirement (even if it's just the
need to use a msn email account) probably does the most to keep spam down.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
You can download the Answers Bridge (provided by MS even though it does
claim to be "not a Microsoft developed application") from
https://connect.microsoft.com/MicrosoftForums?wa=wsignin1.0 and the
Community Bridge (written by an MVP) from
http://communitybridge.codeplex.com/.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

Doug Robbins - Word MVP said:
If you use the Community Bridge to access the newsgroups via an NNTP
newsreader, the experience is much the same as that to which you are
accustomed.

--
Hope this helps,

Doug Robbins - Word MVP
dkr[atsymbol]mvps[dot]org

Walter Briscoe said:
In message <[email protected]> of Sat, 21 Aug 2010
16:10:40 in microsoft.public.word.mailmerge.fields, Graham Mayor


I hope the forums are not the future, but fear I will be wrong.
On reading Doug Robbins recommendation, I followed the link.
I don't think he model does not give me what I have traditionally had
with newsgroups and I don't like what I do get. e.g.
1) one line per thread subject.
2) threading so I can tell the relationship between posts.
This thread is not a good example, as it consists of 4 messages:
a) Chris K posted the first message;
b) Doub Robbins replied to message a)
c) Chris K replied to message b)
d) Graham replied to message c).
3) I normally open a window in which threads containing new messages
appear first and others in which I retain an interest are then shown.
I can mark all messages as read, mark messages as interesting, and/or to
be retained. I can zap old messages when I choose.
4) I can batch download messages for future attention. I don't need an
Internet connection except when sending messages or grabbing them.
5) Cross-posting is supported. Used well, it can be helpful.
5) I can use Google groups to search a vast history of messages.
6) Group, and message creation is largely anarchic.

There are probably virtues in the forums. All I can see to date is
1) They are promoted by Microsoft.
2) Their Traffic is likely to be heavier than in traditional newsgroups
now that they exist.
3) Less spam - I assume this is true.
Click to expand...
Click to expand...
 
Your message is several years old at this point so I doubt that you're reading this, but maybe someone else will stumble upon it. I have a similar situation with my database and I am definitely not a power user of access. Most of my "fixes" are the virtual equivalent of duct tape and bubble gum.

What others have told you above is correct. There is no easy way to disable that SQL warning window in MS Word, nor would you really want to because it's a good warning window. I wish Microsoft would redesign that pop-up so it didn't look so ominous, but that's not really what you're asking about.

Your situation is you've built a microsoft data base where a user enters information and then clicks a button, selects a hyperlink, whatever that opens a microsoft word file where you have built a mail merge document that autopopulates from the information in one of your tables/queries. The problem is opening that document causes a warning pop-up window to open that cautions the user and the pop-up warning is not easily accessible on the screen.

Two "solutions":

1. You can use Alt+Tab to find that pop-up, but you need to provide some information on the screen to let users of your database know that they have to press Alt+Tab several times to find the window and hit "Yes". It's not ideal, but it's there. Also, since it will be the most recent thing to be opened on the computer, you can can also navigate to the window using a single Alt+Shift+Tab. You can always write a macro to simulate those key strokes and make the SQL warning window active immediately.

2. IF microsoft word is not currently open somewhere on your computer when you try to access the mail merge file from the access form, then you will get the situation you described where there is some hidden SQL warning window somewhere on your computer that you can't see. HOWEVER, if microsoft office is already open, then when you try to access that mail merge file, the SQL warning window will automatically come to the forefront. Instead of just trying to open the mail merge file using a button, hyperlink, whatever, first, open Microsoft Word, and THEN tell your computer to open the mail merge file. This solution will at least make the pop-up window appear on the screen without having to find it.

Hope this is somewhat helpful.
 
Back
Top