Run VBA on Tables

[maverickmonster]

Hi all

I would like to know if it is possible to run VBA on a Access table like as in Excel with vba ?

Thanks

Maverickmonster

 

[HarleyQuinn]

If I have understood your question correctly you can, yes. What is it you want to do to the table?

Harleyquinn

---------------------------------
For tsunami relief donations

 

[lupins46]

The question is not clear.
It is possible to write code to open and close tables, read through tables, find specific records, update records, save records, and any other actions you can normally do to data files.

 

[maverickmonster]

i nothing in mind just for future ref.

Just want to use it like an excel sheet like. eg if the reference numbers are the same then add their score to a total and then place it in a different sheet that kinda thing

 

[HarleyQuinn]

Yes you could do something similar to that using VBA and Access tables.

Cheers

Harleyquinn

---------------------------------
For tsunami relief donations

 

[ZmrAbdulla]

You could do calculations on the form and save to the table via VBA. But it is not recommended. Do it in a query, that is recommended.
BTW, Access and Exel are "different animals" can do many similar work but they have different "grazing land"

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.