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 |
#41
|
|||
|
|||
pages limitations
I am stumped at this point... All I can hope is that someone will come
along and have a solution not thought of. -- 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 Oct 2, 12:32 pm, "Gina Whipp" wrote: Well, not sure what else I can do... will look around to see if anything can explain this. By the way, what is too big? Have you tried zipping 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 Oct 1, 12:31 pm, "Gina Whipp" wrote: inungh, That should not be the problem as there are MANY installs with Runtime and Full Version. Is it possible for you to send this database to me? -- 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 30, 10:18 pm, "Gina Whipp" wrote: Okay, will wait for that... -- 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 30, 11:18 am, "Gina Whipp" wrote: Unfortunately, no I don't have a list... If I understand you correctly, the report runs past 18 pages in the full version? If that is true... then you are going to have review the code OR post it here perhaps someone (maybe me) can find what is causing the report to stop at page 18. -- 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, 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 ... read more »- Hide quoted text - - Show quoted text - Thanks for asking, It links to 11 backend mdb and databases have more than 400 M data. The report has 20 sub reports and using dynamic columns. there are many code in the report to get record source. Even I can send you the database, there is so many enviroment to setup to test. I can do is to put show message on the code and to see which line of code freeze and look form there, since I am unable to set breakpoint on the run time version and full version does not have any probelm. Thanks millions again, |
#42
|
|||
|
|||
pages limitations
On Oct 6, 8:06*pm, "Gina Whipp" wrote:
I am stumped at this point... *All I can hope is that someone will come along and have a solution not thought of. -- 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 Oct 2, 12:32 pm, "Gina Whipp" wrote: Well, not sure what else I can do... will look around to see if anything can explain this. By the way, what is too big? Have you tried zipping 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 Oct 1, 12:31 pm, "Gina Whipp" wrote: inungh, That should not be the problem as there are MANY installs with Runtime and Full Version. Is it possible for you to send this database to me? -- 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 30, 10:18 pm, "Gina Whipp" wrote: Okay, will wait for that... -- 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 30, 11:18 am, "Gina Whipp" wrote: Unfortunately, no I don't have a list... If I understand you correctly, the report runs past 18 pages in the full version? If that is true... then you are going to have review the code OR post it here perhaps someone (maybe me) can find what is causing the report to stop at page 18. -- 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, 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 ... read more »- Hide quoted text - - Show quoted text - Hi Gina, I tried to put many msgbox in the all reports to see which line of code make application freeze and reralized that MS Access runtime version in an end less loop to call PageHeaderFormat when the reports has more than 15 pages, no matter which reports. The code continues in Full version and run time version which report has 14 pages and less. In MS Access Run Time version when the report has more than 15 pages, it runs PageHeaderFormat in endless loop. If you have a chance that you may try the same thing to see can you duplicate samething. Thanks millions again, |
Thread Tools | |
Display Modes | |
|
|