Search results

  1. N

    Hi

    Thanks you for your reply There is no Master/Child Link Fields. When move the record through the loop, updating only subReport data.
  2. N

    Hi

    My code is as follows, but there is an error in the code, Please help me to resolve the issue. Private Sub Command33_Click() Dim Dbs As DAO.Database Dim Rst As DAO.Recordset Set Dbs = CurrentDb Set Rst = Dbs.OpenRecordset("Select * from [ACTIVE SERVICE ORDERS EXP EMAIL]...
  3. N

    Hi

    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.
  4. N

    Run-Time Error

    Thanking you for your quick responses, Images of my form and report menu are attached herewith for your reference.
  5. N

    Run-Time Error

    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...
  6. N

    Solved Code Error

    :) Thank you Very much for your valuable replies!
  7. N

    Solved Code Error

    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
  8. N

    New Member

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