Recent content by Dr_Sherlock

Hell Guys, I get this reply when I open the App "Variable not defined". Where I have the (Form1 in the code <Set oForm = Form1> being Highlighted. Actually I am trying to build an automatic backup in access. I have the entire code pasted below I need help. >> Function RunSub() Dim sFile...

Option Compare Database Option Explicit Const sSELECT = "SELECT tblUserLog.UserID, tblUserLog.LogIn, tblUserLog.LogOut " & "FROM tblUserLog " Const sWHERE = "WHERE (((tblUserLog.LogOut) Is Null)) " Const sORDER = "ORDER BY tblUserLog.LogIn DESC;" Dim sSQL As String Private Sub cmdAll_Click()...