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 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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. ...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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
|
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...
|
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...
| |