Printing Labels For A Specified Record

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 Replies


ADVERTISEMENT

Queries :: Cartesian Table - Create Multiple Copies Of A Record To Use For Printing Labels

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

Problem Printing Single Labels

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

Reports :: Printing Labels On Label Printer?

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

Reports :: Printing Labels On A Template With Only 1 Column

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

Printing Labels And Reports On Different Printers Than Designed

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

Select Fields Of Table To Use When Printing Mailing Labels

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

Reports :: Print Labels In Subreport While Printing Invoices

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

Reports :: Labels Printing On Half Used Label Paper?

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

Reports :: Printing Labels - Report Producing Blank Page

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

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 3 Replies View Related

Printing Tabbed Record

Dec 3, 2004

Hi all! Going ga-ga over this, :eek: so please see if you can help!
Access 2000 by the way.
I've a really pretty form made up and it has 3 tabbed pages.Each page contains some fields which contain 'memo' data, so the entries in each field are pretty long.
When I try and print the record e.g. File->Print->Print selected record...it just
a)prints the front page/tab, as opposed to the contents of all 3 tabs
b)Truncates the data in the memo fields...it seems to just print the image of what you see when you open the form up - rather than printing the actual content of each field.
Similar thing when I try and print from datasheet view. Or from the table that the form feeds into.
What am i doing wrong? Please help! :D

View 1 Replies View Related

Printing Tabbed Record

Dec 3, 2004

Hi all! Going ga-ga over this, :eek: so please see if you can help!
Access 2000 by the way.
I've a really pretty form made up and it has 3 tabbed pages.Each page contains some fields which contain 'memo' data, so the entries in each field are pretty long.
When I try and print the record e.g. File->Print->Print selected record...it just:
a)prints the front page/tab, as opposed to the contents of all 3 tabbed pages
b)Truncates the data in the memo fields...it seems to just print the image of what you see when you open the form up - rather than printing the actual content of each field.

Similar thing happens when I try and print from datasheet view. Or from the table that the form feeds into.
What am i doing wrong? Please help! :D

View 1 Replies View Related

Printing Selected Record

Jul 15, 2005

I'd like to put a command button on a form that would run a designated report but have the option of only printing selected records. I know I could just use the File/print option using selected records but that only prints the record fields displayed in the form. I want to run a special report that formats and prints more of the records fields. The problem is how have that report print the "currently selected" record or records.

Thx.

View 4 Replies View Related

Printing Current Record

Nov 20, 2006

This could go in forms or reports, I think but:

I have a database which I am developing over time as I see ways of improving it and as I learn bits of vba. My current problem relates to invoicing (that I have probably created for myself!): I currently have two invoice report layouts because of different invoicing addresses.

I now want to add a cmd button to my invoice entry form that will firstly preview, then print the current record. I found elsewhere in the forum a way of previewing just the current record by way of specifying in the underlying qry the ClientID so that it selects the record displayed on the form.

I have this line of code which then previews the invoice:

DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview

This does not take account, though of the different invoice layouts.
I think strictly speaking I should only have one invoice report, but what I want to say is this:

If the client is a private client, then preview rptInvoicePrivate,
Else preview rptInvoiceLocumWork

I have tried entering this code that does not work

If SolicitorID = "1" Then
DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview
Else
DoCmd.OpenReport "rptInvoiceLocumWork", acViewPreview
End If

It comes back with a message that SolicitorID is not defined, but I have included Option Explicit.

Any help please

View 1 Replies View Related

Printing Only One (current) Record In A Report

Jul 19, 2007

Hi Everyone,

I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report.
Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the form. When the client clicks on the button it prints all the records ("result reports") of all the clients...no good of course.
Here's the code for the button:

Private Sub PrintSingleChamber_Click()
On Error GoTo Err_PrintSingleChamber_Click

Dim stDocName As String

stDocName = "SingleChamberPrintOut"
DoCmd.OpenReport stDocName, acNormal

Exit_PrintSingleChamber_Click:
Exit Sub

Err_PrintSingleChamber_Click:
MsgBox Err.Description
Resume Exit_PrintSingleChamber_Click

End Sub

Can someone point me in the right direction? :confused:
Thanks again,

Mark

View 1 Replies View Related

Printing The Current Record Which Has A Subform

Jan 11, 2006

Hello,

I have done a search on this forum and found all the postings relating to printing only the current record for a report. I have a command button and have followed what these posts say. The report prints the current record but leaves out the data from the subform.

The database is a recipe organizer. The main form is called Recipes and the subform contains the ingredients for each recipe. This subform is called Ingredients.

I set up a command button with the following code:

