Search results for query: *

Hi all, I would like to have an additional attachment added automatically to the mail message generated by the SendObject-SendTo command. One of the parameters is templateFile: expression.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage...

Dragging and dropping the 3 reports onto a new Report accomplished my goals. Thanks to Everyone, Dan

Thanks All, Manipulating the query got me the information I needed for my report into one table which was basically a table sort: SELECT [Investors Sort].Investor, [2003].Manager, [2003].[Capital Introduction Referrals], [2003].["One on One" Manager Meetings], [2003].[Capital...

Thanks All, Manipulating the query got me the information I needed for my report into one table which was basically a table sort: SELECT [Investors Sort].Investor, [2003].Manager, [2003].[Capital Introduction Referrals], [2003].["One on One" Manager Meetings], [2003].[Capital...

Hi All, I would like to loop through a list which would output a report to a file for each iteration. How could I append the file instead of having it over written? Public Sub OutputReport() DoCmd.OutputTo acOutputReport, "Report1", acFormatRTF, "C:\temp\MyDatabase.rtf&quot...

Hi All, I would like to loop through a list which would output a report to a file for each iteration. How could I append the file instead of having it over written? Public Sub OutputReport() DoCmd.OutputTo acOutputReport, "Report1", acFormatRTF, "C:\temp\MyDatabase.rtf&quot...

The Report now reads like this: INVESTOR One on One manager manager ... Capital Introduction Event manager manager ... Capital Intrduction Referrals manager manager ... I would like to append the next investor and so on... Thanks again, Dan SELECT...

Hi hneal98, I created 3 queries all of which use the same variable taken from a form list. I then created 3 Reports, one from each query. I then dragged and dropped each report into a main report. I now have a report based on a single investor(the variable criteria). What I would like to...

Hi all, I have a master report that has 3 sub reports which are based on 3 different queries, respectively. I generate the report from a Form. The queries use the same variable that is selected from a list. I now have a my report which is based on one item in the list. How can I open the report...

Hi Duane, Where on the query grid would I enter the getVal function? The function is picking up the string as shown through a message box but the query is coming up empty. I put the getVal() function where the parameter used to be without the brackets. Thanks for your time, Dan

Hi All, I would like to get a string from a list box on a form and assign it to a variable. Then use that variable in the 3 select queries I've already created which are using a parameter at the moment. A heads up in the right direction would be appreciated. Thanks, Dan

I would like to build one report with three differnt queries but it seems like I can only use one control source per report. Any suggestions would be apreciated. Thanks, Dan