Need Solution for printing form data

  • Thread starter Thread starter JString
  • Start date Start date
J

JString

Greetings all.

I'm currently building an access app that mimicks my client's old Lotus app.
They would rather have me prioritize recreation over making improvements so
that their employees will know their way around. Needless to say, this makes
my job much more difficult. As it is, I've created several different forms
(some are running in datasheet view) per table as this is how their old
system was set up.

As for right now the issue is that their old Lotus system allowed them to
print out each form as displayed on the screen. Unfortunately it doesn't
seem that the designers of Access were very concerned about the printability
of forms as opposed to reports. So, I need to find a solution to enable each
form to be printable without having to create a report for each one.

It would be nice if I could find a way to code a screen capture procedure
which would either insert an image into a blank report or a word doc, etc.
However, I'm guessing that this would require some API functions, and I'm not
very proficient in utilizing the windows shell procedures. Also, because
each of these forms are contained within a single master form as subforms,
the screen capture would have to somehow single out the subform from the rest
of the screen. Is this even possible and is there a better option?

Many thanks in advance.
 
If you know how many records print on a page, you can set the page number of
the selected record, or in datasheet view, you can simply select the
record(s) you want to print. You can also print just 1 record by reopening
the form to just the current record, and printing that record. Reports are
significantly better to print, and offer more printing options. You can
create a report very simply by right-clicking on the form's name in the
database window, and choosing: Save As Report, then giving it a name. Now
open the report and delete any buttons, etc. that you don't want to print.
 
One of the problems is that when a user attempts to print a form in form
view, the forms are sized in such a way that it takes 2 or more pages to
print one form. When one of the datasheet forms is printed, one record tends
to span across two pages. Is there a way to adjust their print settings
without having to resize the actual form?

I like your idea about creating a new report from each form. Do you know
there is a method that I can use in VBA to do this?
 
There probably is a way to code creating the reports, but I haven't ever
investigated it since I find that even after using the method that I
outlined, I have to go back and tweak each report. It seems to me that a
report is the perfect answer to having to print multiple pages. There is a
report wizard which will force all the controls to fit on 1 page (assuming
there aren't too many fields to fit on a page.

Reread my last post for an easy way to get a report started.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Back
Top