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 |
#21
|
|||
|
|||
pages limitations
On Sep 24, 1:57*pm, "Gina Whipp" wrote:
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" wrote in message ... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message .... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message .... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 ... read more »- Hide quoted text - - Show quoted text - Not yet, but I will let you know when I found solution and I will find the problem, With your help, I beleive I am very close to find the problem. Hopefully, I can find the solution by tomorrow. Thanks again, |
#22
|
|||
|
|||
pages limitations
Okie dokie...
-- 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" wrote in message ... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message ... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message ... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 ... read more »- Hide quoted text - - Show quoted text - Not yet, but I will let you know when I found solution and I will find the problem, With your help, I beleive I am very close to find the problem. Hopefully, I can find the solution by tomorrow. Thanks again, |
#23
|
|||
|
|||
pages limitations
On Sep 24, 8:30*pm, "Gina Whipp" wrote:
Okie dokie... -- 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" wrote in message ... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message .... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene.... http://social.technet.microsoft.com/...istaie/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" wrote in message .... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 ... read more »- Hide quoted text - - Show quoted text - Hi, Per our conversations, I found the problem to run MS Access without openning any databases once then running applications then everything is working. It seems that MS Access missing some service pack for this. Thanks millions for helping, |
#24
|
|||
|
|||
pages limitations
Well, that's the first time I have herd of this because of missing Service
Packs, which ones were missing? -- 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" wrote in message ... On Sep 24, 8:30 pm, "Gina Whipp" wrote: Okie dokie... -- 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" wrote in message ... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message ... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message ... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 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 ... read more »- Hide quoted text - - Show quoted text - Hi, Per our conversations, I found the problem to run MS Access without openning any databases once then running applications then everything is working. It seems that MS Access missing some service pack for this. Thanks millions for helping, |
#25
|
|||
|
|||
pages limitations
On Sep 29, 11:27*am, "Gina Whipp" wrote:
Well, that's the first time I have herd of this because of missing Service Packs, which ones were missing? -- 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" wrote in message ... On Sep 24, 8:30 pm, "Gina Whipp" wrote: Okie dokie... -- 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" wrote in message ... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message .... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message ... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 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 - ... read more »- Hide quoted text - - Show quoted text - I am not sure, because I just ran the MS Access database without opening any databases and the message show to install MS Access which I beleive it updates something. It is possible to miss one but can not tell which one or MS Access just corruppted on those machines. The symptom is application title bar missing and does not show in task manager and unable to print reports which 18 pages and more, After running the MS Access, all problems are gone. Is it Microsoft magic? Thanks millions for helping, |
#26
|
|||
|
|||
pages limitations
A message to install Microsoft Access does not install any updates, it means
you have more then one version running on your machine. 1. What versions of Access do you have installed? 2. What version is the database in? 3. Is this databse an .MDE? 4. What is the Make and Model of the 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 - SNIPPED- I am not sure, because I just ran the MS Access database without opening any databases and the message show to install MS Access which I beleive it updates something. It is possible to miss one but can not tell which one or MS Access just corruppted on those machines. The symptom is application title bar missing and does not show in task manager and unable to print reports which 18 pages and more, After running the MS Access, all problems are gone. Is it Microsoft magic? Thanks millions for helping, |
#27
|
|||
|
|||
pages limitations
On Sep 29, 11:27*am, "Gina Whipp" wrote:
Well, that's the first time I have herd of this because of missing Service Packs, which ones were missing? -- 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" wrote in message ... On Sep 24, 8:30 pm, "Gina Whipp" wrote: Okie dokie... -- 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" wrote in message ... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message .... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message ... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 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 - ... read more »- Hide quoted text - - Show quoted text - Hi, Finally, I know what is real reason. One of the applicaiton which created by other user using MS Access run time version to run his stuff. Once users running the running version of databases then it changes the all application running using run time version. The MS Acess fixes itself when I run a full version of application without databases then change back to full version. It makes sense now that the database come back after I running. It does not appear in the task manager when it is run time version. I still have one question is that does MS Access run time version to limit pages numbers? Thanks millions for helping, |
#28
|
|||
|
|||
pages limitations
I do not know why the Runtime limits the page printing. It must be
something in the code and without being to review the code... I should also note, I have never heard of such a thing. However, to avoid this issue, you should change the shortcut to resemble the following.. "c:\Program Files\Microsoft Office 2003\Office\msaccess.exe" "YourDriveLetter:\MainFolder\YourDatabase.mdb" For you database. -- 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" wrote in message ... On Sep 29, 11:27 am, "Gina Whipp" wrote: Well, that's the first time I have herd of this because of missing Service Packs, which ones were missing? -- 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" wrote in message ... On Sep 24, 8:30 pm, "Gina Whipp" wrote: Okie dokie... -- 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" wrote in message ... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message ... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message ... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 up to 18 pages reports. I asked user to try print from MS Word whoch can 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 - ... read more »- Hide quoted text - - Show quoted text - Hi, Finally, I know what is real reason. One of the applicaiton which created by other user using MS Access run time version to run his stuff. Once users running the running version of databases then it changes the all application running using run time version. The MS Acess fixes itself when I run a full version of application without databases then change back to full version. It makes sense now that the database come back after I running. It does not appear in the task manager when it is run time version. I still have one question is that does MS Access run time version to limit pages numbers? Thanks millions for helping, |
#29
|
|||
|
|||
pages limitations
On Sep 29, 12:44*pm, "Gina Whipp" wrote:
A message to install Microsoft Access does not install any updates, it means you have more then one version running on your machine. 1. What versions of Access do you have installed? 2. What version is the database in? 3. Is this databse an .MDE? 4. What is the Make and Model of the 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 - SNIPPED- I am not sure, because I just ran the MS Access database without opening any databases and the message show to install MS Access which I beleive it updates something. It is possible to miss one but can not tell which one or MS Access just corruppted on those machines. The symptom is application title bar missing and does not show in task manager and unable to print reports which 18 pages and more, After running the MS Access, all problems are gone. Is it Microsoft magic? Thanks millions for helping, 1. 2003 2. 2000 3. Yes 4. SHARP, IBM, OKI |
#30
|
|||
|
|||
pages limitations
On Sep 29, 4:08*pm, "Gina Whipp" wrote:
I do not know why the Runtime limits the page printing. *It must be something in the code and without being to review the code... *I should also note, I have never heard of such a thing. *However, to avoid this issue, you should change the shortcut to resemble the following.. "c:\Program Files\Microsoft Office 2003\Office\msaccess.exe" "YourDriveLetter:\MainFolder\YourDatabase.mdb" For you database. -- 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" wrote in message ... On Sep 29, 11:27 am, "Gina Whipp" wrote: Well, that's the first time I have herd of this because of missing Service Packs, which ones were missing? -- 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" wrote in message .... On Sep 24, 8:30 pm, "Gina Whipp" wrote: Okie dokie... -- 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" wrote in message .... On Sep 24, 1:57 pm, "Gina Whipp" wrote: 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" wrote in message ... On Sep 24, 10:33 am, "Gina Whipp" 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/micro...texplorer.gene... http://social.technet.microsoft.com/...istaie/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" wrote in message ... On Sep 24, 9:22 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 3:34 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 2:18 pm, "Gina Whipp" 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...%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" wrote in message ... On Sep 23, 1:52 pm, "Gina Whipp" 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" wrote in message ... On Sep 23, 10:16 am, "Gina Whipp" 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" wrote in message ... On Sep 23, 12:43 am, "Gina Whipp" 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" wrote in message ... On Sep 22, 3:02 pm, S.Clark 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 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 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 ... read more »- Hide quoted text - - Show quoted text - Thanks millions for the message and help, |
Thread Tools | |
Display Modes | |
|
|