DoCmd. cmd. Me. problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheryl - 07 Feb 2005 17:45 GMT

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?

Reply to this Message

Dirk Goldgar - 07 Feb 2005 17:57 GMT

> 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
[quoted text clipped - 8 lines]
> I know this isn't much for you to go by, but does anything stick out
> that I should be doing or not doing?

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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Tim Ferguson - 07 Feb 2005 18:20 GMT

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

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

Tim F

Reply to this Message