Reports :: Printing Address Labels - Column Height And Row Spacing Linked Together?
Feb 3, 2014
I have to print address labels. 10 x 3.8 cm labels 2 per row 14 per page on an A4 paper. Pretty straightforward one should say. But no. I play around with the margins, column heights and widths, row and column spacing page size wasting time. Is there a hidden and not documented relationship between those elements? For example how is the column height and row spacing linked together? How is this normally done in a professional way?
View Replies
ADVERTISEMENT
Dec 9, 2013
I currently have a set of labels that works flawlessly - it has 2 columns and 20 rows. I have a form that I can select which label to start printing on so I use up a full sheet with no waste. [working labels attachment]
The labels I'm trying to print on now are 1.25" x 10", as seen HERE. Since I cannot rotate the whole report 90 degrees, I set up the labels to have one column with six rows instead of 6 columns with one row (landscape instead of portrait).
I copied the entire label printing process from the known working report. For my new set of labels, the label prints great if I have just one record, and/or I start at label #1. If I want to start at label #6, it just prints slightly lower on the page instead of at label #6 position (which is the bottom of the page). [label at #6 position attachment].
View 5 Replies
View Related
Jun 11, 2013
I've created labels in my database and when I print them on a label printer, I get a blank label in between my printed labels. I've checked the printer settings and properties and can't find anything. I've also checked the database properties and can't find anything. Is there something in the database that I'm missing?
View 6 Replies
View Related
Oct 18, 2011
I have a small receiving inspection database that prints lables for each item received. However when they use the program on a different computer the lables do not print on the lable printer at that location.
View 1 Replies
View Related
Jul 22, 2014
I am printing invoices and need to print the label in a subreport at the end of each customer only once. This is what I want it to look like:
2014 payments applied to cap: GA $8,078.00
NC $1463.00
SC $155.00
NOT
2014 payments applied to cap: GA $8078.00
2014 payments applied to cap: NC $1463.00
2014 payments applied to cap: SC $155.00
I use ACCESS, but I do not know SQL. .
View 5 Replies
View Related
Jun 10, 2013
I have a report that should print on labels ready to be stick on a book, but how can I tell the report to start from 3th row 2nd column so I do not waste any labels?
View 4 Replies
View Related
Aug 13, 2015
I have a non standard size report (for printing labels)
The report is just over 10cm wide and just over 15cm deep.
I have solved the blank pages caused by exceeding the width but I'm still getting a blank page when I move some data down. I am still within 15 cm but it's throwing me a blank page. Even if I extend the in design mode depth to say 20cm (ie the height in Detail) it's throwing a blank page (I can see this in print preview).
I initially set up the report (it's a long time ago so memory fades) using the label wizard setting up a label 4*6 inches (10.16 * 15.24 cms) and it is this i'm trying to tweak. Is there a property I'm missing somewhere?
View 5 Replies
View Related
Jan 7, 2014
I have a main form with a subform. The subform has linked tables from the main form. People are on the main form with the index PersonId and they are linked to incidents by IncidentId.
I want to put in two buttons.
First put a print report button for each subform whereby it will only produce a report for the records I can see on screen . i.e. if a person is linked to two incidents I just want the report for those two incidents.
Secondly I would also like a print all button on the subform where it prints reports containing the current IncidentId number.
View 2 Replies
View Related
Nov 13, 2014
I have a report that fits nicely onto one A4 page.
Then I had to add an ID column to be able to sort by ID (would not sort by ID unless I added the column to contain the record ID numbers, even though the query on which the report is based is sorted by ID).
Because I added another column (on the right hand side) to contain the ID column, it's gone over the A4 size and so prints a second page with the ID column on it.
So I hid the ID column, but a second page still prints, just with nothing on it.
I don't want to shrink any of the columns to make the ID column fit as the report is crowded already.
I tried setting the ID column header and content to Display When: Screen Only, but that doesn't work, it still prints the second blank page.
How can I stop that second page printing? I don't want to just print page one as sometimes the report is more than one page of data.
In Excel you can set the print area. Is there a similar setting in Access? I can't find one.
View 2 Replies
View Related
Aug 27, 2012
Is there an easy way to make a full page address labels (30 to a sheet) without having to create it by dimensions? I can't seem to get all the dimensions correct.
View 14 Replies
View Related
Dec 24, 2005
I am very experienced in Word and Excel but completely new to Access.
I have constructed an Access database containing a list of volunteers and the times at which they have volunteered.
The Reports I have written are very basic but function as intended. http://www.access-programmers.co.uk/forums/images/smilies/smile.gif
:)
However the lines of data on the Report print outs are spaced too widely. http://www.access-programmers.co.uk/forums/images/smilies/confused.gif
:confused:
How can I specify the line spacing?
View 1 Replies
View Related
Dec 28, 2007
PROBLEM: String Manipulation
"Cleaning up Mom's Christmas address labels"
I need guidance on the best string manipulation functions (Instr, Left, Right) to cleanup my mother's Christmas address list of 300+ names.
I have successfully imported the text file into Excel and exported to Access; fieldnames: FULLNAME, ADDRESS, CITYSTATEZIP
I have found instructions on how to breakout FULLNAME field into FIRSTNAME and LASTNAME.
But within the FULLNAME field are many combinations of titles (Mr., Mr. & Mrs., Dr., HON.) with inconsistent periods applied.
Which one of string manipulation functions:
Instr
Left
Right
would be best for extracting these various titles from this name field?
I understand the concepts behind the above functions, but not enough experience using them to understand the tedious syntax or which string manipulation function would be best for extracting the varying title entries to a separate created field called TITLES.
So far, I have deduced this will be a multi-step process. But asking for guidance:
1.) Which string function is best suited for this?
2.) Example of the function syntax for an update query?
2.) Suggested order to administer update queries?...
to extract misc titles from the FULLNAME field.
I am a novice-casual Access user.
Thanks, Greg
(If someone would copyright these steps into a book called "Cleaning Up Mom's Christmas Address List"... I am sure they could retire from sales on Amazon. :-)
View 14 Replies
View Related
Dec 4, 2012
My database contains business names and addresses in separate fields (name, address, city, zip code, state, country)
Now I have to build the address block for labels.
If there were just US addresses it would be easy but a business can be located in any country with the problem being
that countries require the block to be build in a specific way (order of city, state, zip code).
In some cases a particular section has to be upper case as well.
Of course I can build it manually in a memo field but the with chance of something easily going wrong I like to automate it.
It does mean the same info will be stored twice which is basically a no no.
I'm thinking of making a separate table with records for all possible layouts and use those as a source for a memo field in the business table. However I can't oversee if that would work alright or not.
Or should there be a way to generate the blocks on the fly?
View 9 Replies
View Related
Jul 16, 2013
I have a sub-report and the last row is highlight, however, there seems to be extra spacing after the last row. I removed all report/page header/footer so all what's left is the Detail section but I still have this white space after the last row.
View 5 Replies
View Related
Feb 11, 2015
I am trying to generate standard Avery 2160 address labels. Fonts are small enough to allow for up to 4 print lines none of which quite touch. Players have entered their own names and addresses via a website form, so I we never quite know what is in the fields. If the player has a foreign address, it will all be entered in the address field, whereas US addresses have 1 or 2 lines in the address field, and city, state and zip in their respective fields. Line 1 is set as name, no shrink or grow. Line 2 is set as address, shrink and grow set to yes, and line 3 (text4) is set for city & state & zip, concatenated and trimmed in the query, shrink and grow no. The detail OnPrint event is the following:
Code:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.Text4.Visible = False
If Len(Text4 & vbNullString) > 1 Then
Me.Text4.Visible = True
End If
End Sub
The problem: Any row containing at least one label with 4 print lines pushes the next entire row of three labels down one line, throwing off the spacing of the labels. If I set line 3's can shrink to yes, then the label following the four-line label never has its text4.visible turned to yes, and the other problem (pushing next row down one line) persists. These labels were originally set up via the labels wizard (Access 2010).
How can I keep it from overflowing from one label to push down the next line? This just shouldn't be this hard!
View 2 Replies
View Related
Jun 27, 2014
So I have the following query which works perfectly (and will be use to create a report) but when the query runs to create the report I also want it to mail merge some of the items into word to be used on address labels.
Code:
SELECT Dunmow.Date, Dunmow.Undeliverable, Dunmow.Duplicate, Dunmow.[OTM with XXXXXX], Dunmow.[Landlords Salutation], Dunmow.[LL Address 1], Dunmow.[LL Address 2], Dunmow.[LL Address 3], Dunmow.[LL Address 4], Dunmow.[LL Address 5], Dunmow.[LL Postcode], Dunmow.[Letter 1], Dunmow.[Letter 2], Dunmow.[Letter 3], Dunmow.[Letter 4], Dunmow.[Letter 5], Dunmow.[Letter 6], Dunmow.[Letter 7], Dunmow.[Letter 8]
FROM Dunmow
WHERE (((Dunmow.Date)=DateAdd("d",-7,Date())) AND ((Dunmow.Undeliverable)=False) AND ((Dunmow.Duplicate)=False) AND ((Dunmow.[OTM with XXXXXX])=False) AND ((Dunmow.[Letter 1])=False));
So thats my query, What I want it to do is to take the following
[Landlords Salutation]
[LL Address 1]
[LL Address 2]
[LL Address 3]
[LL Address 4]
[LL Address 5]
[LL Postcode]
and use it for a merge item to create the labels required.
I have a standard word document/label document I wish to paste this into.
View 3 Replies
View Related
Jul 24, 2014
I am looking to set up a database where I have a table of records that correspond labels to product numbers. The product numbers may have anywhere from 1 to 30 labels that correspond to them, and I want the user to have a form where they search by a product number and then the labels that correspond to that product number are printed out on an Avery label.
Here is how the main data table will look: (everything is simply arbitrary to illustrate)
For example: If I type in "1111" into the form - the labels that print would be AA, AB, AC, AD, & AE
I know how to set up labels to print using forms, but the only way I can think of this working is by looking up the product number in the table, then copying the row of labels into another table (let's call it "labels to print") and pasting them in a column, then printing to the labels, and clearing the "labels to print" table for the next time.
Is this the correct route to go? If so, how do I go about looking up the product number in the main table and copy them to the "labels to print table".
View 6 Replies
View Related
Dec 6, 2004
Hello everyone! I'm trying to print a single label to a Zebra printer, but I have ran into a small problem. I'm using a checkbox to select the records and a query to catch the record I want printed as a label. I print the label and deselect the record I printed and all works fine. I print the next record and the previous record prints on top the current record. If I turn off the printer in between printing labels all works fine. Any help would be a great because I going to wear out the on/off button on my printer
View 3 Replies
View Related
Jan 2, 2008
I have a table that contains a lot of different information regarding to mailing.
There are columns for Name, Address, Address2, Address 3, City, State, Zip, Country, Base Name, etc.
Some units will only required parts of the above information. I'm using the Name as an identifier in the DB only and Address is the beginning of content that I want to use.
My issue stems out of the fact that the City, State, and Country are not always required but the Base Name, may be used in lieu of the City.
I was looking at making checkboxes next to each of the columns on the form on the field and then using those checkboxes somehow to create a report for Mailing Labels.
I'm just not sure how to set this up.
View 5 Replies
View Related
May 7, 2008
Hi,
When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So, I have to make it flexiable change of the height of the popup form.
How can I check the screen/window height by VBA function?
In Excel, it has Application.Height to check. In MS Access Form, I cannot find one for doing that.
Please let me know if you have one.
Thanks.
View 1 Replies
View Related
Aug 5, 2013
I am using a cartesian query to create multiple copies of a record to use for printing labels.
Here's my query that produces the cartesian result:
SELECT tblCount.CountID, tblDeliveryOrders.DeliveryOrderNum, CurrentCY.Deliveryorderlineitemnum, CurrentCY.Quant, CurrentCY.UOM1, tblContainerSizeCodes.SizeCode, tblContainerTypeCodes.TypeCode, CurrentCY.WasteDescription, tblEtidDodaac.EtidDodaac, CurrentCY.ETIDDocNum, CurrentCY.Pounds, tblEPAWasteCodes.[EPAWasteCodes(1B)]
[Code] ....
This works just fine in creating the desired result - EXCEPT I don't get all the records.
When I remove the 'cartesian table', and right join everything, then I get the correct results. If I keep everything as-is and reintroduce the cartesian table, then I get an error about there being an ambiguous outer join.
View 3 Replies
View Related
Jun 11, 2013
I have an existing report with a number of fields arranged horizontally in a tabular fashion in the detail section. The first field is an identifying line of text and the remaining fields are numerical calculations. The report is basically a simple profitability estimate report for a number of different products.
Behind the fields of data is another text box that is blank, which stretches across all the horizontal fields, and which changes background color using conditional formatting. When printing, this colors the whole row according to that criteria (it changes color based on the relative profitability of each product in the report).
The problem I'm having is that the first line of identifying text can sometimes overflow.
I've set the Can Grow property to Yes for this and all other controls in the Detail section. But the result is sometimes some funny-looking formatting. The identifier (like "Product XYZ with a really long description") will word-wrap, but every other field in that row maintains their own height. In particular, this makes the coloring of the conditionally formatted row look off, because it provides only one line's worth of color, even though the product description has wrapped to two lines.
How I can resize all the controls in the Detail section based on the height of the tallest control, and keep the whole thing dynamic?
Things I've tried: I've tried putting some VBA in either the OnFormat or the OnPrint events that iterates through the controls in the section and resets their heights. In the "OnFormat" event, nothing happens (no errors and no apparent changes in the appearance of the report). In the "OnPrint" event, I get an error that says the height property cannot be changed during a print or print preview.
The VBA I tried using was as follows:
Code:
Dim ctlIt As Control
Dim lngMaxHeight As Long
For Each ctlIt In Me.Controls
If ctlIt.ControlType = acTextBox Then
[Code] ....
View 1 Replies
View Related
Feb 25, 2014
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code:
PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
View 1 Replies
View Related
Sep 18, 2014
I have a report which will be printed on preprinted paper. On this paper a footer is printed with e.g. address info.
The report has a detail section with a height of 3,5 inch and canGrow=true.
The reportFooter contains totals. The size of this footer, and placements of the fields prevents printing data on the pre-printed footer of the paper.
But when the report has multiple pages, the report footer will be printed on the laste page, and the detail section is expanding to the bottom of the paper, overwriting the pre-printed footer. I need a max height of the detail section, or another solution.
View 3 Replies
View Related
Aug 18, 2014
I have a report that prints lab tests. One section has 4 columns that are framed. Only the first control (STest) expands to more than one line. The Can Grow works on this control and subsequently the section expands. I need a code that expands the height of the other three controls to match that of STest. I am using office 2010.
View 11 Replies
View Related
Sep 6, 2013
How to fix the height and width of a report. I would like the report to stay landscape, 100mm wide, 62mm high. This is required by a label printer.
The issue is that a A4 laser printer has to be set as default (for other software) so when the report is launched the size is set to the default printer size, when I select the label printer it fails as it is the wrong size.
View 1 Replies
View Related
