?
Solved

VB6(SP3) Report Designer problem.

Posted on 2004-11-25
9
Medium Priority
?
450 Views
Last Modified: 2008-01-09
I have tried to get the report I'm working on to utilize the full page (8.5 x 11).  Specifically labels 3 across and 10 down.  Each label is 3780 twips wide by 1440 twips high with 225 twips separating each horizontally and no separation vertically.  There is a 720 twip margin at the top and bottom of the page.  I have set top and bottom margins to 720, and left and right margins to 0.  I have set the orientation to Portrait.  When the report prints, "they've" added 720 twips to the left side of the report and my labels are all shifted by that amount.
0
Comment
Question by:Mike_Tuggle
  • 5
  • 4
9 Comments
 
LVL 16

Expert Comment

by:jimbobmcgee
ID: 12680392
Does the left margin actually increment by 720?  If not, the gutter may be due to the printable area of your printer.

J.
0
 

Author Comment

by:Mike_Tuggle
ID: 12691377
The left margin value was 0 when I submitted the report to be created, still 0 when the report was displayed in the Report Designer window, and 0 when control returned to the calling program.

I have created a test report using Access' report writer and it doesn't have this problem (both using the same printer).
0
 
LVL 16

Expert Comment

by:jimbobmcgee
ID: 12704371
Does the same error occur if you, say, print to PDF using Acrobat or CutePDF drivers?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Mike_Tuggle
ID: 12710148
Now you have exceeded my knowledge and capabilities with this language.  Can you give me a "quck" hint on how I would go about trying this?  I searched the Knowledgebase but didn't locate how to "print to" anything other than a file or html format.  I tried to simply print to a file with a .pdf extension but Acrobat didn't recognize the format when I tried to open it.  That was probably too simple.
0
 
LVL 16

Expert Comment

by:jimbobmcgee
ID: 12710711
If you go to http://www.cutepdf.com, you'll find a freeware driver that acts like a printer but writes to PDF.  I only ask because I wonder if the same error occurs on something that. by rights, _shouldn't_ necessarily have a margin...

Just an idea, to start with.  If it doesn't shift on the PDF, it might be the printer (or VB's command of the printer) itself...
0
 

Author Comment

by:Mike_Tuggle
ID: 12735485
Before I go to this amount of trouble, remember that I did successfully print to the printer without the added left margin using the report writer in Access.  I'm guessing that this is a VB Report Designer issue and I may be forced to work around it.
0
 
LVL 16

Expert Comment

by:jimbobmcgee
ID: 12752940
I expect you're right but I can't recreate the error myself.  I'm just trying to reduce all the options

    Step 1: See if it works for a different device;
    Step 2: See if there's something missed in the code that is indenting the display;
    Step n: Work around it, scaling everything down to account for it...

But I'm sure you've already thought of these...

J.
0
 

Author Comment

by:Mike_Tuggle
ID: 12774713
I did Steps 1, 2, & n.  No change.  I'd be happy to send you my rpt file.  It has one field in it.  As it stands right now, I'm going with the work-around.  

Just one last question and then I'll close this question.

I am running VB6 (SP3).  I applied Service Pack 5 and it was consistently blowing up so I re-installed from my original CD and then applied SP3.  I'm a bit confused on the downloads available.  There is a vs6sp6.exe (3/29/2004) and a vb6sp6B.exe (3/29/2004) and, under vbRun60sp6.exe a file named VB6.0-KB290887-x86.exe is downloaded.  Should I be upgrading to one or more of these and, if so, is there an order that I should be doing it in?

Maybe upgrading will solve my problem.
0
 
LVL 16

Accepted Solution

by:
jimbobmcgee earned 1500 total points
ID: 12779473
At a guess, you could use vs6spd if you have Visual Studio 6, or vb6sp6 if you just want to upgrade VB6.  I would download the newest VB6 runtimes, too...

I haven't had a problem with SP6, myself.  But then again, I've never had a problem with SP3, either...

J.
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

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month17 days, 8 hours left to enroll

829 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