Where to Start?

[excelledsoftware]

Hello everyone,

So I have been using Excel for a very long time and have become very comfortable coding VBA in it. Mostly ifs, loops arrays. That kind of thing. I want to learn Access VBA but I am having trouble finding information to Access objects. How would one write code to look through 1 column of a table and report back how many rows. which I assume would be something simple like [table].[column].count

But again I havent been able to find some really good tutorials out there.

Any suggestions on where to start?



Thanks in advance.

[pbaldy]

Depends on how/where you need the answer, but a simple query or DCount(), like

DCount("*", "TableName")

[June7]

Options:

1. build an aggregate (Totals) GROUP BY query - Access Help has info on building queries

2. open a recordset in VBA using SQL and read the RecordCount property of the recordset.

3. use DCount (a domain aggregate function) in query or in textbox on form/report - Access Help has info about domain aggregate functions

4. bind form or report to table and use Count function in textbox to count the records in the form/report RecordSource

[excelledsoftware]

Thanks for the info so far. I appreciate all the different ways there are to do things. My main question is what is the best way to learn these objects in Access. the Dcount was an example but where is a great starting point for learning Access VBA?

Thanks again.

[June7]

Bing: Access introduction to programming

http://office.microsoft.com/en-us/ac...010341717.aspx

Also, Amazon.com.

https://www.accessforums.net/general...ing-24133.html

[excelledsoftware]

Awesome! I am surprised I wasnt able to find these before. Thank you very much.

[orange]

You might also find this site useful.

[Xipooo]

Not trying to be self promotional, but I do have a series of Youtube videos for beginners.

https://www.youtube.com/playlist?lis...03jQ_t9nFV737s

[excelledsoftware]

Not trying to be self promotional, but I do have a series of Youtube videos for beginners.

https://www.youtube.com/playlist?lis...03jQ_t9nFV737s

I gotta say even though I know a lot about the things you go over in your videos this appears to be the route I am going to learn the most from. Cant wait to get through all the videos.