p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Re: Printing loosing settings.


Message #1 by "David Chapman" <luckychap@b...> on Fri, 21 Jun 2002 08:28:54 +0930
Hi Amy,

I am very interested in your comment -
Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

I have this problem too - it is a serious nuisance which occurs at least
once per week on a database that is in use for eight hours every working
day. I am very interested in what you got got out of Microsoft in the way of
comments and fixes.

Similarely Global variables will loose there values.  It is a reason why I
can't use Access for serious small projects.

David

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, June 20, 2002 3:46 PM
To: Access
Subject: [access] Re: Printing Using Half Sheet Paper


I believe that the page settings you are seeing are actually the printer
settings being accessed by Access through the driver of the printer you
are set-up with as you Default printer. To access more of the printers
settings you can click on the Use Specific Printer box and get to more of
the actual printer settings. If your printer allows custom sizes, this is
where you would set the size up.

BEWARE: Not all printers allow for Custom Size paper. Also, you would have
to have a printer with the exact same name on each of your user's machines
or you will get an error.

Also be aware that Access 2000 is querky when it comes to page settings
and reports. Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

Anyway, good luck. (I would try for one of the more standard settings that
is close to a half-sheet size piece of paper if it is available.)

Sorry not more help,

Amy


>
Hi hello!
	Is there anyway I can print in half sheet of paper configuring
