In access form I have a button which opens my word template document .dot and when that document opens and asks me if I want to run the SQL command (I also want to set that to yes by default so it doesnt show up on open).
When I click on Yes then a pop up window appears and asks me to select the data source. I want to set the data source once so it doesnt ask me always.
Edit: for disabling the SQL warning I found this on microsofts website
Is there another way or only this one? And yeah, Im using Office 2007
Thanks
When I click on Yes then a pop up window appears and asks me to select the data source. I want to set the data source once so it doesnt ask me always.
Edit: for disabling the SQL warning I found this on microsofts website
Code:
Word 2007
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options
"SQLSecurityCheck"=dword:00000000
Start Registry Editor.
Locate and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options
On the Edit menu, point to New, and then click DWORD Value.
Under Name, type:
SQLSecurityCheck
Double-click SQLSecurityCheck.
In the Value data box, type:
00000000
Click OK.
Thanks