Child ID Access

Forcing a password to be entered in order to run a query
Here’s the code I used
Password.SetFocus
If Password = “Manager1″ Then
MsgBox “Access Granted”, vbInformation, “CD Shop”
MsgBox “Delete Query Active”, vbInformation, “CD Shop”
DoCmd.RunMacro “M_ArchiveStock”
MsgBox “Deletion Confirmed”
Else
MsgBox “Please re-enter your Password.”
End If

Duration : 0:6:54

(more…)

This demonstration by the author of XL-DBQuery Kevin Edwards, shows you how to use the query/sql builder XL-DBQuery to query a Microsoft Access database and then export the query results back into Excel as dynamic, refreshable Excel Pivot Table. Find out more at sbsdevltd.co.uk

Duration : 0:4:31

(more…)

Simple select queries, on one or more fields

Duration : 0:2:21

(more…)

Using queries to selectively delete records

Duration : 0:2:50

(more…)

Learn how to use a crosstab query in Microsoft Access at www.teachUcomp.com. Get the complete tutorial FREE at http://www.teachucomp.com/free – the most comprehensive Access tutorial available. Visit us today!

Duration : 0:4:43

(more…)

A brief demo of Dashboard Builder for Access, which gives you quick access to your data without knowing VB.

http://www.opengatesw.net

Duration : 0:6:35

(more…)

Using a calculated field to work out the tax payable on an item, then adjusting item value

Duration : 0:4:27

(more…)

Parameter Queries in Microsoft Access

Duration : 0:4:12

(more…)

Creating queries in an Access database.

Duration : 0:10:45

(more…)

Learn how to make an Aggregate Query in Microsoft Access – to sum up all of a customer’s order amounts, for example. Go to www.599CD.com/Access/YouTube for more free tutorials.

Duration : 0:4:49

(more…)