Search results

Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim dbs1 As dao.Database Dim dbs2 As dao.Database Set dbs1 = OpenDatabase("C:\HCCTRL\Backup.accdb", True, False, "MS Access;PWD=BANDA") Set dbs2 = OpenDatabase("C:\HCCTRL\CHEQUESbe.accdb", True, False, "MS Access;PWD=DISSA")...

hi I want to change the record source (SQL) of sub report by VBA code when open the main report. Please help me to build the code.

The following code I use to send email with a report as an attachment. But it gives the error message "Cannot find the file, Verify the path & file name are correct" I checked file name (LETTEREMAI) is correct. Please help me to solve the issue. Private Sub Command29_Click() Dim...

Hi The following SUB is not working. Hence please help me to correct the Code. Public Sub USERACTV(Frm As Form, ANum As Integer) If ANum = 1 Then Forms(Frm.Name).Controls(btnNew).Enable = True Else Forms(Frm.Name).Controls(btnNew).Enable = False End If End Sub

Hi I am new for Access Programing and I am from Sri Lanka!