Recent content by bPruFin

I have a mail merge document that I created used Access. The problem I am having is that when I go to print only a certain number of pages (Entering the page numbers in Page range-->Pages:) it prints out all the pages in the document. Any ideas? Thanks!

Hi PHV, No I have not. Looks like a good idea and will try it out. Thanks! - Bruce

When I run the following code (from Access) ... doc.MailMerge.Destination = wdSendToNewDocument doc.MailMerge.Execute ... I get the results of the merged word document in a new file called "Form Letters1". My question is, how do I refer to this new file so that I can then work with it (e.g...

Thanks PH!

Thanks Roy, I will try this out. Unfortunately I'm busy with another project so I won't get back to this one until later in the week or next week at the earliest. One question I do have, though, is what is meant by the term "unqualified reference"? Thanks again! - Bruce

I have the following code (in Access 2000): Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Workbooks.Open (NewFileName) Dim xlBook As Excel.Workbook Set xlBook = xlApp.Workbooks(1) {more code here} xlBook.Save xlBook.Close...

I'm using Access 2000. In my Report_Open event I am trying to set the row source of a chart that I have on the report. Right now my chart (OLE Class: Microsoft Graph 2000 Chart) has the row source set statically in the properties box. However, I need to be able to set this dynamically. When...

Thanks! That's what we ended up doing! I guess in Microsoftistan people drive cars backwards ;-)

I need to export a number of query objects (the queries themselves not the data that is queried) to another Access database. It seems that I can only do this one at a time. Does anyone know of a way to export multiple objects at once?

I'm getting an error (see below) when I get to DoCmd.OutputTo command at the end of this code. Dim db As DAO.Database Set db = CurrentDb Dim qryOut As QueryDef db.QueryDefs.Delete "tmp" Set qryOut = db.CreateQueryDef("tmp", q2$) DoCmd.OutputTo acOutputQuery...