Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cdun2

  1. cdun2

    Export Parameter Query Results to Spreadsheet

    Thank you so much for taking the time to post this code! cdun2
  2. cdun2

    Export Parameter Query Results to Spreadsheet

    Hello, I have a parameter query called 'Rev by AcctCode' that takes it's value from a form field; Forms![SalesAssoc]![e-mail]. I am trying to find a way to run this query, get the parameter value to it, and populate an Excel spreadsheet with the results. Apparently, there is no direct way to...
  3. cdun2

    Zip A Spreadsheet, Then Send Via Email

    I got this to work: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Rev by AcctCode", "C:\Learning\ZipExcelFile\Results.xls" The problem is, "Rev by AcctCode" is an MS Access Query that takes the following parameter value; Forms![SalesAssoc]![e-mail]. I can run the code without...
  4. cdun2

    Zip A Spreadsheet, Then Send Via Email

    Thanks, I will look into this.
  5. cdun2

    Zip A Spreadsheet, Then Send Via Email

    Hello, I'm a non_VBA coder who has been asked to update the following Function: ************************** Function EMAILER_REV_BY_ACCTCODE_MACRO() On Error GoTo RA_EMAILER_Err DoCmd.SetWarnings False DoCmd.SelectObject acForm, "SalesAssoc", False DoCmd.SendObject acQuery, "Rev...
  6. cdun2

    Duplicate Text Objects in Group Header

    Hello, I have a text object in a group that is inteded to be a label to describe data in the group footer. How can I configure the text object/ group header so that the text object only appears one time when I have multiple records in the group footer? Thank you for your help. Please let me...
See more

Part and Inventory Search

Back
Top