Search results for query: *

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

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

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

Thanks, I will look into this.

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

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