473,326 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

DoCmd.PrintOut .... Doesn't

Question about DoCmd.PrintOut in A97.

I have a form on which all the controls are unbound. There is a large
textbox that the user can type stuff in and a couple labels. I am trying
to code a Print button to simply print out the form.

Problem is, DoCmd.PrintOut only produces a blank page. (Actually once in
testing, it printed the form module's code, but not the form.)

In another app I am working on, PrintOut successfully prints the form
and data. The difference, or at least the obvious difference to me, is
that in the other app the form's controls are data-bound.

Does this seem like a limitation of the PrintOut method? I have not seen
any indication of this in the help file, but wondered if anyone else has
had the same experience.

Thanks for any suggestions.

I am posting another question separately about a potential work-around
using a report to take care of the printing.

This is an awesome group, BTW!
--
Smartin
Nov 13 '05 #1
2 3554
On Wed, 26 Oct 2005 18:19:35 -0400, Smartin <sm********@yahoo.com> wrote:
Question about DoCmd.PrintOut in A97.

I have a form on which all the controls are unbound. There is a large
textbox that the user can type stuff in and a couple labels. I am trying
to code a Print button to simply print out the form.

Problem is, DoCmd.PrintOut only produces a blank page. (Actually once in
testing, it printed the form module's code, but not the form.)

In another app I am working on, PrintOut successfully prints the form
and data. The difference, or at least the obvious difference to me, is
that in the other app the form's controls are data-bound.

Does this seem like a limitation of the PrintOut method? I have not seen
any indication of this in the help file, but wondered if anyone else has
had the same experience.

Thanks for any suggestions.

I am posting another question separately about a potential work-around
using a report to take care of the printing.

This is an awesome group, BTW!


Forms are for viewing, Reports are for printing.
Create a report which displays the same data as your form. Use your print button to print the report for the selected
record.

DoCmd.OpenReport "rptMyReport",,,"(MyIDField)=" & Me.MyIDField
Nov 13 '05 #2
Wayne Gillespie wrote:
On Wed, 26 Oct 2005 18:19:35 -0400, Smartin <sm********@yahoo.com> wrote:

Question about DoCmd.PrintOut in A97.

I have a form on which all the controls are unbound. There is a large
textbox that the user can type stuff in and a couple labels. I am trying
to code a Print button to simply print out the form.

Problem is, DoCmd.PrintOut only produces a blank page. (Actually once in
testing, it printed the form module's code, but not the form.)

In another app I am working on, PrintOut successfully prints the form
and data. The difference, or at least the obvious difference to me, is
that in the other app the form's controls are data-bound.

Does this seem like a limitation of the PrintOut method? I have not seen
any indication of this in the help file, but wondered if anyone else has
had the same experience.

Thanks for any suggestions.

I am posting another question separately about a potential work-around
using a report to take care of the printing.

This is an awesome group, BTW!

Forms are for viewing, Reports are for printing.
Create a report which displays the same data as your form. Use your print button to print the report for the selected
record.

DoCmd.OpenReport "rptMyReport",,,"(MyIDField)=" & Me.MyIDField


Thanks for that, Wayne.

In my question concerning forms (<ne********************@giganews.com>)
I am able to do that much, but I was hoping to do some formatting on the
fly.

I was puzzled about my ability to print one form but not the other.
--
Smartin
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jason | last post by:
I have an asp page that automatically populates a word document via vbscript. It works perfectly(it is for the intranet so I can make some assumptions). The only problem is when i use the...
0
by: ivan | last post by:
I have a command button that uses the following command to print out the current record on the screen: DoCmd.PrintOut acSelection I get the following error message when I try to enter the NEXT...
0
by: ivan | last post by:
Access97 While in ADD mode- I have a command button that has the following: DoCmd.Printout acSelection This command gives me an error message (after it prints), that there is not enough...
0
by: Owen Jenkins | last post by:
I use the DoCmd.Printout method to print reports using the client's default options This has worked fine for years with Access 97 and 2000/2, Win95-XP. However two clients have recently complained...
3
by: RC | last post by:
I am using docmd.printout to send Reports (formatted as labels) to a barcode label printer. I need to collate the labels so that I print lable 1 twice, then label 2 twice, then label 3 twice, etc....
1
by: Elhanan | last post by:
hi.. sorry for the cross posting, i'm simply not sure where this goes (i'm still genrating this from an asp page). i'm trying to printout normal text from IE using Generic Text Driver like...
6
by: EJO | last post by:
TIA, There is already a form (Access 2k) with the selected record and a button with this code behind it: DoCmd.PrintOut acSelection Except that Access does not print the acSelection, it...
1
by: Ryan | last post by:
Hello. I was hoping that someone may be able to assist with an issue that I am experiencing. I have created an Access DB which imports an Excel File with a particular layout and field naming. ...
1
by: =?Utf-8?B?S2ltIFM=?= | last post by:
I have a word document I only want to printout ( not save as file ) and I use Word printout method in backgrund but my XP operativ i so slow that a "dummy" dociment also get stored. which...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.