Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #14079 > unrolled thread
| Started by | rama <chanattu@gmail.com> |
|---|---|
| First post | 2020-05-06 12:54 -0700 |
| Last post | 2020-05-08 13:26 -0400 |
| Articles | 9 — 4 participants |
Back to article view | Back to comp.databases.ms-access
MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-06 12:54 -0700
Re: MS Access Report - Print Preview Issue Patrick Finucane <patrickfinucanetx@gmail.com> - 2020-05-06 21:34 -0700
Re: MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-07 04:57 -0700
Re: MS Access Report - Print Preview Issue Patrick Finucane <patrickfinucanetx@gmail.com> - 2020-05-07 08:39 -0700
Re: MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-08 00:29 -0700
Re: MS Access Report - Print Preview Issue internet.shopping@foobox.com - 2020-05-08 04:21 -0700
Re: MS Access Report - Print Preview Issue "Phil Hunt" <NoOne@Nowhere.com> - 2020-05-08 13:25 -0400
Re: MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-11 12:16 -0700
Re: MS Access Report - Print Preview Issue "Phil Hunt" <NoOne@Nowhere.com> - 2020-05-08 13:26 -0400
| From | rama <chanattu@gmail.com> |
|---|---|
| Date | 2020-05-06 12:54 -0700 |
| Subject | MS Access Report - Print Preview Issue |
| Message-ID | <e4a38a9e-e6d8-48e8-a070-045feae5819f@googlegroups.com> |
I have developed an MS Access 2016 database report, which has got some 150 text fields and two sub reports. This report is opening in report view and displaying data properly except date fields. However, it is not displaying anything in print preview. Initially the report was working fine, later it stopped. The select query, which pulls data form the table is okay and displaying data without any problem. I am looking for some kind help urgently as the project to be submitted soon. Thanks in advance. Rama
[toc] | [next] | [standalone]
| From | Patrick Finucane <patrickfinucanetx@gmail.com> |
|---|---|
| Date | 2020-05-06 21:34 -0700 |
| Message-ID | <4481bad6-1612-4528-b2a4-e30f6ca728f5@googlegroups.com> |
| In reply to | #14079 |
On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > I have developed an MS Access 2016 database report, which has got some 150 text fields and two sub reports. This report is opening in report view and displaying data properly except date fields. However, it is not displaying anything in print preview. Initially the report was working fine, later it stopped. The select query, which pulls data form the table is okay and displaying data without any problem. I am looking for some kind help urgently as the project to be submitted soon. > Thanks in advance. > Rama Throwing mud at the wall, hoping something sticks. Are all date fields blank or just some in your report? In your date field property sheet for Format see if mm/dd/yyyy makes any difference. Maybe try opening the the query as a recordset. Then ensure the date field is a date. Let's say your field is called startdt, then do a msgbox isdate(r.startdt) 'r being the recordset variable. and verify the field really is a date field.
[toc] | [prev] | [next] | [standalone]
| From | rama <chanattu@gmail.com> |
|---|---|
| Date | 2020-05-07 04:57 -0700 |
| Message-ID | <c8cb4974-7890-44c5-b528-de7594491871@googlegroups.com> |
| In reply to | #14080 |
On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > I have developed an MS Access 2016 database report, which has got some 150 text fields and two sub reports. This report is opening in report view and displaying data properly except date fields. However, it is not displaying anything in print preview. Initially the report was working fine, later it stopped. The select query, which pulls data form the table is okay and displaying data without any problem. I am looking for some kind help urgently as the project to be submitted soon. > > Thanks in advance. > > Rama > > Throwing mud at the wall, hoping something sticks. > > Are all date fields blank or just some in your report? > > In your date field property sheet for Format see if mm/dd/yyyy makes any difference. > > Maybe try opening the the query as a recordset. Then ensure the date field is a date. Let's say your field is called startdt, then do a > msgbox isdate(r.startdt) 'r being the recordset variable. > and verify the field really is a date field. Apology for making misunderstanding. Mentioned report is setup to print in A3 size paper and default view of the report is Print Preview. When I open the report, it does not show anything in the page, even the labels for the text boxes, just blank page. Also, it is worth to mention that the report has more pages, although it is setup for one page. I have tried to save this blank preview as .pdf file, but .pdf output file is corrupted. Due to the above-mentioned scenario, I have tried to open the report in Report view to see what happens. For me I do not need to open it in report view. I am only interested in Print Preview. Thanks for the reply Rama
[toc] | [prev] | [next] | [standalone]
| From | Patrick Finucane <patrickfinucanetx@gmail.com> |
|---|---|
| Date | 2020-05-07 08:39 -0700 |
| Message-ID | <047f0759-dccd-4313-9c64-f6a1e90bc764@googlegroups.com> |
| In reply to | #14081 |
On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote: > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > > I have developed an MS Access 2016 database report, which has got some 150 text fields and two sub reports. This report is opening in report view and displaying data properly except date fields. However, it is not displaying anything in print preview. Initially the report was working fine, later it stopped. The select query, which pulls data form the table is okay and displaying data without any problem. I am looking for some kind help urgently as the project to be submitted soon. > > > Thanks in advance. > > > Rama > > > > Throwing mud at the wall, hoping something sticks. > > > > Are all date fields blank or just some in your report? > > > > In your date field property sheet for Format see if mm/dd/yyyy makes any difference. > > > > Maybe try opening the the query as a recordset. Then ensure the date field is a date. Let's say your field is called startdt, then do a > > msgbox isdate(r.startdt) 'r being the recordset variable. > > and verify the field really is a date field. > > Apology for making misunderstanding. > > Mentioned report is setup to print in A3 size paper and default view of the report is Print Preview. When I open the report, it does not show anything in the page, even the labels for the text boxes, just blank page. Also, it is worth to mention that the report has more pages, although it is setup for one page. I have tried to save this blank preview as .pdf file, but .pdf output file is corrupted. > > Due to the above-mentioned scenario, I have tried to open the report in Report view to see what happens. For me I do not need to open it in report view. I am only interested in Print Preview. > > Thanks for the reply > Rama Still tossing mud at the wall. First, open your report in design mode. Select the report and subreports and shrink the width by an inch on the right. I have a funny feeling your report is too wide for the paper size and is screwing up. Then run. Does that improve the report? Next, create a new report with the query as the recordsource. Add only a few fields to a report, mostly date fields. Run the report. Is it OK? Next, if all else fails, recreate the report. Stop/start/run the report as you recreate. See if you get better results.
[toc] | [prev] | [next] | [standalone]
| From | rama <chanattu@gmail.com> |
|---|---|
| Date | 2020-05-08 00:29 -0700 |
| Message-ID | <a402f852-49f7-445b-a006-215be0bbeeef@googlegroups.com> |
| In reply to | #14082 |
On Thursday, May 7, 2020 at 6:39:08 PM UTC+3, Patrick Finucane wrote: > On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote: > > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > > > I have developed an MS Access 2016 database report, which has got some 150 text fields and two sub reports. This report is opening in report view and displaying data properly except date fields. However, it is not displaying anything in print preview. Initially the report was working fine, later it stopped. The select query, which pulls data form the table is okay and displaying data without any problem. I am looking for some kind help urgently as the project to be submitted soon. > > > > Thanks in advance. > > > > Rama > > > > > > Throwing mud at the wall, hoping something sticks. > > > > > > Are all date fields blank or just some in your report? > > > > > > In your date field property sheet for Format see if mm/dd/yyyy makes any difference. > > > > > > Maybe try opening the the query as a recordset. Then ensure the date field is a date. Let's say your field is called startdt, then do a > > > msgbox isdate(r.startdt) 'r being the recordset variable. > > > and verify the field really is a date field. > > > > Apology for making misunderstanding. > > > > Mentioned report is setup to print in A3 size paper and default view of the report is Print Preview. When I open the report, it does not show anything in the page, even the labels for the text boxes, just blank page. Also, it is worth to mention that the report has more pages, although it is setup for one page. I have tried to save this blank preview as .pdf file, but .pdf output file is corrupted. > > > > Due to the above-mentioned scenario, I have tried to open the report in Report view to see what happens. For me I do not need to open it in report view. I am only interested in Print Preview. > > > > Thanks for the reply > > Rama > > Still tossing mud at the wall. > > First, open your report in design mode. Select the report and subreports and shrink the width by an inch on the right. I have a funny feeling your report is too wide for the paper size and is screwing up. Then run. Does that improve the report? > > Next, create a new report with the query as the recordsource. Add only a few fields to a report, mostly date fields. Run the report. Is it OK? > > Next, if all else fails, recreate the report. Stop/start/run the report as you recreate. See if you get better results. Thank you so much. I have copied the same database in another desktop and the report is opening in Print Preview without any problem. Later I tried the same in another eight desktops, but found the above-mentioned trouble in two desktops. Remaining six desktops it is working fine. I have no idea why the report is behaving in this way as in all desktops MS Access-2016 is installed. Any suggestion, advice highly appreciated. Rama
[toc] | [prev] | [next] | [standalone]
| From | internet.shopping@foobox.com |
|---|---|
| Date | 2020-05-08 04:21 -0700 |
| Message-ID | <361e9b4f-e08c-45cd-be1b-d00346996099@googlegroups.com> |
| In reply to | #14083 |
Do you have the relevant printer driver installed on the machines where the problem arises? Jim On Friday, 8 May 2020 08:29:49 UTC+1, rama wrote: > On Thursday, May 7, 2020 at 6:39:08 PM UTC+3, Patrick Finucane wrote: > > On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote: > > > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > > > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > > > > I have developed an MS Access 2016 database report, which has got some 150 text fields and two sub reports. This report is opening in report view and displaying data properly except date fields. However, it is not displaying anything in print preview. Initially the report was working fine, later it stopped. The select query, which pulls data form the table is okay and displaying data without any problem. I am looking for some kind help urgently as the project to be submitted soon. > > > > > Thanks in advance. > > > > > Rama > > > > > > > > Throwing mud at the wall, hoping something sticks. > > > > > > > > Are all date fields blank or just some in your report? > > > > > > > > In your date field property sheet for Format see if mm/dd/yyyy makes any difference. > > > > > > > > Maybe try opening the the query as a recordset. Then ensure the date field is a date. Let's say your field is called startdt, then do a > > > > msgbox isdate(r.startdt) 'r being the recordset variable. > > > > and verify the field really is a date field. > > > > > > Apology for making misunderstanding. > > > > > > Mentioned report is setup to print in A3 size paper and default view of the report is Print Preview. When I open the report, it does not show anything in the page, even the labels for the text boxes, just blank page. Also, it is worth to mention that the report has more pages, although it is setup for one page. I have tried to save this blank preview as .pdf file, but .pdf output file is corrupted. > > > > > > Due to the above-mentioned scenario, I have tried to open the report in Report view to see what happens. For me I do not need to open it in report view. I am only interested in Print Preview. > > > > > > Thanks for the reply > > > Rama > > > > Still tossing mud at the wall. > > > > First, open your report in design mode. Select the report and subreports and shrink the width by an inch on the right. I have a funny feeling your report is too wide for the paper size and is screwing up. Then run. Does that improve the report? > > > > Next, create a new report with the query as the recordsource. Add only a few fields to a report, mostly date fields. Run the report. Is it OK? > > > > Next, if all else fails, recreate the report. Stop/start/run the report as you recreate. See if you get better results. > > Thank you so much. > I have copied the same database in another desktop and the report is opening in Print Preview without any problem. Later I tried the same in another eight desktops, but found the above-mentioned trouble in two desktops. Remaining six desktops it is working fine. I have no idea why the report is behaving in this way as in all desktops MS Access-2016 is installed. > > Any suggestion, advice highly appreciated. > Rama
[toc] | [prev] | [next] | [standalone]
| From | "Phil Hunt" <NoOne@Nowhere.com> |
|---|---|
| Date | 2020-05-08 13:25 -0400 |
| Message-ID | <r944o4$e74$1@gioia.aioe.org> |
| In reply to | #14084 |
It could be that every computer has a different 'default' printer. <internet.shopping@foobox.com> wrote in message news:361e9b4f-e08c-45cd-be1b-d00346996099@googlegroups.com... Do you have the relevant printer driver installed on the machines where the problem arises? Jim On Friday, 8 May 2020 08:29:49 UTC+1, rama wrote: > On Thursday, May 7, 2020 at 6:39:08 PM UTC+3, Patrick Finucane wrote: > > On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote: > > > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > > > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > > > > I have developed an MS Access 2016 database report, which has got > > > > > some 150 text fields and two sub reports. This report is opening > > > > > in report view and displaying data properly except date fields. > > > > > However, it is not displaying anything in print preview. Initially > > > > > the report was working fine, later it stopped. The select query, > > > > > which pulls data form the table is okay and displaying data > > > > > without any problem. I am looking for some kind help urgently as > > > > > the project to be submitted soon. > > > > > Thanks in advance. > > > > > Rama > > > > > > > > Throwing mud at the wall, hoping something sticks. > > > > > > > > Are all date fields blank or just some in your report? > > > > > > > > In your date field property sheet for Format see if mm/dd/yyyy makes > > > > any difference. > > > > > > > > Maybe try opening the the query as a recordset. Then ensure the > > > > date field is a date. Let's say your field is called startdt, then > > > > do a > > > > msgbox isdate(r.startdt) 'r being the recordset variable. > > > > and verify the field really is a date field. > > > > > > Apology for making misunderstanding. > > > > > > Mentioned report is setup to print in A3 size paper and default view > > > of the report is Print Preview. When I open the report, it does not > > > show anything in the page, even the labels for the text boxes, just > > > blank page. Also, it is worth to mention that the report has more > > > pages, although it is setup for one page. I have tried to save this > > > blank preview as .pdf file, but .pdf output file is corrupted. > > > > > > Due to the above-mentioned scenario, I have tried to open the report > > > in Report view to see what happens. For me I do not need to open it in > > > report view. I am only interested in Print Preview. > > > > > > Thanks for the reply > > > Rama > > > > Still tossing mud at the wall. > > > > First, open your report in design mode. Select the report and > > subreports and shrink the width by an inch on the right. I have a funny > > feeling your report is too wide for the paper size and is screwing up. > > Then run. Does that improve the report? > > > > Next, create a new report with the query as the recordsource. Add only > > a few fields to a report, mostly date fields. Run the report. Is it > > OK? > > > > Next, if all else fails, recreate the report. Stop/start/run the report > > as you recreate. See if you get better results. > > Thank you so much. > I have copied the same database in another desktop and the report is > opening in Print Preview without any problem. Later I tried the same in > another eight desktops, but found the above-mentioned trouble in two > desktops. Remaining six desktops it is working fine. I have no idea why > the report is behaving in this way as in all desktops MS Access-2016 is > installed. > > Any suggestion, advice highly appreciated. > Rama
[toc] | [prev] | [next] | [standalone]
| From | rama <chanattu@gmail.com> |
|---|---|
| Date | 2020-05-11 12:16 -0700 |
| Message-ID | <eb830f8c-90f0-4a7b-9eee-5204696ae9bf@googlegroups.com> |
| In reply to | #14085 |
On Friday, May 8, 2020 at 8:26:36 PM UTC+3, Phil Hunt wrote: > It could be that every computer has a different 'default' printer. > > > <internet.shopping@foobox.com> wrote in message > news:361e9b4f-e08c-45cd-be1b-d00346996099@googlegroups.com... > Do you have the relevant printer driver installed on the machines where the > problem arises? > > Jim > > On Friday, 8 May 2020 08:29:49 UTC+1, rama wrote: > > On Thursday, May 7, 2020 at 6:39:08 PM UTC+3, Patrick Finucane wrote: > > > On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote: > > > > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > > > > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > > > > > I have developed an MS Access 2016 database report, which has got > > > > > > some 150 text fields and two sub reports. This report is opening > > > > > > in report view and displaying data properly except date fields. > > > > > > However, it is not displaying anything in print preview. Initially > > > > > > the report was working fine, later it stopped. The select query, > > > > > > which pulls data form the table is okay and displaying data > > > > > > without any problem. I am looking for some kind help urgently as > > > > > > the project to be submitted soon. > > > > > > Thanks in advance. > > > > > > Rama > > > > > > > > > > Throwing mud at the wall, hoping something sticks. > > > > > > > > > > Are all date fields blank or just some in your report? > > > > > > > > > > In your date field property sheet for Format see if mm/dd/yyyy makes > > > > > any difference. > > > > > > > > > > Maybe try opening the the query as a recordset. Then ensure the > > > > > date field is a date. Let's say your field is called startdt, then > > > > > do a > > > > > msgbox isdate(r.startdt) 'r being the recordset variable. > > > > > and verify the field really is a date field. > > > > > > > > Apology for making misunderstanding. > > > > > > > > Mentioned report is setup to print in A3 size paper and default view > > > > of the report is Print Preview. When I open the report, it does not > > > > show anything in the page, even the labels for the text boxes, just > > > > blank page. Also, it is worth to mention that the report has more > > > > pages, although it is setup for one page. I have tried to save this > > > > blank preview as .pdf file, but .pdf output file is corrupted. > > > > > > > > Due to the above-mentioned scenario, I have tried to open the report > > > > in Report view to see what happens. For me I do not need to open it in > > > > report view. I am only interested in Print Preview. > > > > > > > > Thanks for the reply > > > > Rama > > > > > > Still tossing mud at the wall. > > > > > > First, open your report in design mode. Select the report and > > > subreports and shrink the width by an inch on the right. I have a funny > > > feeling your report is too wide for the paper size and is screwing up. > > > Then run. Does that improve the report? > > > > > > Next, create a new report with the query as the recordsource. Add only > > > a few fields to a report, mostly date fields. Run the report. Is it > > > OK? > > > > > > Next, if all else fails, recreate the report. Stop/start/run the report > > > as you recreate. See if you get better results. > > > > Thank you so much. > > I have copied the same database in another desktop and the report is > > opening in Print Preview without any problem. Later I tried the same in > > another eight desktops, but found the above-mentioned trouble in two > > desktops. Remaining six desktops it is working fine. I have no idea why > > the report is behaving in this way as in all desktops MS Access-2016 is > > installed. > > > > Any suggestion, advice highly appreciated. > > Rama Hello Phil, Apology for the delayed response. As you suggested, the problem happened due to default printer setup. Thank you so much. Rama
[toc] | [prev] | [next] | [standalone]
| From | "Phil Hunt" <NoOne@Nowhere.com> |
|---|---|
| Date | 2020-05-08 13:26 -0400 |
| Message-ID | <r944o7$e74$2@gioia.aioe.org> |
| In reply to | #14084 |
It could be that every computer has a different 'default' printer. <internet.shopping@foobox.com> wrote in message news:361e9b4f-e08c-45cd-be1b-d00346996099@googlegroups.com... Do you have the relevant printer driver installed on the machines where the problem arises? Jim On Friday, 8 May 2020 08:29:49 UTC+1, rama wrote: > On Thursday, May 7, 2020 at 6:39:08 PM UTC+3, Patrick Finucane wrote: > > On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote: > > > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote: > > > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote: > > > > > I have developed an MS Access 2016 database report, which has got > > > > > some 150 text fields and two sub reports. This report is opening > > > > > in report view and displaying data properly except date fields. > > > > > However, it is not displaying anything in print preview. Initially > > > > > the report was working fine, later it stopped. The select query, > > > > > which pulls data form the table is okay and displaying data > > > > > without any problem. I am looking for some kind help urgently as > > > > > the project to be submitted soon. > > > > > Thanks in advance. > > > > > Rama > > > > > > > > Throwing mud at the wall, hoping something sticks. > > > > > > > > Are all date fields blank or just some in your report? > > > > > > > > In your date field property sheet for Format see if mm/dd/yyyy makes > > > > any difference. > > > > > > > > Maybe try opening the the query as a recordset. Then ensure the > > > > date field is a date. Let's say your field is called startdt, then > > > > do a > > > > msgbox isdate(r.startdt) 'r being the recordset variable. > > > > and verify the field really is a date field. > > > > > > Apology for making misunderstanding. > > > > > > Mentioned report is setup to print in A3 size paper and default view > > > of the report is Print Preview. When I open the report, it does not > > > show anything in the page, even the labels for the text boxes, just > > > blank page. Also, it is worth to mention that the report has more > > > pages, although it is setup for one page. I have tried to save this > > > blank preview as .pdf file, but .pdf output file is corrupted. > > > > > > Due to the above-mentioned scenario, I have tried to open the report > > > in Report view to see what happens. For me I do not need to open it in > > > report view. I am only interested in Print Preview. > > > > > > Thanks for the reply > > > Rama > > > > Still tossing mud at the wall. > > > > First, open your report in design mode. Select the report and > > subreports and shrink the width by an inch on the right. I have a funny > > feeling your report is too wide for the paper size and is screwing up. > > Then run. Does that improve the report? > > > > Next, create a new report with the query as the recordsource. Add only > > a few fields to a report, mostly date fields. Run the report. Is it > > OK? > > > > Next, if all else fails, recreate the report. Stop/start/run the report > > as you recreate. See if you get better results. > > Thank you so much. > I have copied the same database in another desktop and the report is > opening in Print Preview without any problem. Later I tried the same in > another eight desktops, but found the above-mentioned trouble in two > desktops. Remaining six desktops it is working fine. I have no idea why > the report is behaving in this way as in all desktops MS Access-2016 is > installed. > > Any suggestion, advice highly appreciated. > Rama
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-access
csiph-web