Hi all,
I wanted to rule out other possibilities before suggesting a memory
upgrade for a user who owns a Dell Inspiron 6000 laptop with 512 MB of
ram.
I have a report based on a parameters query. The query selects billing
records for a specified date range and for a specified staff person (as
selected on a form). The underlying table for the query/report consists
of individual billing records with an Autonumber PK ("SrvID"). The
report advances a page after each SrvID. The printer is a networked
Xerox WorkCentre.
The date of the service is printed twice on the report -- once at the
top next to the service-type (counseling, therapy, etc.) and once at
the bottom of the report next to the signature line. This is simply the
same field from the query being printed in two separate areas of the
report.
The result is maybe 60 or 70 individual Progress Notes for a particular
staff person can be printed as a batch, rather than having to go
through the print process 60 or 70 times.
This procedure works without any problems on all the desktop computers.
It also works fine on certain laptops, including an older Acer
Travelmate which has only 128 MB of ram.
The specific problem that it is occuring on the Dell is that the date
at the bottom of the page does not always match the date at the top of
the page. For a "batch" spanning one calendar day, these two "dates"
consistently match -- as they should, since it's simply the same field
from the underlying query being printed in two separate areas of the
report. When the "batch" printed by the Dell spans multiple calendar
days, however, the results are quite inconsistent. Sometimes the two
"dates" match, but about 3/4 of the time the date by the signature line
at the bottom of the page does not match the date at the top of the
page. Sometimes it's a day or so earlier than the date at the top,
sometimes it's a day or so later than the one at the top. This type of
error can occur even when there's only 5 or 6 total Notes to be
printed. That is, the query doesn't have to produce a large number of
records for this error to occur. If the Progress Notes (or any other
reports) are printed "manually", that is, one-at-a-time by the Dell
laptop, there is no problem.
My question is, does anyone think that 512 MB of ram on the Dell
Inspiron 6000, with the wide screen etc., could simply be insufficient
to run this process accurately and consistently? The database
References all seem fine, and there's no indication of any other
problems running the database on this laptop.
Thanks for any insight or suggestions.
Mark
I wanted to rule out other possibilities before suggesting a memory
upgrade for a user who owns a Dell Inspiron 6000 laptop with 512 MB of
ram.
I have a report based on a parameters query. The query selects billing
records for a specified date range and for a specified staff person (as
selected on a form). The underlying table for the query/report consists
of individual billing records with an Autonumber PK ("SrvID"). The
report advances a page after each SrvID. The printer is a networked
Xerox WorkCentre.
The date of the service is printed twice on the report -- once at the
top next to the service-type (counseling, therapy, etc.) and once at
the bottom of the report next to the signature line. This is simply the
same field from the query being printed in two separate areas of the
report.
The result is maybe 60 or 70 individual Progress Notes for a particular
staff person can be printed as a batch, rather than having to go
through the print process 60 or 70 times.
This procedure works without any problems on all the desktop computers.
It also works fine on certain laptops, including an older Acer
Travelmate which has only 128 MB of ram.
The specific problem that it is occuring on the Dell is that the date
at the bottom of the page does not always match the date at the top of
the page. For a "batch" spanning one calendar day, these two "dates"
consistently match -- as they should, since it's simply the same field
from the underlying query being printed in two separate areas of the
report. When the "batch" printed by the Dell spans multiple calendar
days, however, the results are quite inconsistent. Sometimes the two
"dates" match, but about 3/4 of the time the date by the signature line
at the bottom of the page does not match the date at the top of the
page. Sometimes it's a day or so earlier than the date at the top,
sometimes it's a day or so later than the one at the top. This type of
error can occur even when there's only 5 or 6 total Notes to be
printed. That is, the query doesn't have to produce a large number of
records for this error to occur. If the Progress Notes (or any other
reports) are printed "manually", that is, one-at-a-time by the Dell
laptop, there is no problem.
My question is, does anyone think that 512 MB of ram on the Dell
Inspiron 6000, with the wide screen etc., could simply be insufficient
to run this process accurately and consistently? The database
References all seem fine, and there's no indication of any other
problems running the database on this laptop.
Thanks for any insight or suggestions.
Mark
Comment