View Single Post
  #24  
Old September 29th, 2009, 04:27 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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
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
print
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,