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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- cdun2
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- cdun2
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- cdun2
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
