Solved

Paper Size keeps changing in Page Setup

Posted on 2004-04-09
14
937 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

912 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

17 Experts available now in Live!

Get 1:1 Help Now