Turn off data access web component warning messages

MS Office Access


  • 1. IE Automation / ExecWB OLECMDID_SAVEAS
    Hi! I'm working WAY over my head on some access code. I'm having fun, but have hit a roadblock.... I have an access module with some code that attempts to have internet explorer open a specific url and save the contents to an .xml file. I have it all working when I step through the code line by line in the debugger, but it generates an error message on the saveas command when I let it run w/ no breakpoints. The specific line of code is: web.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DONTPROMPTUSER, "C:\test.XML", "" (note, that is all on one line in my editor. web is the object name I've assigned) The error box that pops up says: "Method 'ExecWB' of object 'IWebBrowser2' failed" I've tried to slow things down by putting in some loops that trap for the busy event to clear, (ie. while web.busy debug.print "waiting") but this makes no difference. Anyone have any suggestion? Thanks so much! -Michael
  • 2. IExplorer Fill in text boxes and submit
    I am trying to automate a daily download task. The point click way is to navigate to the website, pick a radio button, fill in two text boxes, then click a button. The page opens a new Iexplorer wi9ndow with an EXcel spreadsheet. I'm pretty sure I can save this by using Get active object once I am able to automate the submit process. All controls are on the same page and I don't think anything happens until you click the button, which I assume is a 'Submit" button. So far I can open IExplorer and navigate to the page I want by using Dim ieApp As InternetExplorer Set ieApp = New InternetExplorer ieApp.Visible = True ieApp.Navigate... My research has led me to think I need to use POST, but that's where I get lost. If you can help, please include a complete example. Maybe using Goolgle's generic search page, or msn.com. Thanks in advance. -- I may not know yet, but I will.
  • 3. FREE Indian oil for men!
    Free Indian oil promotion for men! 100% free trial bottle, safe and great fun! Tel : 91-22-24449309/56663081 MURLI WAGHULDE

Turn off data access web component warning messages

Postby ZHJvc2UyMTEy » Sat, 05 Nov 2005 20:47:03 GMT

I have a Data Access Page I created and all I need to do is turn of the web 
component warning message "Access 2003 This website is using your identity to 
access a data source. if you trust this site, click OK to continue, otherwise 
click cancel." My boss does not want to see this message. I checked the allow 
data sources accross doamins to get rid of the first message but the message 
above has me stumped. I tryed a macro and scripting to get rid of the message.

Similar Threads:

1.Turning off warning messages in Access Runtime

Insert into your macro as the first step:
    Action: SetWarnings
        Expression:  No

Then insert after the queries are run:
        Action: SetWarnings
        Expression:  Yes

       Ken Snell

"Doug Hart" < XXXX@XXXXX.COM > wrote in message
news:02bb01c34578$e6cafa80$ XXXX@XXXXX.COM ...
> I have an application that uses Access Runtime.  How do I
> turn off the warning messages when queries are executed?
> The screen comes up and offers a "Help" button, but then
> displays nothing when I click on it.  I cannot find any
> settings file that is packaged with the application to
> make the change.  The macro needs to run without any user
> interaction as part of an unattended overnight process.
> Any help would be greatly appreciated!

2.warning message Access 2000 cant turn off

I am running a docmd "openhyperlink" and when the 
hyperlink is about to be loaded a message appears 

"Some files can contain viruses or otherwise harmful to 
your computer, it is important to be certain that the file 
is from a trustworthy source" Would you like to open the 

I have spent hours trying to turn this message off, does 
anyone know how to disable this message. I have 
tried "Setwarnings" with no luck.

3.Access 2003 runtime mode-can't turn off warning messages for macro

In Access 2003 I turn off all the warning messages in the Edit/Find tab under 
Tools + Options for my data base.  I then package it with the Access 2003 
Developer Extensions Tools Wizard into a  .dme runtime package.  When I run 
it on another computer other than mine, a computer with Access on it or one 
without Access on it, I get all the warning messages for macros and queries, 
as if I never turned off the Warning messages in the Edit/Find tab.  Any 

4.How to remove web components warning when open Data Access Page in

I created a few data access pages. Everytime I open one of them this warning 
from Office Web Components pops up - "The website is using your identity to 
access a data source. If you trust this website, click OK to continue, 
otherwise click Cancel." Is there any way I can remove this? Thank you. 

5.Turn off warnings on a data access page

Does anyone know how to turn off the warnings when a data access page is 

First warning:

This website uses a dataprovider that may be unsafe. if you trust the 
website click ok....

Second warning:

this website is using your identity to access a data source. if you trust 
this website click ok.....

6. Web Components warning messages

7. turn off warning message in mde

8. Turn off default warning messages

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 58 guest