MS Access Query

Field Inspection App In MS Access

Today, we will consider how to track field inspections, by building a framework for a field inspection app in MS Access. This sample application is just a framework, and just shares some potential ideas. You can customize it and put your own “spice” on it. Here’s what it will look like when we’re done: First […]

Continue Reading

How To Make An Access Select Query

Hi everyone, This is not really a VBA item, but it’s important and you will need to understand this concept when you are creating your SQL statements in VBA. In our example we have a table called “Customers”: Now we just want the customers from “London”. So we set up a select query to select […]

Continue Reading

Why Does My Query Change Like To Alike?

“…everytime i save my query, the like function always turn to Alike…” ALike “*” & [Forms]![FORMsearch]![FIRSTNAME] & “*” should be: Like “*” & [Forms]![FORMsearch]![FIRSTNAME] & “*” “Like” kept changing to “Alike”! This was an interesting question I received. Well come to find out that this has to do with an Access setting related to “SQL […]

Continue Reading

How To Convert Your Pivot Table To An Access Crosstab Query

This post is regarding how to convert your Excel pivot table to an Access format. You can also refer to this post for more information: http://vbahowto.com/converting-a-excel-spreadsheet-to-access-database/ Basically an Excel pivot table is an Access crosstab query, so this post goes into more detail of how to make your Access crosstab query look like what your […]

Continue Reading

Watch How To Run VBA Code In Access

In this video you are going to find out how to run your VBA code in Access. I’ll show you how to add code to your Access form module, and you’ll also find out how to create a custom function, so you can design your own custom calculations and use them your queries. You can […]

Continue Reading

How To Create A MS Access Dynamic Report Based On A Dynamic Table

So in my other post, I demonstrated how to create a table dynamically with VBA. Here’s the post How To Create A Table In Access Using SQL And VBA Now what if we need a report based on a table that is always changing, but is consistent in its format? Well we can send the […]

Continue Reading

How To Run Access VBA On A Timer Schedule

At one of the contracts I am on currently, I run several backup procedures through out the day on some of the main tables if something should happen while I’m not on site. I set up a simple process. I am letting the Windows Task Scheduler, which runs as a service while the computer is […]

Continue Reading

MS Access Running Count With String Column And Duplicates

In my previous post, http://vbahowto.com/ms-access-running-count-with-duplicates/, the DCount counter, works fine when you have a numeric value, and it works fine when you do the VBA counter when you do it on numeric column values, but what about counters on string columns with duplicates? MS Access Running Count With String Column And Duplicates Since an Access […]

Continue Reading

How do I create a query between two dates in Access?

This post will show you how to create a query between two dates in Access using a query and in VBA. We will also show the results of the query in a report format, like shown in the image. The report dates are the selections from the parameter form, and can be accomplished with both […]

Continue Reading

MS Access Running Counter In Query

This video is part of a solution to an interesting question that I know most developers have faced or are facing… “How can I number my rows in an Access query?” tblRunningSum: Lists numbers starting with 8, and shows how qryIncrement can start at 1 and increment this count from 1 to 10. tblNumbers: Gives […]

Continue Reading




 

Call Erik Now