pages limitations
in [Reports]
|
From: Gina Whipp on 24 Sep 2009 09:22 If Access is open it should appear in the Task Manager, so... 1. Is the front end located on their machine and the back end on a Server? 2. Are any users sharing front ends? 3. What kind of network? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "inungh" <inungh(a)gmail.com> wrote in message news:47c4f0f3-1dd4-4620-aac8-44ceab3c7339(a)a6g2000vbp.googlegroups.com... On Sep 23, 3:34 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > Still may be something with the network printer which is why I think you > should reinstalling it. > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "inungh" <inu...(a)gmail.com> wrote in message > > news:992e3cad-47dc-4477-8545-ba3cb13e22ad(a)d21g2000vbm.googlegroups.com... > On Sep 23, 2:18 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > > >inungh, > > > There are documented issues with Access and printer issues if Windows > > has > > no > > default > > printer.http://www.google.com/search?hl=en&q=ms+access+2003+can%27t+print&aq=... > > > And while Access is Access it can easily be reacting differently per > > machine. So on each machine is there a default printer? When you open > > Access can you actually see the default printer? > > > I would also uncheck Track Name Auto Correct and Compact on Close, just > > because... I would also want to make sure the network printer drivers > > are > > up to date. AND while you're at it, is every machine on the same SP > > version. > > > -- > > Gina Whipp > > > "I feel I have been denied critical, need to know, information!" - > > Tremors > > II > > >http://www.regina-whipp.com/index_files/TipList.htm > > > "inungh" <inu...(a)gmail.com> wrote in message > > >news:8cfa07c9-b377-4a50-8d03-7c0721af1d17(a)o13g2000vbl.googlegroups.com... > > On Sep 23, 1:52 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > Oops, wasn't clear... that would be the printer. There is nothing in > > > Access > > > or the Registry that says 'Stop after 18 pages', that is why looking > > > at > > > other options. I would also check that Access has a default printer > > > assigned. > > > > -- > > > Gina Whipp > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > >news:20867eb5-970a-4a87-b4f0-e113bf186839(a)b18g2000vbl.googlegroups.com... > > > On Sep 23, 10:16 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > >inungh, > > > > > Try removing and reinstalling... > > > > > -- > > > > Gina Whipp > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > >news:a7182633-15f6-4730-8b48-0dfe63034553(a)q14g2000vbi.googlegroups.com... > > > > On Sep 23, 12:43 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > wrote: > > > > > >inungh, > > > > > > Network printer? > > > > > > -- > > > > > Gina Whipp > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > Tremors > > > > > II > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > >news:59f7d4fb-bfb4-41ed-a364-ef479ee30a21(a)v2g2000vbb.googlegroups.com... > > > > > On Sep 22, 3:02 pm, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > wrote: > > > > > > > How many pages show in the Preview(On Screen)? > > > > > > What happens if you try to start printing from page 19? (Crash, > > > > > > nothing, > > > > > > or > > > > > > pages 19-36 print?) > > > > > > > "inungh" wrote: > > > > > > > On Sep 22, 8:49 am, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > > > wrote: > > > > > > > > How are you printing, what are you printing? Embellish a > > > > > > > > little > > > > > > > > more > > > > > > > > about > > > > > > > > the issue. > > > > > > > > > "iccsi" wrote: > > > > > > > > > I have an application and suddently is unable to print > > > > > > > > > report > > > > > > > > > more > > > > > > > > > than 18 pages. > > > > > > > > > > I know that the MS Access report limitation should be > > > > > > > > > 65535 > > > > > > > > > pages. > > > > > > > > > > I just wodner are there any place to limit pages to print > > > > > > > > > from > > > > > > > > > Windows > > > > > > > > > or printer configuration? > > > > > > > > > > Your help is great appreciated,- Hide quoted text - > > > > > > > > > - Show quoted text - > > > > > > > > I use the following code to preview reports > > > > > > > > DoCmd.OpenReport stDocName, acPreview > > > > > > > > and following code to print reports > > > > > > > > DoCmd.OpenReport stDocName, acNormal > > > > > > > > It works on my machine, but some of users can only print up to > > > > > > > 18 > > > > > > > pages reports. > > > > > > > I asked user to try print from MS Word whoch can print > > > > > > > documents > > > > > > > more > > > > > > > than 18 pages. > > > > > > > > It looks some how MS Access does not like certain machine to > > > > > > > more than 18 pages of the reports. > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > - Show quoted text - > > > > > > the application frozen even preview. > > > > > The application print normal on preview and print if page less > > > > > than > > > > > 18. > > > > > If more than 18 the application frozen and have end task to close > > > > > the > > > > > application. > > > > > > Thanks again,- Hide quoted text - > > > > > > - Show quoted text - > > > > > yes, network printer. > > > > Thanks again,- Hide quoted text - > > > > > - Show quoted text - > > > > Removing and reinstalling MS Access or printer? > > > It works on my computer, but some users can not print more than 18 > > > pages. > > > There are many computers can not print. If MS Access corrupted then it > > > is not normal to have many computers have same issue. > > > > It looks like users do not have proper rights on some where registry. > > > I am looking for some thing in registry for MS Access or printer that > > > limit users to print only 18 pages and less.- Hide quoted text - > > > > - Show quoted text - > > > Thanks, Understood, > > I tried to look for printer setup. > > There is no printer setup to limit pages either. > > > Default printer should base on Windows setup. Am I right? > > Yes, there is default printer on the Windows, but some computers can > > printer on either printers. > > If it is printer issue then should every one can not print the same > > printer. > > > It is a really strange behavior of MS Access report. > > I never seen it before. > > > Thanks again,- Hide quoted text - > > > - Show quoted text - > > Thanks for the message, > I will check users machines for this. > The issue is users can print, but not more than 18 pages which means > users machine may access the printer. > > The application frozen even can not preview if the document is 18 > pages and more. > > Thanks millions for helping and information,- Hide quoted text - > > - Show quoted text - Thanks for helping, Understood, I need find a way to prove that it is the printer. After I checked users' machines and realize that the MS Access does not appear on the task manager that can not print more than 18 pages. If the applicaiton appears on the task manager then is able to print. Does this make any meaning to you? Thanks again,
From: inungh on 24 Sep 2009 09:45 On Sep 24, 9:22 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > If Access is open it should appear in the Task Manager, so... > > 1. Is the front end located on their machine and the back end on a Server? > 2. Are any users sharing front ends? > 3. What kind of network? > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "inungh" <inu...(a)gmail.com> wrote in message > > news:47c4f0f3-1dd4-4620-aac8-44ceab3c7339(a)a6g2000vbp.googlegroups.com... > On Sep 23, 3:34 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > > > Still may be something with the network printer which is why I think you > > should reinstalling it. > > > -- > > Gina Whipp > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > >http://www.regina-whipp.com/index_files/TipList.htm > > > "inungh" <inu...(a)gmail.com> wrote in message > > >news:992e3cad-47dc-4477-8545-ba3cb13e22ad(a)d21g2000vbm.googlegroups.com.... > > On Sep 23, 2:18 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > >inungh, > > > > There are documented issues with Access and printer issues if Windows > > > has > > > no > > > default > > > printer.http://www.google.com/search?hl=en&q=ms+access+2003+can%27t+print&aq=... > > > > And while Access is Access it can easily be reacting differently per > > > machine. So on each machine is there a default printer? When you open > > > Access can you actually see the default printer? > > > > I would also uncheck Track Name Auto Correct and Compact on Close, just > > > because... I would also want to make sure the network printer drivers > > > are > > > up to date. AND while you're at it, is every machine on the same SP > > > version. > > > > -- > > > Gina Whipp > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > >news:8cfa07c9-b377-4a50-8d03-7c0721af1d17(a)o13g2000vbl.googlegroups.com.... > > > On Sep 23, 1:52 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > Oops, wasn't clear... that would be the printer. There is nothing in > > > > Access > > > > or the Registry that says 'Stop after 18 pages', that is why looking > > > > at > > > > other options. I would also check that Access has a default printer > > > > assigned. > > > > > -- > > > > Gina Whipp > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > >news:20867eb5-970a-4a87-b4f0-e113bf186839(a)b18g2000vbl.googlegroups.com... > > > > On Sep 23, 10:16 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > >inungh, > > > > > > Try removing and reinstalling... > > > > > > -- > > > > > Gina Whipp > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > Tremors > > > > > II > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > >news:a7182633-15f6-4730-8b48-0dfe63034553(a)q14g2000vbi.googlegroups..com... > > > > > On Sep 23, 12:43 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > > wrote: > > > > > > >inungh, > > > > > > > Network printer? > > > > > > > -- > > > > > > Gina Whipp > > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > > Tremors > > > > > > II > > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > > >news:59f7d4fb-bfb4-41ed-a364-ef479ee30a21(a)v2g2000vbb.googlegroups.com... > > > > > > On Sep 22, 3:02 pm, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > > wrote: > > > > > > > > How many pages show in the Preview(On Screen)? > > > > > > > What happens if you try to start printing from page 19? (Crash, > > > > > > > nothing, > > > > > > > or > > > > > > > pages 19-36 print?) > > > > > > > > "inungh" wrote: > > > > > > > > On Sep 22, 8:49 am, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > > > > wrote: > > > > > > > > > How are you printing, what are you printing? Embellish a > > > > > > > > > little > > > > > > > > > more > > > > > > > > > about > > > > > > > > > the issue. > > > > > > > > > > "iccsi" wrote: > > > > > > > > > > I have an application and suddently is unable to print > > > > > > > > > > report > > > > > > > > > > more > > > > > > > > > > than 18 pages. > > > > > > > > > > > I know that the MS Access report limitation should be > > > > > > > > > > 65535 > > > > > > > > > > pages. > > > > > > > > > > > I just wodner are there any place to limit pages to print > > > > > > > > > > from > > > > > > > > > > Windows > > > > > > > > > > or printer configuration? > > > > > > > > > > > Your help is great appreciated,- Hide quoted text - > > > > > > > > > > - Show quoted text - > > > > > > > > > I use the following code to preview reports > > > > > > > > > DoCmd.OpenReport stDocName, acPreview > > > > > > > > > and following code to print reports > > > > > > > > > DoCmd.OpenReport stDocName, acNormal > > > > > > > > > It works on my machine, but some of users can only print up to > > > > > > > > 18 > > > > > > > > pages reports. > > > > > > > > I asked user to try print from MS Word whoch can print > > > > > > > > documents > > > > > > > > more > > > > > > > > than 18 pages. > > > > > > > > > It looks some how MS Access does not like certain machine to > > > > > > > > more than 18 pages of the reports. > > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > > - Show quoted text - > > > > > > > the application frozen even preview. > > > > > > The application print normal on preview and print if page less > > > > > > than > > > > > > 18. > > > > > > If more than 18 the application frozen and have end task to close > > > > > > the > > > > > > application. > > > > > > > Thanks again,- Hide quoted text - > > > > > > > - Show quoted text - > > > > > > yes, network printer. > > > > > Thanks again,- Hide quoted text - > > > > > > - Show quoted text - > > > > > Removing and reinstalling MS Access or printer? > > > > It works on my computer, but some users can not print more than 18 > > > > pages. > > > > There are many computers can not print. If MS Access corrupted then it > > > > is not normal to have many computers have same issue. > > > > > It looks like users do not have proper rights on some where registry. > > > > I am looking for some thing in registry for MS Access or printer that > > > > limit users to print only 18 pages and less.- Hide quoted text - > > > > > - Show quoted text - > > > > Thanks, Understood, > > > I tried to look for printer setup. > > > There is no printer setup to limit pages either. > > > > Default printer should base on Windows setup. Am I right? > > > Yes, there is default printer on the Windows, but some computers can > > > printer on either printers. > > > If it is printer issue then should every one can not print the same > > > printer. > > > > It is a really strange behavior of MS Access report. > > > I never seen it before. > > > > Thanks again,- Hide quoted text - > > > > - Show quoted text - > > > Thanks for the message, > > I will check users machines for this. > > The issue is users can print, but not more than 18 pages which means > > users machine may access the printer. > > > The application frozen even can not preview if the document is 18 > > pages and more. > > > Thanks millions for helping and information,- Hide quoted text - > > > - Show quoted text - > > Thanks for helping, > Understood, I need find a way to prove that it is the printer. > > After I checked users' machines and realize that the MS Access does > not appear on the task manager that can not print more than 18 pages. > If the applicaiton appears on the task manager then is able to print. > > Does this make any meaning to you? > > Thanks again,- Hide quoted text - > > - Show quoted text - 1. Yes 2. No 3. LAN MS Access shows on the process tab, but it does not show in the application tab.
From: Gina Whipp on 24 Sep 2009 10:33 No issues, there... I admit this is completely new to me. I have never had that happen but then again never had Access not print reports over 18 pages... 1. Make and model of the printer? 2. How many users of the Access database? Other things to check... The machines where it does not show in the Applications tab... A. Do those users have full permissions to the folder where the backend resides? Also found this, kind of old but might give you some ideas... http://groups.google.com/group/microsoft.public.internetexplorer.general/browse_thread/thread/a72cc3d50a73e693/6af050b7cc16a286%236af050b7cc16a286 http://social.technet.microsoft.com/Forums/en-US/itprovistaie/thread/e6682717-5e5d-4f81-b081-0a4e7e84828b -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "inungh" <inungh(a)gmail.com> wrote in message news:ed729e77-325e-4705-a604-83d11f9c2672(a)o13g2000vbl.googlegroups.com... On Sep 24, 9:22 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > If Access is open it should appear in the Task Manager, so... > > 1. Is the front end located on their machine and the back end on a Server? > 2. Are any users sharing front ends? > 3. What kind of network? > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "inungh" <inu...(a)gmail.com> wrote in message > > news:47c4f0f3-1dd4-4620-aac8-44ceab3c7339(a)a6g2000vbp.googlegroups.com... > On Sep 23, 3:34 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > > > Still may be something with the network printer which is why I think you > > should reinstalling it. > > > -- > > Gina Whipp > > > "I feel I have been denied critical, need to know, information!" - > > Tremors > > II > > >http://www.regina-whipp.com/index_files/TipList.htm > > > "inungh" <inu...(a)gmail.com> wrote in message > > >news:992e3cad-47dc-4477-8545-ba3cb13e22ad(a)d21g2000vbm.googlegroups.com... > > On Sep 23, 2:18 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > >inungh, > > > > There are documented issues with Access and printer issues if Windows > > > has > > > no > > > default > > > printer.http://www.google.com/search?hl=en&q=ms+access+2003+can%27t+print&aq=... > > > > And while Access is Access it can easily be reacting differently per > > > machine. So on each machine is there a default printer? When you open > > > Access can you actually see the default printer? > > > > I would also uncheck Track Name Auto Correct and Compact on Close, > > > just > > > because... I would also want to make sure the network printer drivers > > > are > > > up to date. AND while you're at it, is every machine on the same SP > > > version. > > > > -- > > > Gina Whipp > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > >news:8cfa07c9-b377-4a50-8d03-7c0721af1d17(a)o13g2000vbl.googlegroups.com... > > > On Sep 23, 1:52 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > Oops, wasn't clear... that would be the printer. There is nothing in > > > > Access > > > > or the Registry that says 'Stop after 18 pages', that is why looking > > > > at > > > > other options. I would also check that Access has a default printer > > > > assigned. > > > > > -- > > > > Gina Whipp > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > >news:20867eb5-970a-4a87-b4f0-e113bf186839(a)b18g2000vbl.googlegroups.com... > > > > On Sep 23, 10:16 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > wrote: > > > > > >inungh, > > > > > > Try removing and reinstalling... > > > > > > -- > > > > > Gina Whipp > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > Tremors > > > > > II > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > >news:a7182633-15f6-4730-8b48-0dfe63034553(a)q14g2000vbi.googlegroups.com... > > > > > On Sep 23, 12:43 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > > wrote: > > > > > > >inungh, > > > > > > > Network printer? > > > > > > > -- > > > > > > Gina Whipp > > > > > > > "I feel I have been denied critical, need to know, > > > > > > information!" - > > > > > > Tremors > > > > > > II > > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > > >news:59f7d4fb-bfb4-41ed-a364-ef479ee30a21(a)v2g2000vbb.googlegroups.com... > > > > > > On Sep 22, 3:02 pm, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > > wrote: > > > > > > > > How many pages show in the Preview(On Screen)? > > > > > > > What happens if you try to start printing from page 19? > > > > > > > (Crash, > > > > > > > nothing, > > > > > > > or > > > > > > > pages 19-36 print?) > > > > > > > > "inungh" wrote: > > > > > > > > On Sep 22, 8:49 am, S.Clark > > > > > > > > <SCl...(a)discussions.microsoft.com> > > > > > > > > wrote: > > > > > > > > > How are you printing, what are you printing? Embellish a > > > > > > > > > little > > > > > > > > > more > > > > > > > > > about > > > > > > > > > the issue. > > > > > > > > > > "iccsi" wrote: > > > > > > > > > > I have an application and suddently is unable to print > > > > > > > > > > report > > > > > > > > > > more > > > > > > > > > > than 18 pages. > > > > > > > > > > > I know that the MS Access report limitation should be > > > > > > > > > > 65535 > > > > > > > > > > pages. > > > > > > > > > > > I just wodner are there any place to limit pages to > > > > > > > > > > from > > > > > > > > > > Windows > > > > > > > > > > or printer configuration? > > > > > > > > > > > Your help is great appreciated,- Hide quoted text - > > > > > > > > > > - Show quoted text - > > > > > > > > > I use the following code to preview reports > > > > > > > > > DoCmd.OpenReport stDocName, acPreview > > > > > > > > > and following code to print reports > > > > > > > > > DoCmd.OpenReport stDocName, acNormal > > > > > > > > > It works on my machine, but some of users can only print up > > > > > > > > to > > > > > > > > 18 > > > > > > > > pages reports. > > > > > > > > I asked user to try print from MS Word whoch can print > > > > > > > > documents > > > > > > > > more > > > > > > > > than 18 pages. > > > > > > > > > It looks some how MS Access does not like certain machine to > > > > > > > > more than 18 pages of the reports. > > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > > - Show quoted text - > > > > > > > the application frozen even preview. > > > > > > The application print normal on preview and print if page less > > > > > > than > > > > > > 18. > > > > > > If more than 18 the application frozen and have end task to > > > > > > close > > > > > > the > > > > > > application. > > > > > > > Thanks again,- Hide quoted text - > > > > > > > - Show quoted text - > > > > > > yes, network printer. > > > > > Thanks again,- Hide quoted text - > > > > > > - Show quoted text - > > > > > Removing and reinstalling MS Access or printer? > > > > It works on my computer, but some users can not print more than 18 > > > > pages. > > > > There are many computers can not print. If MS Access corrupted then > > > > it > > > > is not normal to have many computers have same issue. > > > > > It looks like users do not have proper rights on some where > > > > registry. > > > > I am looking for some thing in registry for MS Access or printer > > > > that > > > > limit users to print only 18 pages and less.- Hide quoted text - > > > > > - Show quoted text - > > > > Thanks, Understood, > > > I tried to look for printer setup. > > > There is no printer setup to limit pages either. > > > > Default printer should base on Windows setup. Am I right? > > > Yes, there is default printer on the Windows, but some computers can > > > printer on either printers. > > > If it is printer issue then should every one can not print the same > > > printer. > > > > It is a really strange behavior of MS Access report. > > > I never seen it before. > > > > Thanks again,- Hide quoted text - > > > > - Show quoted text - > > > Thanks for the message, > > I will check users machines for this. > > The issue is users can print, but not more than 18 pages which means > > users machine may access the printer. > > > The application frozen even can not preview if the document is 18 > > pages and more. > > > Thanks millions for helping and information,- Hide quoted text - > > > - Show quoted text - > > Thanks for helping, > Understood, I need find a way to prove that it is the printer. > > After I checked users' machines and realize that the MS Access does > not appear on the task manager that can not print more than 18 pages. > If the applicaiton appears on the task manager then is able to print. > > Does this make any meaning to you? > > Thanks again,- Hide quoted text - > > - Show quoted text - 1. Yes 2. No 3. LAN MS Access shows on the process tab, but it does not show in the application tab.
From: inungh on 24 Sep 2009 13:38 On Sep 24, 10:33 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > No issues, there... I admit this is completely new to me. I have never had > that happen but then again never had Access not print reports over 18 > pages... > > 1. Make and model of the printer? > > 2. How many users of the Access database? > > Other things to check... > > The machines where it does not show in the Applications tab... > > A. Do those users have full permissions to the folder where the backend > resides? > > Also found this, kind of old but might give you some ideas... > > http://groups.google.com/group/microsoft.public.internetexplorer.gene... > > http://social.technet.microsoft.com/Forums/en-US/itprovistaie/thread/... > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "inungh" <inu...(a)gmail.com> wrote in message > > news:ed729e77-325e-4705-a604-83d11f9c2672(a)o13g2000vbl.googlegroups.com... > On Sep 24, 9:22 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > > > If Access is open it should appear in the Task Manager, so... > > > 1. Is the front end located on their machine and the back end on a Server? > > 2. Are any users sharing front ends? > > 3. What kind of network? > > > -- > > Gina Whipp > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > >http://www.regina-whipp.com/index_files/TipList.htm > > > "inungh" <inu...(a)gmail.com> wrote in message > > >news:47c4f0f3-1dd4-4620-aac8-44ceab3c7339(a)a6g2000vbp.googlegroups.com... > > On Sep 23, 3:34 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > Still may be something with the network printer which is why I think you > > > should reinstalling it. > > > > -- > > > Gina Whipp > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > >news:992e3cad-47dc-4477-8545-ba3cb13e22ad(a)d21g2000vbm.googlegroups.com.... > > > On Sep 23, 2:18 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > >inungh, > > > > > There are documented issues with Access and printer issues if Windows > > > > has > > > > no > > > > default > > > > printer.http://www.google.com/search?hl=en&q=ms+access+2003+can%27t+print&aq=... > > > > > And while Access is Access it can easily be reacting differently per > > > > machine. So on each machine is there a default printer? When you open > > > > Access can you actually see the default printer? > > > > > I would also uncheck Track Name Auto Correct and Compact on Close, > > > > just > > > > because... I would also want to make sure the network printer drivers > > > > are > > > > up to date. AND while you're at it, is every machine on the same SP > > > > version. > > > > > -- > > > > Gina Whipp > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > >news:8cfa07c9-b377-4a50-8d03-7c0721af1d17(a)o13g2000vbl.googlegroups.com... > > > > On Sep 23, 1:52 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > > Oops, wasn't clear... that would be the printer. There is nothing in > > > > > Access > > > > > or the Registry that says 'Stop after 18 pages', that is why looking > > > > > at > > > > > other options. I would also check that Access has a default printer > > > > > assigned. > > > > > > -- > > > > > Gina Whipp > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > Tremors > > > > > II > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > >news:20867eb5-970a-4a87-b4f0-e113bf186839(a)b18g2000vbl.googlegroups..com... > > > > > On Sep 23, 10:16 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > > wrote: > > > > > > >inungh, > > > > > > > Try removing and reinstalling... > > > > > > > -- > > > > > > Gina Whipp > > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > > Tremors > > > > > > II > > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > > >news:a7182633-15f6-4730-8b48-0dfe63034553(a)q14g2000vbi.googlegroups.com... > > > > > > On Sep 23, 12:43 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > > > wrote: > > > > > > > >inungh, > > > > > > > > Network printer? > > > > > > > > -- > > > > > > > Gina Whipp > > > > > > > > "I feel I have been denied critical, need to know, > > > > > > > information!" - > > > > > > > Tremors > > > > > > > II > > > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > > > >news:59f7d4fb-bfb4-41ed-a364-ef479ee30a21(a)v2g2000vbb.googlegroups.com... > > > > > > > On Sep 22, 3:02 pm, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > > > wrote: > > > > > > > > > How many pages show in the Preview(On Screen)? > > > > > > > > What happens if you try to start printing from page 19? > > > > > > > > (Crash, > > > > > > > > nothing, > > > > > > > > or > > > > > > > > pages 19-36 print?) > > > > > > > > > "inungh" wrote: > > > > > > > > > On Sep 22, 8:49 am, S.Clark > > > > > > > > > <SCl...(a)discussions.microsoft.com> > > > > > > > > > wrote: > > > > > > > > > > How are you printing, what are you printing? Embellish a > > > > > > > > > > little > > > > > > > > > > more > > > > > > > > > > about > > > > > > > > > > the issue. > > > > > > > > > > > "iccsi" wrote: > > > > > > > > > > > I have an application and suddently is unable to print > > > > > > > > > > > report > > > > > > > > > > > more > > > > > > > > > > > than 18 pages. > > > > > > > > > > > > I know that the MS Access report limitation should be > > > > > > > > > > > 65535 > > > > > > > > > > > pages. > > > > > > > > > > > > I just wodner are there any place to limit pages to > > > > > > > > > > > from > > > > > > > > > > > Windows > > > > > > > > > > > or printer configuration? > > > > > > > > > > > > Your help is great appreciated,- Hide quoted text - > > > > > > > > > > > - Show quoted text - > > > > > > > > > > I use the following code to preview reports > > > > > > > > > > DoCmd.OpenReport stDocName, acPreview > > > > > > > > > > and following code to print reports > > > > > > > > > > DoCmd.OpenReport stDocName, acNormal > > > > > > > > > > It works on my machine, but some of users can only print up > > > > > > > > > to > > > > > > > > > 18 > > > > > > > > > pages reports. > > > > > > > > > I asked user to try print from MS Word whoch can print > > > > > > > > > documents > > > > > > > > > more > > > > > > > > > than 18 pages. > > > > > > > > > > It looks some how MS Access does not like certain machine to > > > > > > > > > more than 18 pages of the reports. > > > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > > > - Show quoted text - > > > > > > > > the application frozen even preview. > > > > > > > The application print normal on preview and print if page less > > > > > > > than > > > > > > > 18. > > > > > > > If more than 18 the application frozen and have end task to > > > > > > > close > > > > > > > the > > > > > > > application. > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > > - Show quoted text - > > > > > > > yes, network printer. > > > > > > Thanks again,- Hide quoted text - > > > > > > > - Show quoted text - > > > > > > Removing and reinstalling MS Access or printer? > > > > > It works on my computer, but some users can not print more than 18 > > > > > pages. > > > > > There are many computers can not print. If MS Access corrupted then > > > > > it > > > > > is not normal to have many computers have same issue. > > > > > > It looks like users do not have proper rights on some where > > > > > registry. > > > > > I am looking for some thing in registry for MS Access or printer > > > > > that > > > > > limit users to print only 18 pages and less.- Hide quoted text - > > > > > > - Show quoted text - > > > > > Thanks, Understood, > > > > I tried to look for printer setup. > > > > There is no printer setup to limit pages either. > > > > > Default printer should base on Windows setup. Am I right? > > > > Yes, there is default printer on the Windows, but some computers can > > > > printer on either printers. > > > > If it is printer issue then should every one can not print the same > > > > printer. > > > > > It is a really strange behavior of MS Access report. > > > > I never seen it before. > > > > > Thanks again,- Hide quoted text - > > > > > - Show quoted text - > > > > Thanks for the message, > > > I will check users machines for this. > > > The issue is users can print, but not more than 18 pages which means > > > users machine may access the printer. > > > > The application frozen even can not preview if the document is 18 > > > pages and more. > > > > Thanks millions for helping and information,- Hide quoted text - > > > > - Show quoted text - > > > Thanks for helping, > > Understood, I need find a way to prove that it is the printer. > > > After I checked users' machines and realize that the MS Access does > > not appear on the task manager that can not print more than 18 pages. > > If the applicaiton appears on the task manager then is able to print. > > > Does this make any meaning to you? > > > Thanks again,- Hide quoted text - > > > - Show quoted text - > > 1. Yes > 2. No > 3. LAN > > MS Access shows on the process tab, but it does not show in the > application tab.- Hide quoted text - > > - Show quoted text - Thanks millions again,
From: Gina Whipp on 24 Sep 2009 13:57
Does this reply mean you found the solution? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "inungh" <inungh(a)gmail.com> wrote in message news:cfc17db7-282d-47f6-b988-3ce49ae11d8c(a)h30g2000vbr.googlegroups.com... On Sep 24, 10:33 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > No issues, there... I admit this is completely new to me. I have never had > that happen but then again never had Access not print reports over 18 > pages... > > 1. Make and model of the printer? > > 2. How many users of the Access database? > > Other things to check... > > The machines where it does not show in the Applications tab... > > A. Do those users have full permissions to the folder where the backend > resides? > > Also found this, kind of old but might give you some ideas... > > http://groups.google.com/group/microsoft.public.internetexplorer.gene... > > http://social.technet.microsoft.com/Forums/en-US/itprovistaie/thread/... > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "inungh" <inu...(a)gmail.com> wrote in message > > news:ed729e77-325e-4705-a604-83d11f9c2672(a)o13g2000vbl.googlegroups.com... > On Sep 24, 9:22 am, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > > > > If Access is open it should appear in the Task Manager, so... > > > 1. Is the front end located on their machine and the back end on a > > Server? > > 2. Are any users sharing front ends? > > 3. What kind of network? > > > -- > > Gina Whipp > > > "I feel I have been denied critical, need to know, information!" - > > Tremors > > II > > >http://www.regina-whipp.com/index_files/TipList.htm > > > "inungh" <inu...(a)gmail.com> wrote in message > > >news:47c4f0f3-1dd4-4620-aac8-44ceab3c7339(a)a6g2000vbp.googlegroups.com... > > On Sep 23, 3:34 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > Still may be something with the network printer which is why I think > > > you > > > should reinstalling it. > > > > -- > > > Gina Whipp > > > > "I feel I have been denied critical, need to know, information!" - > > > Tremors > > > II > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > >news:992e3cad-47dc-4477-8545-ba3cb13e22ad(a)d21g2000vbm.googlegroups.com... > > > On Sep 23, 2:18 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > > > > >inungh, > > > > > There are documented issues with Access and printer issues if > > > > Windows > > > > has > > > > no > > > > default > > > > printer.http://www.google.com/search?hl=en&q=ms+access+2003+can%27t+print&aq=... > > > > > And while Access is Access it can easily be reacting differently per > > > > machine. So on each machine is there a default printer? When you > > > > open > > > > Access can you actually see the default printer? > > > > > I would also uncheck Track Name Auto Correct and Compact on Close, > > > > just > > > > because... I would also want to make sure the network printer > > > > drivers > > > > are > > > > up to date. AND while you're at it, is every machine on the same SP > > > > version. > > > > > -- > > > > Gina Whipp > > > > > "I feel I have been denied critical, need to know, information!" - > > > > Tremors > > > > II > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > >news:8cfa07c9-b377-4a50-8d03-7c0721af1d17(a)o13g2000vbl.googlegroups.com... > > > > On Sep 23, 1:52 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > wrote: > > > > > > Oops, wasn't clear... that would be the printer. There is nothing > > > > > in > > > > > Access > > > > > or the Registry that says 'Stop after 18 pages', that is why > > > > > looking > > > > > at > > > > > other options. I would also check that Access has a default > > > > > printer > > > > > assigned. > > > > > > -- > > > > > Gina Whipp > > > > > > "I feel I have been denied critical, need to know, information!" - > > > > > Tremors > > > > > II > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > >news:20867eb5-970a-4a87-b4f0-e113bf186839(a)b18g2000vbl.googlegroups.com... > > > > > On Sep 23, 10:16 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > > wrote: > > > > > > >inungh, > > > > > > > Try removing and reinstalling... > > > > > > > -- > > > > > > Gina Whipp > > > > > > > "I feel I have been denied critical, need to know, > > > > > > information!" - > > > > > > Tremors > > > > > > II > > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > > >news:a7182633-15f6-4730-8b48-0dfe63034553(a)q14g2000vbi.googlegroups.com... > > > > > > On Sep 23, 12:43 am, "Gina Whipp" <NotInteres...(a)InViruses.com> > > > > > > wrote: > > > > > > > >inungh, > > > > > > > > Network printer? > > > > > > > > -- > > > > > > > Gina Whipp > > > > > > > > "I feel I have been denied critical, need to know, > > > > > > > information!" - > > > > > > > Tremors > > > > > > > II > > > > > > > >http://www.regina-whipp.com/index_files/TipList.htm > > > > > > > > "inungh" <inu...(a)gmail.com> wrote in message > > > > > > > >news:59f7d4fb-bfb4-41ed-a364-ef479ee30a21(a)v2g2000vbb.googlegroups.com... > > > > > > > On Sep 22, 3:02 pm, S.Clark <SCl...(a)discussions.microsoft.com> > > > > > > > wrote: > > > > > > > > > How many pages show in the Preview(On Screen)? > > > > > > > > What happens if you try to start printing from page 19? > > > > > > > > (Crash, > > > > > > > > nothing, > > > > > > > > or > > > > > > > > pages 19-36 print?) > > > > > > > > > "inungh" wrote: > > > > > > > > > On Sep 22, 8:49 am, S.Clark > > > > > > > > > <SCl...(a)discussions.microsoft.com> > > > > > > > > > wrote: > > > > > > > > > > How are you printing, what are you printing? Embellish a > > > > > > > > > > little > > > > > > > > > > more > > > > > > > > > > about > > > > > > > > > > the issue. > > > > > > > > > > > "iccsi" wrote: > > > > > > > > > > > I have an application and suddently is unable to print > > > > > > > > > > > report > > > > > > > > > > > more > > > > > > > > > > > than 18 pages. > > > > > > > > > > > > I know that the MS Access report limitation should be > > > > > > > > > > > 65535 > > > > > > > > > > > pages. > > > > > > > > > > > > I just wodner are there any place to limit pages to > > > > > > > > > > > from > > > > > > > > > > > Windows > > > > > > > > > > > or printer configuration? > > > > > > > > > > > > Your help is great appreciated,- Hide quoted text - > > > > > > > > > > > - Show quoted text - > > > > > > > > > > I use the following code to preview reports > > > > > > > > > > DoCmd.OpenReport stDocName, acPreview > > > > > > > > > > and following code to print reports > > > > > > > > > > DoCmd.OpenReport stDocName, acNormal > > > > > > > > > > It works on my machine, but some of users can only print > > > > > > > > > up > > > > > > > > > to > > > > > > > > > 18 > > > > > > > > > pages reports. > > > > > > > > > I asked user to try print from MS Word whoch can print > > > > > > > > > documents > > > > > > > > > more > > > > > > > > > than 18 pages. > > > > > > > > > > It looks some how MS Access does not like certain machine > > > > > > > > > to > > > > > > > > > more than 18 pages of the reports. > > > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > > > - Show quoted text - > > > > > > > > the application frozen even preview. > > > > > > > The application print normal on preview and print if page less > > > > > > > than > > > > > > > 18. > > > > > > > If more than 18 the application frozen and have end task to > > > > > > > close > > > > > > > the > > > > > > > application. > > > > > > > > Thanks again,- Hide quoted text - > > > > > > > > - Show quoted text - > > > > > > > yes, network printer. > > > > > > Thanks again,- Hide quoted text - > > > > > > > - Show quoted text - > > > > > > Removing and reinstalling MS Access or printer? > > > > > It works on my computer, but some users can not print more than 18 > > > > > pages. > > > > > There are many computers can not print. If MS Access corrupted > > > > > then > > > > > it > > > > > is not normal to have many computers have same issue. > > > > > > It looks like users do not have proper rights on some where > > > > > registry. > > > > > I am looking for some thing in registry for MS Access or printer > > > > > that > > > > > limit users to print only 18 pages and less.- Hide quoted text - > > > > > > - Show quoted text - > > > > > Thanks, Understood, > > > > I tried to look for printer setup. > > > > There is no printer setup to limit pages either. > > > > > Default printer should base on Windows setup. Am I right? > > > > Yes, there is default printer on the Windows, but some computers can > > > > printer on either printers. > > > > If it is printer issue then should every one can not print the same > > > > printer. > > > > > It is a really strange behavior of MS Access report. > > > > I never seen it before. > > > > > Thanks again,- Hide quoted text - > > > > > - Show quoted text - > > > > Thanks for the message, > > > I will check users machines for this. > > > The issue is users can print, but not more than 18 pages which means > > > users machine may access the printer. > > > > The application frozen even can not preview if the document is 18 > > > pages and more. > > > > Thanks millions for helping and information,- Hide quoted text - > > > > - Show quoted text - > > > Thanks for helping, > > Understood, I need find a way to prove that it is the printer. > > > After I checked users' machines and realize that the MS Access does > > not appear on the task manager that can not print more than 18 pages. > > If the applicaiton appears on the task manager then is able to print. > > > Does this make any meaning to you? > > > Thanks again,- Hide quoted text - > > > - Show quoted text - > > 1. Yes > 2. No > 3. LAN > > MS Access shows on the process tab, but it does not show in the > application tab.- Hide quoted text - > > - Show quoted text - Thanks millions again, |