Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Paper Size keeps changing in Page Setup

Posted on 2004-04-09
14
Medium Priority
?
990 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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
 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

972 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