Solved

Paper Size keeps changing in Page Setup

Posted on 2004-04-09
14
922 Views
Last Modified: 2012-08-13
I have been programming in Access for 10 years. I have a Access 97 database in use at my company. The database has been working perfectly and is used by at least 20 people (concurrently) each day. We use DYMO label printers to print labels directly for the clients in the database. I use a report created in the size of the label and then send it directly to that specific printer. In the page setup I select specific printer and page size. This has been working on all 20 computer for the past 4 years.

Now here is the problem:

I just got a new computer. State of art SONY Laptop. Whenever I work on the labels they print fine on my computer, but when some else tries to print them....all screwed up.

I installed Access 97 on the other machine so I could 'look into' the database at the reports in question.

THE PAPER SIZE IS CHANGING ON THE REPORTS.  I know this has to be something with my new computer (where I compile the database) , but I have checked everything (printer drivers , etc.)

Any suggestions?

Ira
0
Comment
Question by:QuickQuote
  • 5
  • 4
  • 3
  • +1
14 Comments
 
LVL 11

Expert Comment

by:BillPowell
ID: 10795220
This is a stab in the dark but it worked for me in the same situation.  Goto Tools Options and eliminate any usage of Name Autocorrect.  Apparently its buggy and been known to change page setups spontaneously.  For me it was changing, margin settings and paper size.  Once I stopped using the Name Autocorrect, the problem mysteriously dissapeared.

Hope this helps,

Bill
0
 

Author Comment

by:QuickQuote
ID: 10796975
Bill:

I did try this previously, but no luck. I have heard this was an error in Access 2000. It's crazy but on the non-working machines, the reports seem to change to the different paper size 'consistantly'. It's not random. Which leads me to believe, is some older file (dll) that differs on that computer. Any clue as to what files Access uses to send information the windows printing sub system?

Thanks for your response,

Ira
0
 
LVL 11

Expert Comment

by:BillPowell
ID: 10797054
Im sure youve accounted for this already, but it doesnt hurt to ask:

How did you set up the reports. Sometimes if they are setup using the default printer then that might cause problems.  For instance your default printer is one that is capable of legal size prints, but your clients have default printer set to a printer that can only print to letter, then that could cause spontaneous change.
0
 

Author Comment

by:QuickQuote
ID: 10798448
I set up theses report to print to this specific printer (DYMO) which every user has installed the exact same way with exactly the same drivers.

Ira
0
 
LVL 11

Expert Comment

by:BillPowell
ID: 10799911
Im out of ideas, but will try to page some of the other guys to have a look.
0
 

Expert Comment

by:matthewsn
ID: 10804234
Had the same problem myself, only way I found out of it was to go to tools,security and remove edit rights from the report(s) in question. (Having made sure the page setup was correct first)
Not a brilliant fix but quick and dirty and it does stop it changing.
regards
Neil
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Expert Comment

by:matthewsn
ID: 10804362
Bit more info:-
Tools,Security,User & Group permissions
Choose object type Report
Select the report in the list
Uncheck 'Modify design' & 'Administer'
Click Apply
Need to do the above for User 'Admin' and Groups 'Admins' and 'Users'
Click apply after each change
0
 

Author Comment

by:QuickQuote
ID: 10804766
Neil:

I really thought (and hoped) this would work.  And while I tripled checked my work ( I am certain the permissions were turned off) the paper size still get interpreted wrong. It's almost like Access is using some internal table (to select paper size) on these computers that does not match the table on the computer the application was created on. ??

Ira
0
 

Expert Comment

by:matthewsn
ID: 10806515
It really should work, the awkward bit is to ensure you've turned off the privs for the group Admins and both the users.
Access certainly saves the page setup in the report itself.
Can you open the report in design mode, change the page settings and save them?
If you can then the security bit isn't set up right.
I'll have a rummage around and see if I find anything else
Neil
0
 

Author Comment

by:QuickQuote
ID: 10809126
I tried to work on the report and it says I don't have permission, yet it changed the paper size ?!?
0
 

Expert Comment

by:matthewsn
ID: 10811471
Something I've just come across - the problem first appeared when you got your new laptop right? - does this computer have the same regional settings as the other PC's.
If the regional setting is say English(UK) the default paper size is A4 but if it's English(US) then it's letter. This can cause page sizes/settings to be changed.
May be worth checking all the regional settings etc.
0
 

Author Comment

by:QuickQuote
ID: 10846459
All regional settings are correct. Thanks for all the help, but no luck.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11187106
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now