Recent content by Hunter

Everyone relax...it turned out to be the wrong driver for the printer

Hello all, I export reports from MS Access 97 to adobe format. When printed on a color printer, the spacing between words within each field is gone - all words jumble together in one big mess. The report looks fine on the screen and prints fine on black and white printers. It also looks fine on...

Many thanks people! The Excel solution works great.

Try this text in a text box in the Report Footer section: ="Total Number of Initiatives is: " & Count(*)

Thanks for the response Carol but I do not see a Vertical property relating to labels. I am using Access 97, perhaps this is in Access 2000?

Hi People... I am just owndering if there is a way to rotate labels (used in a report heading section) so they appear vertically. I know it is dead simple in Word and Excel but cannot find a way to do it in Access. Any ideas? Thanks

Is there a way to print mutliple reports (all the same report but based on different ID#'s) with one push of a button? There are generally 20 reports or so that an admin must print and export to file. We are trying to save time by automating this in one operation. Is it possible to set up some...

I am wondering if there is a way to search the contents of a list box just as you'd search any field? Ideally, I'd like to use the standard MS Office "Find" window (<CRTL>-F). Thanks in advance...

Thanks! That was too easy!

I want to add a column to a report. The column is to contain a simple numbering of the records as they appear on the report (1,2,3,...). Is there a way to do this using a calculated field in the query the report is based on?

I have a number of sub-reports contained on a parent report. Each sub-report is divided by a page break. The problem is that sometimes one or more of these sub-reports contain no data, but a blank page then appears due to the page break. Is there a way to make the page breaks and sub-report...

I have done this using code in the CLick Event of the button that opens the selected report. Private Sub cmdReports_Click() On Error GoTo Err_cmdReports_Click Dim rptSelected As String Dim stDocName As String rptSelected = Me.ReportComboBox.Value Select Case rptSelected...

There are only two criteria that change. One has 3 possible values and the other has 2. This makes 6 possible variations when combining the two. There are 5 sub-reports on the main report. The main report acts only as a container and has no links to the sub-reports. I am trying not to do the...

Yes that would work, but what I am trying to get away from is creating a large number of reports or queries. Ideally, I would like to alter the "Recordsource" property based on the criteria selected on the form. I am having trouble getting this to work by embedding SQL statements in VBA code.

With the report in design view, select the "Sorting and Grouping" button from the toolbar. Here you can specify any sorting and grouping you desire. Hope this helps.