Liz Doering
ldoering at symphonyinfo.com
Thu Mar 16 14:07:34 CST 2006
Thanks Karen. I had had to import all objects to a new mdb recently and forgotten to turn Name Auto Correct off. It is an evil "feature" Thanks, Liz -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Thursday, March 16, 2006 12:46 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Report Setup Problem Easy. It is in the options in database; if the auto correct thingies are checked on, you are hosed. Wait until you move to A2k3 and people can't even preview or print or anything if you develop using a network printer. Those people have to connect to a bogus .pdf or lpt1 printer, then redirect to their own printer before they can do ANYTHING with reports. Sigh. Karen S. Nicholson Programmer Analyst EG&G Technical Services, Inc. Pittsburgh, PA Phone: 412-386-6649 Email: cyx5 at cdc.gov -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liz Doering Sent: Thursday, March 16, 2006 12:00 PM To: Access Developers discussion and problem solving Subject: [AccessD] Report Setup Problem I'm about to pull out all my hair. I have a nice report that has been running peaceably for years in a database we built for a client. It has 9 subreports that have also been trouble free for ages. The subreports are formatted to beautifully march down one column and then a second column. It began life in Access97, but now it is in Access2000, and I am running WinXP. Recently I borrowed it from the original client's project into a new project for a new client. As I imported it from one .mdb to the other, Access decided that 1-inch margins were more appropriate for the main report and the subreports. No problem, I think, I'll change them back to the original smaller ones. Unfortunately, I can't get Access to agree to this. I open the report in design view, change the margins--and the column settings--save and run the report. All is well. I close the report, run it again, and again, all is well. I close the report, run it again, and behold! The 1-inch margins and single column are back. I cuss and set them all again. After several attempts this is getting old. And my coworkers are getting jumpy, because I am screaming. I have set all the margins on all the subreports down. I have changed default printers. I have reimported the report and given it a new name. I have stood on my head while turning around three times and muttered several incantations. Does any one have any other suggestions? Thanks, Liz Doering Senior Developer Symphony Information Services liz at symphonyinfo.com www.symphonyinfo.com 763-391-7400 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com