Using CreateObject(“System.Collections.Stack”) within Access

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
226 views
0

When I try to SET/create a stack, I get a Run-time error ‘-2146232576 (80131700)’: Automation Error. I’m using Office Pro 2016 on Win 10.
Thoughts?

========================================================================
‘This declaration is (above) in the same module – where I make all my app level declarations
Dim WarningStateStack As Object

Sub InitializeWarningStateStack()
‘Stack Methodology adapted from http://analystcave.com/excel-vba-dictionary-arrays-and-other-data-structures/

‘Instantiate the Stack
Set WarningStateStack = CreateObject(“System.Collections.Stack”) ‘Create Warning State Stack

‘Clear the WarningStateStack
WarningStateStack.Clear

End Sub

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match