Help with a form for filtering a query

[ma t]

Hello all,
I found a sample db on Martin Green's http://fontstuff.com/access/acctut18.htm
It works in his sample mdb but when I try to import the form into my current project it blows up. I think it has to do with the ADO reference. Is there a way to get around this? I like how the form works, it's exactly what I was hoping for. Thanks in advance,

 

[rzw0wr]

Please define "Blows Up".
Error messages?
Just quits?
What version of Access are you using?


Dale

 

[ma t]

The sample code says this:
' This code uses ADO and ADOX and is suitable for Access 2000 (and later).
' A reference must be set to Microsoft ADO Ext. 2.7 for DDL and Security.

I can't find 2.7 so i created a reference to 2.8.
The line that seems to be the offender is:

Dim cmd As New ADODB.Command

 

[ma t]

Hello Dale,
I am using 2010. The code window opens and i get a message that says "user defined type not defined" and the line of code i mentioned above is highlighted.
I am very novice at VBA but I hope to learn more.

 

[rzw0wr]

Yes Ma t,
The db just bombed on me also.

Look at this site.
This is a little over my head also.

http://support.microsoft.com/kb/317867

Dalw

 

[rzw0wr]

Google,
Microsoft ADO Ext. 2.7

See if that gives you any help.

Dale

 

[ma t]

By the looks of it, it's WAY over my head. I was hoping this would be simple. Hah!

 

[rzw0wr]

I think we are at the same impasse ma t.

Sorry I could not be of more help.

Dale

 

[ma t]

ok- i may have stumbled on something. I compared the references in the sample to my current project and there was another one missing. I created a reference to the MS active x 2.1 and it now works!

 

[rzw0wr]

Great.
Glad yo hear you got in working.

Dale