|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2007, 02:06 AM
posted to microsoft.public.access.reports
|
|||
|
|||
"Access 2003 Data Available in Preview but not in OutputTo"
I created a Access 2003 Report and the data appears in the Preview but, in
code when I try to OutputTo I only see the Text. 
|
|
#2
May 12th, 2007, 08:06 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
"Access 2003 Data Available in Preview but not in OutputTo"
You have to be more specific. What is the line of code you are using
- Docmd.openreport acpreview Or is it that you only see the text and not the formatting you applied? Maurice "helprdc" wrote: I created a Access 2003 Report and the data appears in the Preview but, in code when I try to OutputTo I only see the Text.
|
|
#3
May 13th, 2007, 12:43 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
"Access 2003 Data Available in Preview but not in OutputTo"
DoCmd.OutputTo "rpt_DirectMailPricing", acOutputReport
"Maurice" wrote: You have to be more specific. What is the line of code you are using - Docmd.openreport acpreview Or is it that you only see the text and not the formatting you applied? Maurice "helprdc" wrote: I created a Access 2003 Report and the data appears in the Preview but, in code when I try to OutputTo I only see the Text.
|
|
#4
May 14th, 2007, 03:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
"Access 2003 Data Available in Preview but not in OutputTo"
Apologies for the late response.
My guess is that you've forgotten a few parameters needed to get output this way. You do have to tell what the recordsource is for the report te be created. This might give you a direction: DoCmd.OutputTo acOutputReport, "your sourcename" there are a few other parameters you can set for this output. Maurice "helprdc" wrote: DoCmd.OutputTo "rpt_DirectMailPricing", acOutputReport "Maurice" wrote: You have to be more specific. What is the line of code you are using - Docmd.openreport acpreview Or is it that you only see the text and not the formatting you applied? Maurice "helprdc" wrote: I created a Access 2003 Report and the data appears in the Preview but, in code when I try to OutputTo I only see the Text.
|
|
#5
May 14th, 2007, 04:30 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
"Access 2003 Data Available in Preview but not in OutputTo"
I created the report by tying lists to Select Clauses. The table has 84
records but, only 21 records are in each column. I am trying to display the 21 records side by side therefore one Recordsource for the whole report doesn't seem to work. I did try using a Recordsource and ended up with 84 pages of text and data. Thanks for you help. "Maurice" wrote: Apologies for the late response. My guess is that you've forgotten a few parameters needed to get output this way. You do have to tell what the recordsource is for the report te be created. This might give you a direction: DoCmd.OutputTo acOutputReport, "your sourcename" there are a few other parameters you can set for this output. Maurice "helprdc" wrote: DoCmd.OutputTo "rpt_DirectMailPricing", acOutputReport "Maurice" wrote: You have to be more specific. What is the line of code you are using - Docmd.openreport acpreview Or is it that you only see the text and not the formatting you applied? Maurice "helprdc" wrote: I created a Access 2003 Report and the data appears in the Preview but, in code when I try to OutputTo I only see the Text.
|
|
#6
May 14th, 2007, 06:17 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
"Access 2003 Data Available in Preview but not in OutputTo"
Hmm, sorry lost me on that one. Could you specify how the source is created
maybe I can be of som assistance in figuring out a way to do this. Have you tried 'snaking' your report? You could post a 'dummy' select statement if the data is restricted. Maurice "helprdc" wrote: I created the report by tying lists to Select Clauses. The table has 84 records but, only 21 records are in each column. I am trying to display the 21 records side by side therefore one Recordsource for the whole report doesn't seem to work. I did try using a Recordsource and ended up with 84 pages of text and data. Thanks for you help. "Maurice" wrote: Apologies for the late response. My guess is that you've forgotten a few parameters needed to get output this way. You do have to tell what the recordsource is for the report te be created. This might give you a direction: DoCmd.OutputTo acOutputReport, "your sourcename" there are a few other parameters you can set for this output. Maurice "helprdc" wrote: DoCmd.OutputTo "rpt_DirectMailPricing", acOutputReport "Maurice" wrote: You have to be more specific. What is the line of code you are using - Docmd.openreport acpreview Or is it that you only see the text and not the formatting you applied? Maurice "helprdc" wrote: I created a Access 2003 Report and the data appears in the Preview but, in code when I try to OutputTo I only see the Text.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
