Form Printing

  • Thread starter Thread starter anewbornman
  • Start date Start date
A

anewbornman

I might be in the wrong location, but I believe that I am going to need a
macro for this and not a VBA. I have a form that is to long to fit into one
whole section of the form create section. So what I did was I figured out how
to create the tabs, and cut make the tabs each have a section of the form.
Then my partner helped me to figure out how to get a print button to print
the pages, but each one is printed to a whole new page, (tabbed page), so
what I am trying to figure out, is what would the macro look like in order to
print out all three tabbed pages, on one word document. I hope that I am
explaining this right. Thank you for taking the time to read this.
 
anewbornman,

Well, let's start with the basic question... Why are you using forms for
printing when that's what the reports are for?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I might be in the wrong location, but I believe that I am going to need a
macro for this and not a VBA. I have a form that is to long to fit into one
whole section of the form create section. So what I did was I figured out
how
to create the tabs, and cut make the tabs each have a section of the form.
Then my partner helped me to figure out how to get a print button to print
the pages, but each one is printed to a whole new page, (tabbed page), so
what I am trying to figure out, is what would the macro look like in order
to
print out all three tabbed pages, on one word document. I hope that I am
explaining this right. Thank you for taking the time to read this.
 
The reason that I am using a form is because there is a certain format that
the higher ups want, and I had to recreate the form in access. The
information has gotten to large to keep accurate in excel. When I was given
this project I was asked to make it where everyone could keep the information
in a better way, plus print out reports, and look for certain information, so
I went with access (this is too cool). Well then they informed me that the
form that went up to the highers had to look just like the form they have
always used, so I recreated the whole form. My print button exports the form
to word, and looks almost exactly like their form except the fact that it had
to be done in three sheets because my create form sheet is not large enough
to hold the whole form. Sorry about how long this is. Thanks for the help.
 
Oh... you didn't know, you could have made the report *look like* the form
and not had this issue. Moving on... you could try using
report/subreport/subreport and join all on the common field.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

The reason that I am using a form is because there is a certain format that
the higher ups want, and I had to recreate the form in access. The
information has gotten to large to keep accurate in excel. When I was given
this project I was asked to make it where everyone could keep the
information
in a better way, plus print out reports, and look for certain information,
so
I went with access (this is too cool). Well then they informed me that the
form that went up to the highers had to look just like the form they have
always used, so I recreated the whole form. My print button exports the form
to word, and looks almost exactly like their form except the fact that it
had
to be done in three sheets because my create form sheet is not large enough
to hold the whole form. Sorry about how long this is. Thanks for the help.
 
"Oh... you didn't know, you could have made the report *look like* the form
and not had this issue." Moving on... you could try using
report/subreport/subreport and join all on the common field.

What do you mean by that first statement? As for the subreport, will it keep
all logical information together? In other words will John Jones have all of
the common information stuck with him? I would guess so, but I am just making
sure.
 
anewbornman,

Yep, John Jones would have all his information stay with him and only him.
And you could have made it look like a form and then *squeezed* it on to one
page with no worries. And even if John Jones information went to two pages
or more it would have still stayed with him. You could also put a Page
Break between folks so they would not start on a page if someone did not
take a whole page.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Oh... you didn't know, you could have made the report *look like* the form
and not had this issue." Moving on... you could try using
report/subreport/subreport and join all on the common field.

What do you mean by that first statement? As for the subreport, will it keep
all logical information together? In other words will John Jones have all of
the common information stuck with him? I would guess so, but I am just
making
sure.
 
Is there anyway that I can send you a copy of this without information so
that way you can see what it is that I am trying to do with some notes and
see what your take on it is? If not I understand, if so that would be a big
help. Thanks for everything, and I am working on making the subreports, and
squeezing everything into one page. Thanks again and hope to hear from you
soon.
 
anewbornman,

You can send a copy but I can't promise I will look at it now... most
likely it will be tonight. To obtain my eMail address please go to my
website (www.regina-whipp.com) and use the button towards the bottom.
Please put something meaningful in the subject line so you don't end up in
the trash.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Is there anyway that I can send you a copy of this without information so
that way you can see what it is that I am trying to do with some notes and
see what your take on it is? If not I understand, if so that would be a big
help. Thanks for everything, and I am working on making the subreports, and
squeezing everything into one page. Thanks again and hope to hear from you
soon.
 
Back
Top