Pop up capture in Access Web Object

Posted on 2007-11-27
Medium Priority
Last Modified: 2013-11-29
What do I need to change in this code to make a popup appear within the access environment instead of a new internet explorer page?

This link provides more details, the solution there did not work unfortunately.

Private Sub Form_Load()
On Error GoTo Err_Form_Load
    Me.txtURL = "https://vsr.citigroup.net/virtualsecurityrequest"
    If Len(Me.txtURL) > 0 Then
        Me.ocxWebBrowser.Navigate Me.txtURL
    End If
    Exit Sub
    MsgBox "Error " & Err.Number & ": " & Err.Description & vbCrLf & _
        " in " & Me.Name & ".Form_Load_Click", _
        vbOKOnly & vbCritical, "Smart Access Answer Column"
    Resume End_Form_Load
End Sub

Open in new window

Question by:wharrison359
  • 2
LVL 86
ID: 20358151
What do you mean by "a popup in the Access environment"? Are you referring to an IE popup? What's the popup supposed to do?

Author Comment

ID: 20359795
Yes, I would like to capture an IE Popup within access. The code above loads a webpage within access, but when I click on a link that leads to a popup, that popup always ends up outside of the access environment in a normal ie popup. I need the information in the popup to remain within access so that I can program run some code on it to append a database with user records. http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22965154.html gives an example of a webpage you can put in the above code

" Me.txtURL = "insert new webpage here"

That will demonstrate how when you click on the link a new ie webpage opens outside of access.
LVL 86

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 20373000
I'm not sure you can force IE to place the popup in a particular location ... there may be some properties/methods of the WebBrowser control, or a sub-object in that control, but I don't really know.

This links explains the Naviagte method in details; perhaps you could use one or more of the Methods here to get what you want:


You might also try posting a pointer question in the IE section for this (http://www.experts-exchange.com/Internet/Web_Browsers/Internet_Explorer/#browseZones); those guys do a LOT more with this type of thing than do we, and might be able to help.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question