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.
I have an Access 2010 database. I have two forms, FormA and FormB in the database which each point to the same table.
Scenario... UserA is editing FormA. UserB opens FormB, makes changes and c…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the W…
Please offer if there is a way for me to include a Grand Total for the column field in a crosstab quert - Access 2013.
I am able to calculate totals (based on counts) for rows, but not columns.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way t…
I have the tab order set on form fields, but I have about 100 records that need to be completed, starting at halfway into the form. Instead of mouse clicking each time, how can I create a shortcut key…
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 …
I'm selling childrenbooks to a few primary schools and wanted some help in managing my inventory.
I've setup a spreadsheet and EE have helped in making some improvements but I'm struggling w…
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…
Thank you for looking at my question,
I am trying to run a report in MS Access that was originally falling over with the error message in the title - "multi-level group by clause is not allowed in …
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 …
How do I get the on click event to work on a TAB Form. As a test I entered msgbox("Something"). but when I click the tab I don't get the message. Looking at some E.E questions & answers, "On …
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 would like to see "within specific folder & its sub folders" all excell files names and their sheets names
is it possible ?
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…
referring to this question
i have too many excell sheets , and really fail to find …
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:
Has anyone seen this error before. See attached error screenshot. It occurred after installing windows updates and I can't reinstall.
I am using a query to insert record from a combination of two tables into a third table.
One of the fields in the query is 'Comment' which is defined as 'Memo' in the table it is being pulled from …
I have a 2007 DB that I'm moving into the 2013 environment and some of the old command codes don't work.
I have a form named "Course". I would like to combine two events into one expression that 1)…
I have a table with boolean fields
[ItemID] as text
[Qty] as number
[InStock] as boolean
[Call_Back] as boolean
How do I build a query to show how many times the Item is in stock and not in…
Hi, in MS Excel I have 10,000 rows of data in 35 columns in Worksheet A, the unique identifier for each row is contained in Column C called the SaleID which is alphanumeric (sometimes an Integer or s…
Please offer why when I specify in a query to sort on one or more fields, the sorting does not happen in the output table?
I set the sorting specifications in query design.
After performing various operations, my access database has many duplicate tables.
I am looking for VBA code …
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…
Rey Obrero (capricorn1)
Seattle, Washington, United States
34,450 points this week
Dale Fye (Access MVP)
Virginia, United States
15,589 points this week
Stratford, CT, United States
11,100 points this week
Scott McDaniel (Microsoft Access MVP - EE MVE )
North Augusta, South Carolina, United States
10,418 points this week
Kilkis, Kilkis, Greece
9,000 points this week