Search results

Well, I got it to work, but not by conventional means. I ended up adding a couple text boxes to the Group Footer, and then using the code below (along with a PageCounter increment in the page header): Private Sub GroupFooter2_Format(Cancel As Integer, FormatCount As Integer) 'If the last...

Slightly more progress... Private Sub GroupFooter2_Format(Cancel As Integer, FormatCount As Integer) If (PageCounter Mod 2 <> 1) Then 'Insert Blank Page Reports![Appendix_4a].Section(acFooter).ForceNewPage = 1 MsgBox PageCounter, , "This Should Only Appear On Reports...

This is where I'm at with the code. It seems to work (ie: the message box pops up when it should), however, the code to print the blank page doesn't work - the code I'm using is from the Access 2000 Help, however, I'm not sure what the "Section(acDetail)" refers to. Any ideas? I'm trying to...

Dokuin, Did you find a solution to this problem? - Ryan

Val, I just came across this info... my question is - will each computer that uses this program require that that DLL be installed? Thanks!! - Ryan

David, IsOdd is EXACTLY what I need... except that it seems to be a no-go! Access 2000 won't accept it as a valid function. Any other suggestions?? - Ryan

David, The report doesnt use page numbers. The categories of the report each have a 'tab' along the vertical edge with the category title on it, so that you can quickly thumb through the report to find the category you need. There is no purpose to numbering the pages in this report - it's...

Ok, this is what I've come up with. In the page header, I'm going to add code that does this: round((detail_count / 4)+0.25) Thus the result from this will be the page number. Now, I need to know if here is a VB function to determine if the number is even or odd? On odd-numbered pages, I...

Chris, I did have each section as a stand-alone report, however, that requires that I have about 180 individual reports (I'm sure you see the inconvenience here ). I may have a solution using grouping, however. Thanks for your response! - Ryan

I am creating a report that is based on various different categories of information (example: Airports, Fire Departments, Police Stations are all "categories"). For each category, there are a varying number of records. For example, Airports may have 5 records, Fire Departments may have 13...

Hi there, Is it possible to span across the page header into the 'detail' section of a Report so that I can display a tab along the edge of each page of my Report that details the page title? This would make it much easier/faster to search through a large printed document (much like a...

Does anyone know if there is code to print to a file? I cant dig anything up in the help or on Microsoft's website. Any help would be greatly appreciated. - Ryan

Hi all, I'd like to create a very basic "installer" for my Access Database. Basically, all I want to do is use a command button with a couple of commands to copy certain files from the CD to the user's hard drive. Any pointers on doing this (I lack VB coding experience)? Thanks! - Ryan

Hey all, I want to do a: DoCmd.OpenReport "Report_Name", acNormal but rather than sending the document to the default printer, I'd like for it to print to file. Is there a command for this? Or something similar that will work? The reason I am doing this is because I have a Table of...

Hi all, Creating a form that will print various reports and word documents. Is it possible to use a DoCmd (or similar) command to print a Word Document without loading it? Also, any pointers for creating large (50+ page) reports without using table data? I'd like to convert these word...

Hi all, I'm using a subform to display a map of an entire area. I am trying to set it up so that when you click on a certain button, the subform will update and show a zoomed-in map (ie: the map originally shows all of Florida, but when you click "Miami", the subform updates to show a...

Hi all, I'd like to create an Access form with a map on it with clickable (linked) regions. Any pointers on how to go about doing this? Thanks, - Ryan

Got it working, *finally*. Thanks again! - Ryan

Pat, Thanks so much! Have you ever used this particular example before? I downloaded the sample, and added the code to my project. When I run the report, it just appears for a second and then goes into Design mode rather than Preview mode. It isn't dumping any of the categories into the TOC...

Hi all, I have created a report that extracts and groups data from a single table. This report groups the different categories (its an Emergency Plan, so there are categories such as "Police Departments", "Fire Departments", etc). My question is - I want to create another report that will...