Search results

  1. M

    Enter Parameters for Qry Recordset

    Hi All, I have a query with a "Between [Sdate] and [Edate] a the parameter for a DateOpened field. I'm able to export the query recordset to Excel using a button On Click, however I can't get the parameter prompt to come up to enter the start and end dates. This gives me "Too few parameters...
  2. M

    Export Multiple Table Records to Email Body

    Hi All, I've managed to write a script to send one record to the body of email, but I'm lost on how to get all records in a table to the body. Any advice is greatly appreciated! Regards,
  3. M

    Update Multiple Recs from Form

    Hello all, I'm currently at a lost but here's what I'm attempting to do. In my Form, I would like to show a qry in either Continuous or Datasheet view. With that in mind, I want a user to be able to highlight multiple non-consecutive records or select those records via a chkbox. Then using...
  4. M

    Export/Save As Pivot Table from Access to Excel

    Good Day All, I am using MS Office 2010 and trying to export a pivot table from a query to Excel then Save automatically. The following works exporting the pivot table to Excel but for the life of me I can't get it to Save using my strFileName and strFilePath: DoCmd.OpenQuery...
  5. M

    Question strSQL = Run Time Error 3075 Syntax Error Missing Operator in qry Expr

    Hello all, I've come across a simple error that has me baffled. I continue to receive the run time error 3075: Syntax error (missing operator) in query expression 'tblMasterPersonnel.FirstName"042" Or (tblMasterPersonnel.EmpID)="044"))' Here is the strSQL strSQL = " SELECT...
Back
Top Bottom