Programming - question with VBA

[Mike]

Hi All,

Im trying to build a database and I really want to know
that can you use the VBA in ACCESS to build functions to
retrieve the data right off the tables in access. I'm
having difficulty trying to build querys from the ACCESS
Query interface.

Thanks for the suggestions...

Mike

 

[Joe Voll]

can you use the VBA in ACCESS to build functions to
retrieve the data right off the tables in access.

sure you can. with DAO or ADO you can define recordsets with SQL according
to your needs . The output is mainly the same like wizard-built querys.

Joe Voll.