New at Access and need direction

[Montez659]

I have programmed with VBA for a number of years but have always shyed away from using Access because of it's former user unfriendliness. Now I have come to a point to where I need to bite the bullet because my company uses Access to track a number of "metrics."

So, I need a little direction, because I don't really know where to start. I am trying to find out if I need to build a query for every single thing piece of info I am looking for, or whether I should do it programmatically. For instance, just one thing I am looking for are all jobs started within a month and whether that job was finished within 10 business days. Also, need to know the total amount of jobs, and how many we completed within the time.

This is just one scenario, and most of these are based off of the same info. I have scoured the web looking for a beginning tutorial on querying programmatically only to not be able to find (maybe not searching correctly?) the info I need. Any direction is greatly appreciated!

 

[Phildaburn]

You can combine VBA and SQL to extract the information you're wanting.

 

[Montez659]

Do you know of any resources that I could check out to see some of the VBA language to query and filter results?

 

[Phildaburn]

A quick google search for "MS Access VBA and SQL" brought up many links. The first one is this one: http://www.databasejournal.com/feat...5836/Executing-SQL-Statements-in-VBA-Code.htm

 

[alansidman]

Look at this site for videos on how to develop queries.

http://www.datapigtechnologies.com/AccessMain.htm

Alan

 

[Montez659]

Thanks Alan! That looks like the information that I was needing.

 

[james_lankford]

below are links to generic vba and querying data using ADO

this is the kind of vba you could use inside an excel module to query access or oracle or sql server

you could also use ADO objecdts and functions inside MS Access itself, but if you're inside access there are short cuts and other ways of doing things (you wouldn't need to create a connection to the database because you're already in the database, you could use some of access's built in objects and functions, you could use the DAO objects instead of the ADO objects - with access you can build and save queries and later use these queries really easily with DAO; you could also, sometimes, if the conditions are right use the saved access queries with ADO, but not so easily)
===================
Getting Data

* Connecting to Data Sources
* Preparing and Executing Commands
* Receiving Results

http://msdn.microsoft.com/en-us/library/ms675800(v=VS.85).aspx

Creating a Connection String

http://msdn.microsoft.com/en-us/library/ms675122(v=VS.85).aspx

Using a Connection Object

http://msdn.microsoft.com/en-us/library/ms675947(v=VS.85).aspx

Receiving Results

http://msdn.microsoft.com/en-us/library/ms676592(v=VS.85).aspx

Creating and Executing a Simple Command

http://msdn.microsoft.com/en-us/library/ms675065(v=VS.85).aspx