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
Solved

Pop up capture in Access Web Object

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

808 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