VBA With Microsoft Access - Check if object exists

ms-access vba activex webbrowser-control
JMK picture JMK · Oct 19, 2011 · Viewed 52.8k times · Source

I'm using VBA with Microsoft Access.

I'm setting an object to an item inside a WebBrowserControl that sometimes exists, sometimes doesn't.

Dim myWebBrowser As Object
Dim myItemInsideWebpage As Object

Set myWebBrowser = Me.WebBrowser0.Object
Set myItemInsideWebpage = myWebBrowser.Document.GetElemendById("myDiv")

If 'myDiv' exists, awesome, if not I want Access to let me know so I can deal with it.

Answer

JimmyPena picture JimmyPena · Oct 19, 2011

I believe it would be something like

If myItemInsideWebpage Is Nothing Then
' doesn't exist
Else
' does exist
End If

You may need to preface your 'Set' statement with 'On Error Resume Next' in case an error is thrown when 'myDiv' does not exist.

Related questions

Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!

Read More
Get length of array?

I'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing something wrong? Dim columns As Variant columns = Array( _ "A", "ID", _ "D", "Name") Debug.Print columns.Length ' Error: Object required

Read More
How to add default signature in Outlook

I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding so far, but I'm new to Outlook. After creating the mailitem object, how do I add the default signature to …

Read More