www.techonthenet.com Tutorials

Joining 3 tables (using left joins) in Access 2003
How do you link 3 tables together, where table 1 is linked on one field to table 2, and the table 3 is linked to table 2 on another field?

Suppress system messages (Query confirmations)
How can I suppress the system messages when I run queries? For example, when a delete query is run, Access will ask you to confirm the number of deletions. How can I suppress these kinds of messages?

Set the value of a textbox based on the value of another textbox
What VBA code do I use to set the value of a textbox based on the value of another textbox?

DFirst Function
The DFirst function returns the first value from a specified set of records (or domain).

Query to retrieve max date in Access 2007
How can I build a query to select the latest date among several records?

Case Statement
In Access, the Case statement can only be used in VBA code. It has the functionality of an IF-THEN-ELSE statement.

Define a custom format for a Date/Time field in a table
I have a table with a date field in it. When I view the table, I'd like to see the date value displayed as "mm/dd/yyyy hh:nn:ss" format. How can I do this?

Create a form where you can search any text field in a table
In Access 2003/XP/2000/97, I'd like to have a button on a form that when clicked will open a popup form. On the popup form, the user can select (from a combo box) one of the field names contained on the original form and text to search on.

Populate a combo box with a list of values (not from a query)
I've created a combo box in Access 2003/XP/2000/97. I don't want to populate the combo box with an SQL query. Instead I want to add my own values. How do I populate a combo box with a list of values that are not generated from an SQL query?

Prevent a query from timing out in Access 2000
In Access 2000/97, I keep getting an ODBC timeout error when I run my query. How can I prevent the query from timing out?

IF-THEN-ELSE Statement
In Access, the IF-THEN-ELSE statement can only be used in VBA code.

Display parameter values in a report based on a parameter query
In Access 2003/XP/2000/97, how do I display parameter values in a report based on a parameter query?

Access does not recognize table changes to linked tables
How come when I can the configuration of a table that is linked, Access does not recognize these changes automatically?

Right Function
In Access, the Right function extracts a substring from a string starting from the right-most character.

Delete/remove the switchboard
I have a switchboard but I want to remove it. How can I delete the switchboard from the database?

Query to retrieve the number of customers with a certain shoe size
In Access 2003/XP/2000/97, I have a table of customers and their information like shoe size and shirt sizes. I want to create a query that adds up all the people with a each shoe size and get a total. For example, if I have 30 customers, I want the query to add up all the customers with shoe size 7 to get the total.

FileDateTime Function
The FileDateTime function returns the date and time of when a file was created or last modified.

Display reports in the Navigation Pane in Access 2007
In Access 2007, how do I display all of my reports in the Navigation Pane?

Concatenate first name and last name fields with a space in the middle
In Access 2003/XP/2000/97, how can I concatenate the first name and last name fields with a space in the middle?

MonthName Function
In Access, the MonthName function returns a string representing the month given a number from 1 to 12.