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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bPruFin
  • Content: Threads
  • Order by date
  1. bPruFin

    Mail Merged Document printing out all pages when only certain are set.

    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!
  2. bPruFin

    Saving results of Mail Merge using VBA

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

    Can't open xls file generated from Access unless I go to Task Manager

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

    Trouble setting row source of chart in report

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

    Bulk Export Query Objects

    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?
  6. bPruFin

    Formats missing from Windows Registry.

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

Part and Inventory Search

Back
Top