Phone List issue

[Alfi54]

Hi,



Re: https://www.accessforums.net/showthr...t-Example-form

I had a similar Customer Phone List successfully in use in A2003 ... now under A2010 there is a recordsetclone problem ... can anybody advise what can be done ? The above program has the same problem ... Alf

[RuralGuy]

RecordsetClone is a DAO property and ac2003 defaulted to ADO. Do you have *only* DAO enabled? Or both DAO and ADO?

[Alfi54]

Hi RuralGuy,

Annexed on the image are my references in both A2003 and A2010. If I didn't misunderstand your question DAO 3.6 should be applicable ... is the Phone Book Macro properly working on your PC ? Regards ... Alf

[RuralGuy]

I have not downloaded the template yet. I would uncleck ActiveX and see if you still have the same issue.

[Alfi54]

Hi RuralGuy,

Unchecked the ActiveX but no major changes ... have a look at the error msg ... however, and I missed to say, the filter has always worked ... just annoying that the message is appearing ... regards Alf

[RuralGuy]

Try *importing* everything into a fresh new db and see if the issue follows: http://www.btabdevelopment.com/ts/impnew

[Alfi54]

Hi RuralGuy,

Tried this already with my Makro and your above attached app .... no success ... error msg persists ... regards Alf

[RuralGuy]

Converted the Macro to code and it seems to work just fine.

[Alfi54]

Hi RuralGuy,

Great ... it works on both 2003 and 2010 ... one headache less with A2010 thanks to your great support .... regards Alf