Search results

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.

I have multiple sub-reports contained on a single parent report. What is the best way to open the main report and all subreports so that they reflect certain criteria set on a form from which they are opened. I am having trouble trying to use the "FilterOn" and "Recordsource" properties. I can...

Would anyone know how to force the details section on a form to display 5 rows always. I have a form based on a query between a one-to-many table relationship. One parent record has up to 30 or more child records. I have been asked to ensure that 5 are displayed at one time. I have played with...

Hello, I have a textbox control on a form whose control source is a memo field in a table. This field is to act as log or history of the record it belongs to. What I need to do is date and time stamp the field every time a user adds a comment. This date and time should appear in the field...

I have two linked tables - the parent table contains Projects, the child table contains Purchase Orders. One project may have many POs. The report is a simple listing of all Projects, however I need to identify on the report if a given Project has at least one PO that meets a certain condition...

I have a form in which the footer contains a text which displays the sum of a number of fields in the detail section. I am having trouble passing this value to another form. Any ideas? Thanks