Search results for query: *

I'll check it out. Thanks.

The one other thing I've noticed is that the VBA code is still running. I simply created a blank form and put a command button on it from which I called the function RunReportAsPDF. Private Sub cmd_Canned_Rpts_Click() Call RunReportAsPDF("1 rpt_Summary", "rpt1") End Sub For some reason...

Hello, I've been trying to print an access report to pdf. I've looked at thread707-1119207 and it runs - the printer icon pops up and shows that a document is spooling, the adobe icon shows that pages are printing to pdf. However when it is all done and there is nothing left in the print que...

Hi, Currently in my listbox I have a rowsource of SELECT region_nbr, GEO_REGION FROM qry_choose_region UNION SELECT "*", "-- All Regions --" FROM MsysObjects ORDER BY GEO_REGION; I would like to assign this rowsource programmatically to the variable strRowSource as shown below...

Nevermind. I figured it out.

Hi, I'm trying to run the code below but I get the error message "Method or data member not found". I have already add the references 'Microsoft Outlook 10.0 Object Library' and 'Microsoft Outlook View Control'. It get hung up at the 'myOLApp.CreateItem(olMailItem)' part of the code. Thanks for...

That gets me to where the security patch comes up and asks me whether I want to allow the email to be sent.

OK. Thanks. I'll check it out.

I have a program that will send a report to email addresses contained in a table. The problem is that Outlook opens and I have to click on the "send" button everytime before the program loops and the next email is created. How do I programmatically click on the "send" button. Also, if there is a...

I got the database fixed. Somehow there were some leading blank spaces that were messing things up. I think this happened when I copied someone's code off of the web and tried to modify it. Thanks a lot for all of your help. Mike

I created the sub by adding a button to my form. Right clicking on properties, Event tab, On Click, ... then selecting coder builder and OK.

Here is the latest incarnation of the code which I think is the easiest to understand. I have two tables. One table, tblEmail is a has a unique list of the field IPA_NUM. The other, DATA1 has all of the data from which the report is built which many rows of data per IPA_NUM. I'm stilling getting...

Yes the button really is named Command79. I just threw in a button to test the code. I am really new at programing so this was the only way I knew how to test the code. The code I borrowed from someone else's tip while surfing this site and tried to modify it. [IPA_NUM] is character. kjv1611, I...

The first line is highlighted, Private Sub Command79_Click(). Also, although your right about me running on an older version of Access, 2002 I have the reference to Microsoft Office DAO 3.6 Object Library checked already. Mike

I'm getting an error code when I click my button that says "Compile error: Sub or Function not defined". How do I prevent this? FYI I'm trying to email a report based on a number if a table called tblEmail. One report for each line in the table. Thanks. Mike Private Sub Command79_Click()...

Hi Remou, Thanks for replying. I have looked at the forum you suggested even before posting my thread and while many are similar they are not the same. All of the filtering I've seen deals with Previewing a report not exporting which I already know how to do. Also the filter always refers to a...

I have a report based on a table, 'DATA1'. For each unique groupnbr in 'DATA1' I want to export a report to show only the data for that group number and save the name of the report to be based on the value on the group number. For example if group number = 1234 then I want the recordsource of...