in
All Tags » VBA » reports (RSS)

Browse by Tags

  • Conditional printing of a sub-report?

    I have a report that is designed to exactly fit one page. I have a sub-report (containing photos) that is at the bottom of the page. It prints on page 2 because there is no room on page one. The problem is, if the record has no photos (no data for sub-report), the print report still prints a blank page...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-20-2010

  • Update table from report

    I have a report that runs from a button on a form. The report automatically launches into word with the following code: Dim QueryName As String Dim sql As String Dim rc As Integer Dim db As Database Dim qdf As QueryDef Dim StrVendor As String Dim StrInvoiceNumber As String Dim StrClaimNumber As String...
    Posted to Access Coding/Macros (Forum) by microsoft on 04-14-2010

  • Access Report VBA Print Seleted pages

    I have a report that list items of an order. Each department starts a new page. Some of the departments need a copy of the report. In order to save paper,instead of printing the entire report twice, I want to print selected pages twice, depending on the department. The page numbers of the full report...
    Posted to Access Reports (Forum) by microsoft on 03-24-2010

  • VBA Report Recordsource Issue/Question

    don't want to hear about the structure of my database. I just want to know how to accomplish this task. I have I series of colonies that consist of the same table. I have a variable that holds the colony number from login. I would rather not make a few copies of the same report. I have a report with...
    Posted to Access (Forum) by microsoft on 02-15-2010

  • Insert Page break in Detail after each 5 records

    I have attached a database with a report named rptAttendForm that will be used to print an attendance sheet for a training class that can span any number of days. The class info (name, classID, Company who we're teaching, etc.) are in the table tblClasses which is what the report is bound to. There...
    Posted to Access Reports (Forum) by microsoft on 01-24-2010

  • Telling Access to print a report in two copies?

    Hello, Is there a way to tell Access to print a report in two copies? It would be neat to immediately have two copies of the reports instead of having to manually xerox the first (and only) report. Thanks a lot! Jerome
    Posted to Access Reports (Forum) by microsoft on 11-09-2009

  • Access 2003 Report forgets Page Size/type

    I have a report in access that uses a specific printer with custom paper. The printer is called PO printer, the paper is called PO. In the report page setup I set the Printer to specific printer (the PO Printer) and then I set the margins to .17, .171, .25, .25, and paper size to PO. In the PO Printer...
    Posted to Access Reports (Forum) by microsoft on 10-31-2009

  • How do I dynamically highlight clicked links in a report?

    I have a report that contains several fields (in the detail section of the report) that are lists of hyperlinks. I have a click event that fires whenever a link is clicked that launches a browser and points to the clicked link. However, I want to provide feedback to the user that they have already clicked...
    Posted to Access (Forum) by microsoft on 09-24-2009

  • Access Add a Landscape Subreport to a Portrait Main Report

    I have a main report that is in Portrait orientation and want to add a linked subreport that is in Landscape orientation. The end result is it will be saved as one PDF file and emailed to a client, and I really need it to be one document rather than two. Any suggestions? I'm proficient at VBA so...
    Posted to Access (Forum) by microsoft on 09-12-2009

  • I want to create a report based on a query and then export that report to an existing excel spreadsheet

    I can't for the life of me remember how to create a new report based on an existing query but then i would like to be able to open an existing excel spreadsheet and copy that data into the spreadhseet - the reason i need to do this is that by first creating a report it *somehow* converts numbers...
    Posted to Access Coding/Macros (Forum) by microsoft on 08-25-2009
Page 1 of 2 (12 items) 1 2 Next >