Articles & Videos
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
In the report for this query in Access 2007, defects and DCRs are grouped by system and ordered by descending rank. The grouping is done on the report level. I'm open to it being done in the query. I …
Rounding should be right at hand
In many areas, rounding that accurately follows specific rules are needed - accounting, statistics, insurance, etc.
Unfortunately, the native functions of VBA th…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a refer…
I am trying to use more bound forms, but am having some issues. For continuous form, if several of the fields are required, where and how would be the best way to validate the data before the record …
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Acc…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They…
Still having trouble opening word in access 2013. I have the following
Dim db As DAO.Database, rs As DAO.Recordset
Set db = CurrentDb
search = "SELECT * FROM tblC…
Have you ever been given the advice NOT to use domain functions inside queries? I have, and I have repeated that advice over and over again; why? The main reason is that this process …
When I try to print to a tray 1 on a printer it always redirects to Auto
When I use .Printer.PaperBin = 1 it goes to tray Auto
When I use .Printer.PaperBin = 2 it goes to tray 3
When I use .Pr…
When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the st…
I am having trouble with my bat file. I am trying to add today's date to a file and then move the previous days file in another folder. Example:
Yesterdays file is in a folder, I want to ru…
Dates are popular criteria in queries. Date ranges ("between #1/1/2015# and #1/31/2015#", for instance) are useful when you want to see everything that happened in January of 2015. But if you want …
I have this report "CustomerSalesmanCompariso
DoCmd.OutputTo acReport, "CustomerSalesmanCompariso
Oh no! Did you forget to:
1. Set up QuickBooks Payroll for Job Costing?
2. Check Payroll Items to Track Expenses By Job?
3. Assign Overhead to expenses not belonging to a particular job?
I have a query that is currently asking the user for a start and end date.
Is there an easy way to tie this to a point and click calendar?
If you need to edit a table with many fields, the form may be far too wide to be displayed in full on a normal screen. You will then have to limit the width of the form, leaving the user t…
Hi EE I have the following
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim filepath As String
If Dir(Path) <> "" Then
Set wrdApp = CreateObject("Word.Applica
This article explains how to consolidate QuickBoooks transaction types in a database so only one form or report can be used to view multiple transaction types. This article uses the tables:
We need a software package that we can use to ship demos of our Access 2013 and have it secure from editing or coping. Nothing expensive or fancy. I'm not a programmer so I need something easy to pa…
I have two queries, but I want to turn them into one with a subquery, but not sure how to do it. Below are the two queries. I am trying to get the PersonID to display in a combobox that are NOT in t…
In a list of names a combo box will scroll down to the smiths if you type sm for example. Is there away to do this with a list box
I am using an Autoexec to set the startup properties. I want to hide ribbon, but at the same time display the default short menu.
Why does the menu disappear?
I have a form that has a image block on it. I'm trying to get a scanned signature to appear in the field with this oncurrent event of the form but it isn't working. What am I doing wrong?
SET DocTypeNo = (CASE
WHEN ProtoTypeInd = TRUE THEN 2
WHEN VSType = "K" Then 3
WHEN VSType = "B" Then 3
WHEN VSType = "P" Then 4
ELSE 1 END);
For the above query. What…
MSAccess 2003: A query that picks up a date from an open form suddenly comes up with the error message "3126: Invalid bracketing of name '[forms!frmreports!frmToda
by Patrick G. Matthews Introduction: A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for eac…
by Patrick G. Matthews Introduction: All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Acc…
Stratford, CT, United States
19,800 points this week
Rey Obrero (capricorn1)
Seattle, Washington, United States
19,168 points this week
Virginia Beach, Virginia, United States
12,404 points this week
Scott McDaniel (Microsoft Access MVP - EE MVE )
North Augusta, South Carolina, United States
11,400 points this week
Syracuse, New York Area, United States
10,412 points this week