Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2005, 09:42 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default User defined size on a report page set-up

Hi experienced programmers,
How would i open a report on A2K2 using a user defined type paper?
Running A2K i easily find the option above when opening the paper
size dialog alternative which isnt available on A2K2. I'm sure there
must be a way of doing it although i've not found it.
Any help will be welcome,
rgds Penta:(

 
Old October 26th, 2005, 02:08 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've not found a solution to the topic above. Plus, after a cleanup work
of the machine running A2K i couldnt open the user defined type either
having an error message saying that the sections of the report is larger
than the size of the paper. I've set the margins of the report to zero
and the problem persists although it used to work Ok on A2K. Any suggestion
will be welcome.
Rgds P


 
Old November 5th, 2005, 12:18 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's better late than never! Above please read user defined 'size' in place of
'type'. This time the solution wasnt that simple. Why dont use a default paper
size for the report ? Answer: since the year 92 when computers where first
introduced to our business we have a document that is delivered to each employee
each month. We call it 'holerit'. It has the size 210 x 148,5 mm. So i've
worked hard to develop a report the same size of the 'holerit' with data we
belive the employee should know. At first the report was filled on a paper
four times the 'holerit', then twice, and finally the same size. Although the
data for the report was at first passed one by one employee using a VB6 application and the printer was set to pause so all the pages were printed at once. A very elementar application using the knowledge i was familiar at the time. Now i use an access application with all the resources available with A2K2. So i'm not happy to change the papersize after all these hours working on the present application that has spared 12 days of year work on the personal task in absolute time plus allowing the report to be done day by day versus in one day at the beginning of the month before the payday. To make it short, anyone interested on using user defined papersize should read Access 2002 Desktop Developer's Handbook by Paul Litwin & others, Appendix C.
Rgds P






Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB.Connection user-defined type not defined Wall st Guru Excel VBA 2 March 26th, 2014 03:44 PM
How to Set page file size to system managed Divesh4u Visual C++ 0 June 9th, 2006 01:57 AM
How to Set page file size to system managed Divesh4u Visual C++ 1 June 9th, 2006 01:46 AM
User-defined type not defined (Icecream.mdb) dloren01 BOOK: Beginning Access VBA 0 June 22nd, 2005 10:36 PM
How to set a user-defined Serial Number ? justin_min VS.NET 2002/2003 1 February 17th, 2005 07:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.