Search results

  1. A

    Parameter VBA

    Dim rst as recordset Set rst=Currentdb.OpenRecordset("tableName/QueryName") While Not rst.EOF your code goes here for export to pdf wend set rst=nothing
  2. A

    Command to search records

    Datatype mismatch error showing whenever you try to compare two different datatype so if field datatype is number just compare it "FieldName=" & formName.ControlName, if it text Datatype then "FieldName='" & formName.ControlName & "'" Here you can see that i have added sigle quote on text...
  3. A

    Export Query Data to Excel Range

    Just use single cell while selecting range with excel application also use space between "Select * from query1.tracker ............ ".
Back
Top Bottom