Articles & Videos
Microsoft Access is RAD (Rapid Application Development) with a built-in RDBMS (Relational Database Management System) produced by Microsoft. Access can be used to write both desktop and web-based applications. It is considered a RAD tool because of its ease of use, built-in features, and graphical wizards. Access uses VBA (Visual Basic for Applications) as its coding language. This area deals with all aspects of its use.
I have this:
Just checking if this is correct for the Control Source, it comes from SSMS Stored Procedure?
Thanks for any help...
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form t…
How do I convert the following Access crosstab query to T-SQL?
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 wont to get a Symbol Dialog like Word to select Symbols from any installed charset.
Has anyone an Idea how can i get this Dialog?
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referen…
I keep getting an error on:
Food: IIF ([Event] In (“Orange”,“Apple Slice”,“Pineapple Slice”), “Fruit Group”)
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 …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to b…
hello, i want to assign the year in a variable when my project opens and then use that throughout the entire project.
dim dPresentYear as date = 2015
dim dPreviousYear as date = 2014
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?
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:…
I have a 2010 Access front end with a SQL backend.
I have three views and a table that users can select from to view a list of records - Customers (table), ActiveCustomers (view; default), Inactive…
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…
a) What features of A2010 do you love
b) How have you made A2010 easier to work with?
for example: I put the design and vba buttons in the tool bar
yet if I go to my us…
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:
On my main form (frmMain) I have an unbound combo box (cboSelectClient) where a user can select a record and details about that client appear in a subform. On the main form I also have a…
Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013.
The native message box of Microsoft Access 2013 is boring and …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things …
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
17,464 points this week
Rey Obrero (capricorn1)
Seattle, Washington, United States
13,668 points this week
Scott McDaniel (Microsoft Access MVP - EE MVE )
North Augusta, South Carolina, United States
13,400 points this week
13,078 points this week
Syracuse, New York Area, United States
10,229 points this week