Private Sub Print_Recipe_Click()
On Error GoTo Err_Print_Recipe_Click

Dim stDocName As String

stDocName = "Family Recipes"
DoCmd.OpenReport stDocName, acNormal, , "[RecipeID] = " & Forms!RECIPES![RecipeID]

Exit_Print_Recipe_Click:
Exit Sub

Err_Print_Recipe_Click:
MsgBox Err.Description
Resume Exit_Print_Recipe_Click

End Sub

Since the RecipeID is used in both forms and the report, I thought it would be the best field to use since it linked all the information together.

So what do I need to do so that the subform data prints out on the report?

Thanks
GeekyGirl

View 3 Replies View Related

Printing Only One Record Details On Report

Jan 6, 2005

I have a form which is used for data entry for a new record only. I then wish to print some of this record's details on a report, using a command button on the form. At present I cannot filter to get just the current records details on the report - I am getting the report containing all records in the table.

Thank you

View 3 Replies View Related

Forms :: Record Time Of Printing?

Jan 7, 2014

I want a textbox on a form to record the time every record is printed. I used the codes below but it couldn't work. Am getting 'runtime error 2147352567 (80020009)'

Private Sub cs3_Click()
Dim mydate As Date
Me.hdates = Now()
DoCmd.Save acDefault
DoCmd.OpenReport "Copy of HH", acViewReport, , "[REF] = " & "'" & [ETGRef] & "'", acWindowNormal
DoCmd.PrintOut
End Sub

View 2 Replies View Related

Forms :: Printing One Record From A Form

Mar 25, 2015

So I created a form for the nursery at my church. It's set up so that they pick their child from a drop down menu (in a separate form), then a form opens up that brings up their child's information. I have a save and print button at the bottom, and I was able to set it up so that it does save the form and close it, but I can't figure out how to get it to print. I need to set it up so that the information displayed is all that is printed (not all the records like it keeps showing in print preview), and print it at a certain size (like a label). Everything I keep finding says to print from a report, but I have it set up as a form.

View 1 Replies View Related

Printing Current Record On Form And Subform

Oct 21, 2006

I currently am trying to print the current record that I have selected on my form and the subform that I have on the same page. If I try to print selected record it will only print out the main form correctly and will print out the first record on the sub form. I have tried to make a reprot of the current form and it only will do the main form and nothing from the sub form. I am willing to try whatever method would work in getting this to work. Thanks

View 2 Replies View Related

Printing A Report Based On The Current (new) Record

Nov 23, 2006

Hi All,

Having a problem with a report, I have a form that i use to enter a new record to my database, what I want to do is put a button at the bottom of the form to print the record (via a report)

If I base this on a record that already exists, it works fine.
However,
If I have just entered the record the query the report runs off doesn't see the new record. To print that record I have to exit the completed record, then go back in to it and print.
My aim is to remove this additional part of the process, I'm sure it's something really simple, but can anyone help?

Many Thanks
Paul

View 2 Replies View Related

Reports :: Printing Invoice - Record Selection

Apr 14, 2014

I am working on a volunteer organization's database, and am trying to create capacity to print an invoice for a donation pledge. I have a sub-form that displays donation records for a selected individual. From the sub-form I have created a command button with an OnClick event procedure with the following code:

DoCmd.OpenReport "Reports![RadThonInvoiceR]", acViewNormal, , "MasterID= " & Me.MasterID

ID Year Amount Status

53 2008 $200.00 Paid
53 2009 $200.00 Paid
53 2013 $200.00 Unpaid

Can I modify my Where condition so that the report selects only the most recent entry (by Year) from among the current selections?

View 8 Replies View Related

Forms :: Form Not Printing Correct Record?

Nov 7, 2014

After data is entered and exit and print is selected, it doesnt print last record in the table

View 7 Replies View Related

Forms :: Navigation Form Printing Current Record Out As PDF

May 31, 2014

I have made a navigation form that prints the current record out as a PDF and also the option to send the current record by email as a PDF. Both work perfect when you open the form outside the navigation form. But when you open it inside the navigation form, it does not print any of the information.

The problem is in the Query report, In the criteria box for field [RequsetID] it has

Code : [Forms]![FRMRequestForm]![RequestID]

(The above works outside the navigation form.)

I have also tried adding the navigation form name

Code : [Forms]![Main]![FRMRequestForm]![RequestID]

But none work.

View 4 Replies View Related

Reports :: No Data Printing - Getting Single Blank Record

Jan 17, 2014

All i want to do is to print my report (with the records ideally!) which has a subreport header at the top but all i am getting is a single blank record?!

Surely this is not too much to ask but it is holding up the whole project!!!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved