Search results

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

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

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

I am using Access 97. I have a conditional page break placed on a sub-report. The page break works fine if I just open the sub-report by itself. When I open the master report, the page break does not happen. Any ideas? Thanks

I am having trouble maintaining the correct report settings since I have shared my Access97 app with other users over a network. When another user opens a report it often reverts back to incorrect settings. Is there a way to set these properties in open events of reports or something like that?

I have created a number of reports in landscape mode and legal size paper (8 1/2 X 14). Since I have shared this database with a number of users, the reports usually open up in landscape mode but revert back to letter size paper. This requires users to do page setup almost every time they want...