 | |
access2007 printing a screen image
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
access2007 printing a screen image -
10-24-2011
, 11:04 AM
#2
| |||
| |||
|
|
I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have form tab control 1 (2 tabs, tab2 is control for sub form1 sub form 1 tab control 2 (2 tabs, tab2 is control for sub form 2 sub form 2 I open the form, click the appropriate tabs and display the data in sub form 2 then I do file->print (or use the print icon) to print a copy of the subform's data and I get this error messagebox the record source "SELECT ...." specified on this form or report does not exist the name of the recordsource may be misspelled.... the contents of subform 2 changes to non alpha or #error#, which is printed if I immediately do a second file-print, the contents of the subform 2 reverts to what it should be, no error is displayed, and the correct output is printed and if I open a query and paste in "SELECT ..." per the messagebox it returns 3 rows I don't get the error if I do a file->print after selecting tab control 2 - tab 1 (which does not have the subform) the problem appears to be printing a subform -> subform's data, has anyone seen this ? if there a event that fires when I do file->print that will allow me to check the recordsource ? I tried on the form's onError event is there a vba statement that will do the equivalent of file->print so that I can step through the process ? |
printing and you are careful with filtering they tend to look like screen
shots. Why don't you use a report and send it the records you selected?
#3
| |||
| |||
|
|
"Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:f10c3fb2-727c-48b5-a77b-0a54885c5b8c (AT) g27g2000pro (DOT) googlegroups.com... I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have *form * *tab control 1 (2 tabs, tab2 is control for sub form1 * * *sub form 1 * * * * tab control 2 (2 tabs, tab2 is control for sub form 2 * * * * * sub form 2 I open the form, click the appropriate tabs and display the data in sub form 2 then I do file->print (or use the print icon) to print a copy of the subform's data and I get this error messagebox *the record source "SELECT ...." specified on this form or report does not exist *the name of the recordsource may be misspelled.... the contents of subform 2 changes to non alpha or #error#, which is printed if I immediately do a second file-print, the contents of the subform 2 reverts to what it should be, no error is displayed, and the correct output is printed and if I open a query and paste in "SELECT ..." per the messagebox it returns 3 rows I don't get the error if I do a file->print after selecting tab control 2 - tab 1 (which does not have the subform) the problem appears to be printing a subform -> subform's data, has anyone seen this ? if there a event that fires when I do file->print that will allow me to check the recordsource ? I tried on the form's onError event is there a vba statement that will do the equivalent of file->print so that I can step through the process ? IMO: Printing Access forms is the problem; unless they are formatted for printing and you are careful with filtering they tend to look like screen shots. Why don't you use a report and send it the records you selected?- Hide quoted text - - Show quoted text - |
content, and the second file->print provided it, and it matched the
form's content
#4
| |||
| |||
|
|
On Oct 24, 10:23 am, "ron paii" <n... (AT) nospam (DOT) com> wrote: "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:f10c3fb2-727c-48b5-a77b-0a54885c5b8c (AT) g27g2000pro (DOT) googlegroups.com... I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have form tab control 1 (2 tabs, tab2 is control for sub form1 sub form 1 tab control 2 (2 tabs, tab2 is control for sub form 2 sub form 2 I open the form, click the appropriate tabs and display the data in sub form 2 then I do file->print (or use the print icon) to print a copy of the subform's data and I get this error messagebox the record source "SELECT ...." specified on this form or report does not exist the name of the recordsource may be misspelled.... the contents of subform 2 changes to non alpha or #error#, which is printed if I immediately do a second file-print, the contents of the subform 2 reverts to what it should be, no error is displayed, and the correct output is printed and if I open a query and paste in "SELECT ..." per the messagebox it returns 3 rows I don't get the error if I do a file->print after selecting tab control 2 - tab 1 (which does not have the subform) the problem appears to be printing a subform -> subform's data, has anyone seen this ? if there a event that fires when I do file->print that will allow me to check the recordsource ? I tried on the form's onError event is there a vba statement that will do the equivalent of file->print so that I can step through the process ? IMO: Printing Access forms is the problem; unless they are formatted for printing and you are careful with filtering they tend to look like screen shots. Why don't you use a report and send it the records you selected?- Hide quoted text - - Show quoted text - because the user just wanted a one-time hardcopy of the form's content, and the second file->print provided it, and it matched the form's content |
#5
| |||
| |||
|
|
"Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:55525138-21d9-47c9-9020-9a82e0f0cabc (AT) p14g2000pra (DOT) googlegroups.com... On Oct 24, 10:23 am, "ron paii" <n... (AT) nospam (DOT) com> wrote: "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:f10c3fb2-727c-48b5-a77b-0a54885c5b8c (AT) g27g2000pro (DOT) googlegroups.com.... I have form with tabctl control, containing a subform the subform has a recordsource and displays data and it also has a subform with a recordsource which displays data so I have *form * *tab control 1 (2 tabs, tab2 is control for sub form1 * * *sub form 1 * * * * tab control 2 (2 tabs, tab2 is control for sub form 2 * * * * * sub form 2 I open the form, click the appropriate tabs and display the data in sub form 2 then I do file->print (or use the print icon) to print a copy of the subform's data and I get this error messagebox *the record source "SELECT ...." specified on this form or report does not exist *the name of the recordsource may be misspelled.... the contents of subform 2 changes to non alpha or #error#, which is printed if I immediately do a second file-print, the contents of the subform2 reverts to what it should be, no error is displayed, and the correct output is printed and if I open a query and paste in "SELECT ..." per the messagebox it returns 3 rows I don't get the error if I do a file->print after selecting tab control 2 - tab 1 (which does not have the subform) the problem appears to be printing a subform -> subform's data, has anyone seen this ? if there a event that fires when I do file->print that will allow me to check the recordsource ? I tried on the form's onError event is there a vba statement that will do the equivalent of file->print so that I can step through the process ? IMO: Printing Access forms is the problem; unless they are formatted for printing and you are careful with filtering they tend to look like screen shots. Why don't you use a report and send it the records you selected?- Hide quoted text - - Show quoted text - because the user just wanted a one-time hardcopy of the form's content, and the second file->print provided it, and it matched the form's content But what you want to provide will not work consistently.- Hide quoted text - - Show quoted text - |
are you saying that you can't file->print the contents of a subform
within a subform ?
#6
| |||
| |||
|
|
On Oct 24, 11:39 am, "ron paii" <n... (AT) nospam (DOT) com> wrote: IMO: Printing Access forms is the problem; unless they are formatted for printing and you are careful with filtering they tend to look like screen shots. Why don't you use a report and send it the records you selected?- Hide quoted text - - Show quoted text - because the user just wanted a one-time hardcopy of the form's content, and the second file->print provided it, and it matched the form's content But what you want to provide will not work consistently I don't understand are you saying that you can't file->print the contents of a subform within a subform ? |
subform in order to reliably print it.
Forms are for interfacing with users. Reports are for viewing and printing
data.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.