Solved

Pop up capture in Access Web Object

Posted on 2007-11-27
3
739 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now