only Access instead of the printer itself?  Because I noticed that
there is a user defined option on the page setup in access but the thing
is when I choose "User Defined Size" there is no other
option where I can set the paper size :(  What's the use of putting the
user defined paper size if I can't set the paper size I
want?

Thanks,

Enzo
YahooID: onestepcloser2insanity



Message #2 by "Ian Ashton" <ian@c...> on Fri, 21 Jun 2002 08:20:22 +0100
David,

I have occasionally seen this printer problem in Access 2000, but never in
earlier versions. I should be very interested in any solution. Like any
other intermittent problem, it is exceedingly difficult to track down.


As to the other matter:

<"Similarly Global variables will lose their values">

Global variables will lose their values if you have an unhandled error where
your user has simply ignored the error message and pressed "End" on the
error message box. Many users would not think to report this. It does not
take too long to search all your code in your project for procedures and
check for error handling where appropriate.



<"It is a reason why I can't use Access for serious small projects.">

From version 2.0 onwards, I have used Access absolutely reliably on many
small projects and, once debugged, have had no problems.

Ian Ashton


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Thursday, June 20, 2002 11:59 PM
To: Access
Subject: [access] Re: Printing loosing settings.


Hi Amy,

I am very interested in your comment -
Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

I have this problem too - it is a serious nuisance which occurs at least
once per week on a database that is in use for eight hours every working
day. I am very interested in what you got got out of Microsoft in the way of
comments and fixes.

Similarely Global variables will loose there values.  It is a reason why I
can't use Access for serious small projects.

David

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, June 20, 2002 3:46 PM
To: Access
Subject: [access] Re: Printing Using Half Sheet Paper


I believe that the page settings you are seeing are actually the printer
settings being accessed by Access through the driver of the printer you
are set-up with as you Default printer. To access more of the printers
settings you can click on the Use Specific Printer box and get to more of
the actual printer settings. If your printer allows custom sizes, this is
where you would set the size up.

BEWARE: Not all printers allow for Custom Size paper. Also, you would have
to have a printer with the exact same name on each of your user's machines
or you will get an error.

Also be aware that Access 2000 is querky when it comes to page settings
and reports. Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

Anyway, good luck. (I would try for one of the more standard settings that
is close to a half-sheet size piece of paper if it is available.)

Sorry not more help,

Amy


>
Hi hello!
	Is there anyway I can print in half sheet of paper configuring
only Access instead of the printer itself?  Because I noticed that
there is a user defined option on the page setup in access but the thing
is when I choose "User Defined Size" there is no other
option where I can set the paper size :(  What's the use of putting the
user defined paper size if I can't set the paper size I
want?

Thanks,

Enzo
YahooID: onestepcloser2insanity





Message #3 by "Amy Wyatt" <amyw@c...> on Fri, 21 Jun 2002 15:28:37
Regarding the Page Setting Bug in Access 2000 Report, the Microsoft fix is 
to go into Tools -> Options -> and on the General Tab clear all check 
boxes for Name Auto Correct. This works to a certain extent but do it 
before putting the database on a machine or you will have to fix any set-
ups on the reports. However, I have done this and it still happens but 
much less often. 

One thing I did discover is that the X Close button (not the one that says 
Close) in print preview is probably the culprit. I ran into this problem 
yesterday when I was working in a new copy of Access and forgot to turn 
off Name Auto Correct. In preview the report was fine until I clicked the 
X to close it and then 'POOF' all settings were gone. If I clicked on the 
Close button in the toolbar then the settings were not lost.

Microsoft claims that on the of Service Packs corrects this but I am 
running SP-2 and it still does it sporatically.

Hope this helps you who are having the problem out.

Amy

> Hi Amy,

I am very interested in your comment -
Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

I have this problem too - it is a serious nuisance which occurs at least
once per week on a database that is in use for eight hours every working
day. I am very interested in what you got got out of Microsoft in the way 
of
comments and fixes.

Similarely Global variables will loose there values.  It is a reason why I
can't use Access for serious small projects.

David

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, June 20, 2002 3:46 PM
To: Access
Subject: [access] Re: Printing Using Half Sheet Paper


I believe that the page settings you are seeing are actually the printer
settings being accessed by Access through the driver of the printer you
are set-up with as you Default printer. To access more of the printers
settings you can click on the Use Specific Printer box and get to more of
the actual printer settings. If your printer allows custom sizes, this is
where you would set the size up.

BEWARE: Not all printers allow for Custom Size paper. Also, you would have
to have a printer with the exact same name on each of your user's machines
or you will get an error.

Also be aware that Access 2000 is querky when it comes to page settings
and reports. Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

Anyway, good luck. (I would try for one of the more standard settings that
is close to a half-sheet size piece of paper if it is available.)

Sorry not more help,

Amy


>
Hi hello!
	Is there anyway I can print in half sheet of paper configuring
only Access instead of the printer itself?  Because I noticed that
there is a user defined option on the page setup in access but the thing
is when I choose "User Defined Size" there is no other
option where I can set the paper size :(  What's the use of putting the
user defined paper size if I can't set the paper size I
want?

Thanks,

Enzo
YahooID: onestepcloser2insanity



Message #4 by "David Chapman" <luckychap@b...> on Sat, 22 Jun 2002 05:17:50 +0930
Thanks Ian,

I am still not convinced that the two problems are not related - printer
loosing it settings (as magins etc) and global variables loosing there
values.

You are very right about users not reporting problems, they tend to create
situations which we don't expect, and just don't tell us because they think
they "did something silly".

Hopefuly others will reply with there experience.

David

-----Original Message-----
From: Ian Ashton [mailto:ian@c...]
Sent: Friday, June 21, 2002 4:50 PM
To: Access
Subject: [access] Re: Printing loosing settings.


David,

I have occasionally seen this printer problem in Access 2000, but never in
earlier versions. I should be very interested in any solution. Like any
other intermittent problem, it is exceedingly difficult to track down.


As to the other matter:

<"Similarly Global variables will lose their values">

Global variables will lose their values if you have an unhandled error where
your user has simply ignored the error message and pressed "End" on the
error message box. Many users would not think to report this. It does not
take too long to search all your code in your project for procedures and
check for error handling where appropriate.



<"It is a reason why I can't use Access for serious small projects.">

From version 2.0 onwards, I have used Access absolutely reliably on many
small projects and, once debugged, have had no problems.

Ian Ashton


-----Original Message-----
From: David Chapman [mailto:luckychap@b...]
Sent: Thursday, June 20, 2002 11:59 PM
To: Access
Subject: [access] Re: Printing loosing settings.


Hi Amy,

I am very interested in your comment -
Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

I have this problem too - it is a serious nuisance which occurs at least
once per week on a database that is in use for eight hours every working
day. I am very interested in what you got got out of Microsoft in the way of
comments and fixes.

Similarely Global variables will loose there values.  It is a reason why I
can't use Access for serious small projects.

David

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, June 20, 2002 3:46 PM
To: Access
Subject: [access] Re: Printing Using Half Sheet Paper


I believe that the page settings you are seeing are actually the printer
settings being accessed by Access through the driver of the printer you
are set-up with as you Default printer. To access more of the printers
settings you can click on the Use Specific Printer box and get to more of
the actual printer settings. If your printer allows custom sizes, this is
where you would set the size up.

BEWARE: Not all printers allow for Custom Size paper. Also, you would have
to have a printer with the exact same name on each of your user's machines
or you will get an error.

Also be aware that Access 2000 is querky when it comes to page settings
and reports. Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

Anyway, good luck. (I would try for one of the more standard settings that
is close to a half-sheet size piece of paper if it is available.)

Sorry not more help,

Amy


>
Hi hello!
	Is there anyway I can print in half sheet of paper configuring
only Access instead of the printer itself?  Because I noticed that
there is a user defined option on the page setup in access but the thing
is when I choose "User Defined Size" there is no other
option where I can set the paper size :(  What's the use of putting the
user defined paper size if I can't set the paper size I
want?

Thanks,

Enzo
YahooID: onestepcloser2insanity







Message #5 by "enZo :-\)" <enzaux@g...> on Sat, 22 Jun 2002 08:01:51 +0800
	Ey thanks Amy for the idea about the "x" button.  It's been a pain in the a** for me this matter for almost 2 years :) 

Thanks,

Enzo

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Friday, June 21, 2002 3:29 PM
To: Access
Subject: [access] Re: Printing loosing settings.


Regarding the Page Setting Bug in Access 2000 Report, the Microsoft fix is 
to go into Tools -> Options -> and on the General Tab clear all check 
boxes for Name Auto Correct. This works to a certain extent but do it 
before putting the database on a machine or you will have to fix any set-
ups on the reports. However, I have done this and it still happens but 
much less often. 

One thing I did discover is that the X Close button (not the one that says 
Close) in print preview is probably the culprit. I ran into this problem 
yesterday when I was working in a new copy of Access and forgot to turn 
off Name Auto Correct. In preview the report was fine until I clicked the 
X to close it and then 'POOF' all settings were gone. If I clicked on the 
Close button in the toolbar then the settings were not lost.

Microsoft claims that on the of Service Packs corrects this but I am 
running SP-2 and it still does it sporatically.

Hope this helps you who are having the problem out.

Amy

> Hi Amy,

I am very interested in your comment -
Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

I have this problem too - it is a serious nuisance which occurs at least
once per week on a database that is in use for eight hours every working
day. I am very interested in what you got got out of Microsoft in the way 
of
comments and fixes.

Similarely Global variables will loose there values.  It is a reason why I
can't use Access for serious small projects.

David

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, June 20, 2002 3:46 PM
To: Access
Subject: [access] Re: Printing Using Half Sheet Paper


I believe that the page settings you are seeing are actually the printer
settings being accessed by Access through the driver of the printer you
are set-up with as you Default printer. To access more of the printers
settings you can click on the Use Specific Printer box and get to more of
the actual printer settings. If your printer allows custom sizes, this is
where you would set the size up.

BEWARE: Not all printers allow for Custom Size paper. Also, you would have
to have a printer with the exact same name on each of your user's machines
or you will get an error.

Also be aware that Access 2000 is querky when it comes to page settings
and reports. Every once in a while it will completely lose any settings
and revert back to the defaults. I have talked to Microsoft on this and
they gave me a fix but it has not worked so far.

Anyway, good luck. (I would try for one of the more standard settings that
is close to a half-sheet size piece of paper if it is available.)

Sorry not more help,

Amy


>
Hi hello!
	Is there anyway I can print in half sheet of paper configuring
only Access instead of the printer itself?  Because I noticed that
there is a user defined option on the page setup in access but the thing
is when I choose "User Defined Size" there is no other
option where I can set the paper size :(  What's the use of putting the
user defined paper size if I can't set the paper size I
want?

Thanks,

Enzo
YahooID: onestepcloser2insanity







  Return to Index