A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

pages limitations



 
 
Thread Tools Display Modes
  #41  
Old October 7th, 2009, 02:06 AM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old November 12th, 2009, 04:38 PM posted to microsoft.public.access.reports
iccsi
external usenet poster
 
Posts: 139
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.