hai,
I am a new user of this site,
Hope u people guide me in successful way,
my problem is i am completely new to VBA,
recently i did a project in that we had a report, initial papersize is A4,
i suppose to change it to B4, i did it successfully at my desktop, for that used page settings, but when it is delivered reports are coming in A4,
i tried a lot at google, i came to know that we can do this by using prtDevMode,for that we need these three modules(basDevMode,basPrtDest,basStrings)
from CH10.MDB Dll in our application,
i dont know how to add modules n Dlls,
pls find some solution for my problem,
Thank you very much,
Regards,
MD shafi.
4 4171
hai,
I am a new user of this site,
Hope u people guide me in successful way,
my problem is i am completely new to VBA,
recently i did a project in that we had a report, initial papersize is A4,
i suppose to change it to B4, i did it successfully at my desktop, for that used page settings, but when it is delivered reports are coming in A4,
i tried a lot at google, i came to know that we can do this by using prtDevMode,for that we need these three modules(basDevMode,basPrtDest,basStrings)
from CH10.MDB Dll in our application,
i dont know how to add modules n Dlls,
pls find some solution for my problem,
Thank you very much,
Regards,
MD shafi.
OK..am subscribing to this thread This can be done but have to dash out now I'll return shortly and take you through it step by step very slowly given you say you are new to VBA unless of course you are answered in the meantime
Jim
hai,
I am a new user of this site,
Hope u people guide me in successful way,
my problem is i am completely new to VBA,
recently i did a project in that we had a report, initial papersize is A4,
i suppose to change it to B4, i did it successfully at my desktop, for that used page settings, but when it is delivered reports are coming in A4,
i tried a lot at google, i came to know that we can do this by using prtDevMode,for that we need these three modules(basDevMode,basPrtDest,basStrings)
from CH10.MDB Dll in our application,
i dont know how to add modules n Dlls,
pls find some solution for my problem,
Thank you very much,
Regards,
MD shafi.
Being completely new to VBA, I just wanted to let you know that you are tackling a very complex PrtDevMode Property. It is a challenging task even for someone with programming experience. You can try modifying the PaperSize Property for the Printer bound to your Report directly, namely: - Reports!<your Report Name>.Printer.PaperSize = <Constant Value>
- 'Possible Constant Values
-
acPRPS10x14
-
acPRPS11x17
-
acPRPSA3
-
acPRPSA4
-
acPRPSA4Small
-
acPRPSA5
-
acPRPSB4
-
acPRPSB5
-
acPRPSCSheet
-
acPRPSDSheet
-
acPRPSEnv10
-
acPRPSEnv11
-
acPRPSEnv12
-
acPRPSEnv14
-
acPRPSEnv9
-
acPRPSEnvB4
-
acPRPSEnvB5
-
acPRPSEnvB6
-
acPRPSEnvC3
-
acPRPSEnvC4
-
acPRPSEnvC5
-
acPRPSEnvC6
-
acPRPSEnvC65
-
acPRPSEnvDL
-
acPRPSEnvItaly
-
acPRPSEnvMonarch
-
acPRPSEnvPersonal
-
acPRPSESheet
-
acPRPSExecutive
-
acPRPSFanfoldLglGerman
-
acPRPSFanfoldStdGerman
-
acPRPSFanfoldUS
-
acPRPSFolio
-
acPRPSLedger
-
acPRPSLegal
-
acPRPSLetter
-
acPRPSLetterSmall
-
acPRPSNote
-
acPRPSQuarto
-
acPRPSStatement
-
acPRPSTabloid
-
acPRPSUser
OK..am subscribing to this thread This can be done but have to dash out now I'll return shortly and take you through it step by step very slowly given you say you are new to VBA unless of course you are answered in the meantime
Jim
ok back with you..I see you have had an answer great. If you use Access 2003 go with that answer.
But which version are you using? Because you referred to CH10.MDB and basDevMode,basPrtDest,basStrings I suspect you are earlier than 2003?
Jim
ok back with you..I see you have had an answer great. If you use Access 2003 go with that answer.
But which version are you using? Because you referred to CH10.MDB and basDevMode,basPrtDest,basStrings I suspect you are earlier than 2003?
Jim
As a PS I am on vacation as of today (off to sunny cyprus) so if you don't get a resolution you can PM me and I'll continue on return next week?
Jim
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Koontzie |
last post by:
Hello all,
I have a form in Access XP that returns all printers intalled on the
users system. The select which printer they want to print to and click
a "Next" button. The button click event...
|
by: Koontzie |
last post by:
Hello all,
I have a form in Access XP that returns all printers installed on the
user's system. They select which printer they want to print to and
click a "Next" button. The button click...
|
by: Raul |
last post by:
I need to define a papersize 8.5'', 15'.
I define it using propertysettings and papersize
collection in C# but the printer don't print when the
datas is below to 11''. My printer is HP Laserjet...
|
by: °Ë´óɽÈË |
last post by:
There is a PaperSize class in .net framework. But it has only one
constructor: public PaperSize(string name,int width,int height);
I want to create a object whose kind isn't "Customer". How shall I...
|
by: JuanCarlos Gomez |
last post by:
I am try to customize papersize on VBNET (PrintDialog, PritnDocument), but
only have access to defined Paper Size on my
Printer (FX-2180), how I can customize papersize and use it. Because all the...
|
by: Just Me |
last post by:
What's wrong with the following code?
The TempName read is valid since I just wrote it and also did a QuickWatch
to check it.
But once I set the PrinterName the count of papersizes goes to zero.
...
|
by: Just Me |
last post by:
I suppose I'd have to be extremely lucky to find someone who knows about
what I now write but I have to try.
Using PageSetupDialog and then clicking Printer and then Properties I can
select...
|
by: D Witherspoon |
last post by:
No matter what I do the default paper size is always either A3 or 11 by 8.5
..
Here is the code.
Dim dlg As DialogResult
pd.DocumentName = "Weld Image"
Dim pkPaperSize As New...
|
by: Steve |
last post by:
Hi All
Using VB.net 2008, windows forms application on Windows XP SP2
I need to set the paper size when printing to an 80mm Epson docket printer
using windows drivers
Some customers have...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |