Solved

Pop up capture in Access Web Object

Posted on 2007-11-27
3
744 Views
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.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22965154.html
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
 
 
 
End_Form_Load:
    Exit Sub
 
Err_Form_Load:
    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

0
Comment
Question by:wharrison359
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 84
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?
0
 

Author Comment

by:wharrison359
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.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 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:

http://msdn2.microsoft.com/en-us/library/aa752093.aspx

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.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

749 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