Challenge with Access2000

[manu]

The previous Nth Select related string was getting too long so I chose to start afresh.

I can't seem to get either of the attached codes to work with Access 2000. These were working fine as long as I was using Access97.

I've tried using "Dim dbs As DAO Database" instead of "Dim dbs As Database". This results in a syntax error.

Can someone figure out the problem.....please

All help is appreciated.

Thanks

 

[WayneRyan]

manu,

Dim dbs As DAO.Database

If you get "Invalid user-defined function" or
something like that, you have a missing
reference. Get code in Design View, then
Tools --> References and make sure that DAO
is selected and has a higher priority than
the ADO reference.

You are also missing the Loop at the end of
the Do ... Until statement.

Wayne

 

[manu]

Thanks Wayne,

Given I'm not the author of this code and neither do I have the expertise, would you kindly update the existing code so it can work in Access2000.

Also, I tried your suggested priority settings etc...resulted in another error prompt [Compile error: Method or Data Member not found]

I guess I'll need a specific walk through given there's a whole bunch of references that I could choose from.

Thanks for your time in advance....

Regards,

 

[WayneRyan]

manu,

You REALLY do have a reference problem.

Look at the last thread and get your code in Design View and
select the proper reference.

Get the first things working and we'll address the others
later.

Wayne

 

[manu]

Thanks,

Attached is currently reference selections.

What would you like me to change?

 

[WayneRyan]

manu,

You really do have a reference problem. I downloaded your
.ZIP file and ... got nothing!

What you need to do is get your code in Design View and
do the References thing. AFTER you do it, choose:

Debug --> Compile ...

When you survive that, then you'll be OK.

Wayne

 

[manu]

I thought the prevoius attachment was ok....I guess not...soryy about that.

Here's another attempt tp show you what I currently have selected for references. Pls tell me what you would like me to choose instead.

Regards & Thanks for your patience


Manu

 

[namliam]

Do not double thread Manu !!!!

AAARGH, i gave the same answer on the 2nd thread... Geezzzz I hate ppl double threading.....