By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

print current form?

P: n/a
sea
I need to be able to print the current form because the form has an
embedded object of a .gif file, so report will not work -- does anyone
know the way to do this? I tried some code, not sure what it was now,
guess docmd.printout or something but that prints ALL the forms --
also the each page of the form does not always start at the next page
even if allowcontinuousforms is set to no. The preview button previews
all the forms as well, depending on the number of records in the
database! So to sum up what I need is code for the following:

1. print preview form for currently viewed record only
2. print form for currently viewed record
3. some way to force each form page to print and preview on a separate
sheet of paper.

Thank you very much -- any help will be greatly appreciated - am using
Access 2003.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Why not just filter the form to the current record based on its RecordID
(autonumber)

A better suggestion would be to copy the layout into a report and use on the
report on the OnOpen Event

docmd.filterOn = true
Me.Filter = [forms]![formname].Form.Filter

Then the report will print everything that you have selected on the form.
Just base the recordsource of the Report to be the same as the recordsource
for the Form

HTH
Paul
sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
I need to be able to print the current form because the form has an
embedded object of a .gif file, so report will not work -- does anyone
know the way to do this? I tried some code, not sure what it was now,
guess docmd.printout or something but that prints ALL the forms --
also the each page of the form does not always start at the next page
even if allowcontinuousforms is set to no. The preview button previews
all the forms as well, depending on the number of records in the
database! So to sum up what I need is code for the following:

1. print preview form for currently viewed record only
2. print form for currently viewed record
3. some way to force each form page to print and preview on a separate
sheet of paper.

Thank you very much -- any help will be greatly appreciated - am using
Access 2003.

Nov 13 '05 #2

P: n/a
Look at this....

http://files.bdmco.com/PrintScreen.mdb
"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
I need to be able to print the current form because the form has an
embedded object of a .gif file, so report will not work -- does anyone
know the way to do this? I tried some code, not sure what it was now,
guess docmd.printout or something but that prints ALL the forms --
also the each page of the form does not always start at the next page
even if allowcontinuousforms is set to no. The preview button previews
all the forms as well, depending on the number of records in the
database! So to sum up what I need is code for the following:

1. print preview form for currently viewed record only
2. print form for currently viewed record
3. some way to force each form page to print and preview on a separate
sheet of paper.

Thank you very much -- any help will be greatly appreciated - am using
Access 2003.

Nov 13 '05 #3

P: n/a
Ahhh,

Now I understand. Look into a way of using the OnOpen Event to set the size
of the form for printing purposes.
Maybe the MoveSize command or some other like it.

HTH
Paul

"miTch" <mi******@nospam.topsideinc.com> wrote in message
news:1099668976.kTNSlxVkDbmjwkZ9wpXLgw@teranews...
Look at this....

http://files.bdmco.com/PrintScreen.mdb
"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
I need to be able to print the current form because the form has an
embedded object of a .gif file, so report will not work -- does anyone
know the way to do this? I tried some code, not sure what it was now,
guess docmd.printout or something but that prints ALL the forms --
also the each page of the form does not always start at the next page
even if allowcontinuousforms is set to no. The preview button previews
all the forms as well, depending on the number of records in the
database! So to sum up what I need is code for the following:

1. print preview form for currently viewed record only
2. print form for currently viewed record
3. some way to force each form page to print and preview on a separate
sheet of paper.

Thank you very much -- any help will be greatly appreciated - am using
Access 2003.


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.