A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report - Label size and margins



 
 
Thread Tools Display Modes
  #1  
Old March 24th, 2010, 02:30 AM posted to microsoft.public.access.reports
justin
external usenet poster
 
Posts: 217
Default Report - Label size and margins

I have a SQL database with an Access front end. I'm using Access 2002 SP2.
The front end contains many differnet labels. Each uses a different label
size ( 2.25"X1.25", 2.25"X4.00",..). Luckly the different labels size each
have a dedicated printer. I having an issue with multiple work stations. I
will set-up the font end for a certain printer, but users who have a
different printer need to manually set-up the label each time a push out a
new revision of the front end. I'm looking for a way I can set-up the
printer, label size and margins using VB. I can generate the printers set-up
on the pc and compare it to a master list to determine what label size it
should be. I've tried the following code, but it just displays the default
printer.

DoCmd.OpenReport "rptMyLabel", acViewPreview, , , acHidden

Reports("rptMyLabel").Printer = Application.Printers(pVar)
Reports("rptMyLabel").Printer.DefaultSize = False
Reports("rptMyLabell").Printer.ItemSizeWidth = plVar
Reports("rptMyLabel").Printer.ItemSizeHeight = phVar
Reports("rptMyLabel").Printer.BottomMargin = 0
Reports("rrptMyLabel").Printer.TopMargin = 0
Reports("rptMyLabel").Printer.LeftMargin = 0
Reports("rptMyLabel").Printer.RightMargin = 0

DoCmd.OpenReport "rptMyLabel", acViewPreview

Any assistance or direction will be most appreciated.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.