ODBC error getting data from Ms Access Query that use Visual Basic

[got01ar]

I'm trying to get data from a Ms Access Query, that has a Visul Basic routine to calculate a field, using ODBC and I couln´t.
I am testing this issue from Crystal Rport 8.5 and Excel

If I remove the Visual Basic routine assigned to the field in Ms Access Query it works.

Thanks in advance

 

[Darrylles]

Hi got,

The VB 'routine' may help - no?

i.e.(We have nothing to go on here).

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." AND "A pointer to a solution is better than the solution - you'll remember the solution via a pointer". darrylles@totalise.co.uk