DoCmd. cmd. Me. problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have XP Professional and my database is 2000 format. Anytime I have in my
code the DoCmd. cmd. or Me. and I debug I get hung up there.
I have Microsoft ActiveX Data Objects 2.1 Library referenced and my dim
statements are:
Dim blnQueryExists As Boolean
Dim cat As New ADOX.Catalog
Dim cmd As New ADODB.Command
Dim qry As ADOX.View

I know this isn't much for you to go by, but does anything stick out that I
should be doing or not doing?
 
Sheryl said:
I have XP Professional and my database is 2000 format. Anytime I
have in my code the DoCmd. cmd. or Me. and I debug I get hung up
there.
I have Microsoft ActiveX Data Objects 2.1 Library referenced and my
dim statements are:
Dim blnQueryExists As Boolean
Dim cat As New ADOX.Catalog
Dim cmd As New ADODB.Command
Dim qry As ADOX.View

I know this isn't much for you to go by, but does anything stick out
that I should be doing or not doing?
Click to expand...

You're right, it isn't much to go on. You don't mention that you have a
reference to "Microsoft ADO Ext. 2.x For DDL and Security", which you
would need in order to define an ADOX.Catalog or View object, or any
other ADOX objects.
 
I know this isn't much for you to go by, but does anything stick out
that I should be doing or not doing?
Click to expand...

No it isn't. What is the code that causes the error and what error message?

Tim F
 
Back
Top