Child ID Access

Using QBE builder to provide SQL and sticking it into VBA in order to run a delete query

Duration : 0:6:23

(more…)

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…)

simplest way to update add edit delete save to an access 2007 database through a datagridview in vb.net 2008.

Duration : 0:3:31

(more…)

Simple VBA that creates a ‘Help Form’ in Access

Duration : 0:6:8

(more…)