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 RepliesI'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 RelatedI 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].
i have a graph in access, and when i print it on a laserjet printer, all of the data and text prints. When i print the graph on a inkjet, only the text prints...not the graph. How do i solve this?
View 1 Replies View RelatedI 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. .
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 RelatedI 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?
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 RelatedI 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".
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 RelatedI 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.
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.
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.
Hi,
I have a command button that opens a report. The report has many subforms in it. I am sending open args which existingstewardship. I want one of the labels of the labels to be visible if the me.openargs = "existingstewardship". the code is not working. I have tried to debug when I do this I have found the open args are null and I am wondering if the open args are null is this because they were sent to the main report from the command button and the subforms in the main report do not get passed the open args.
Does anyone have any idea ? how I could make the box visible or not visible in subreport from the command button. The other option I have would be two different reports. Thanks PWF
1Create a report called rptCustomersByGender. The report should:
a.Print your company's name at the top of the first page only
b.Print your data labels at the top of each page
c.Group your data by gender
d.Display all the customer information in the detail section
e.The customers should display in ascending numerical order by Last Name
f.Below the list of Female customers, it should say: "Total number of Female Customers:" and then the total number of female customers should display. Do the same for the male customers
g.The page number should display at the bottom of every page
h.The list of Female and Male customers should each print starting on a separate page.
i.Make sure the report runs without producing any errors and looks professional.
I created a report and grouped it by gender but I can't do step F. creating two different labels for each group..
I have created a report to display a bill of materials (boms). The report works as I have designed. I have also figured out how to filter the report using the docmd.openreport vbasic call with filters. This works fine. I use a form to select the filtering I need in the form of 2 Listboxes populated from tables. The form opens, the report generates and displays in preview mode. What I cannot do is the change the title text (Text Label on the report Header). I would like to use the selected items in the listboxes as sources of text for these controls on the report so I can use the report over and over for different boms. ANy help would be greatly appreciated! Vbasic I hope!
View 1 Replies View RelatedI am having a problem setting the margins to print labels in access. I go to page setup and change the margin size click ok and nothing happens to the label and when I go back to page setup the margins have returned to their original values. I have already selected the label printer and labels that im using.So im baffled as to why it wont accept margin values that don't cause the label to be printed over 3 labels.
View 1 Replies View RelatedCurrently I have five separate reports setup in Access 2010 (that are running off of five separate queries). Since they have different data/fields, I was unable to combine into one query & one report.
However, I print each to PDF and then combine using Acrobat Pro. Is there a way to combine in VBA and not have to do the step using Acrobat Pro?Function PrintReports()
DoCmd.OpenReport "Program_Summary_1", acViewPreview
DoCmd.OutputTo acOutputReport, "Program_Summary_1", "PDFFormat(*.pdf)", "C:DesktopPrintFiles" & "Program_Summary_1" & ".pdf", False
DoCmd.Close acReport, "Program_Summary_1"
DoCmd.OpenReport "Program_Summary_2, acViewPreview
[code]......
I have a form that produces Year end accounts, therefore each page is totally different from one another, there are 10 reports per set of accounts.
I have created 10 buttons that out puts the desired report
Profit and Lost, Balance Sheet etc.....
What I would like now is a way to print all 10 reports with the click of a button, how can this be done...
I am making labels to stick on containers that we're shipping out. Some shipments will have only 1 container and some will have more than 1.Can I have it repeat a label if there are more than 1 container for an order?
For example:
Shipment 1 has 3 containers. The label says "3 x DM" and it will make one label.
Can I set it somehow to print that label three times? What about adding incremental text, e.g. 1 of 3, 2 of 3, 3 of 3?
I would like to remove small value datalabels in a stacked column barchat.
If you look at the image attached, the small value datalabels tend to clutter the image.
My graph is a MSGraph.Chart.8 inside a Report.
I am working with Access 2010.
Looks like the only possibility to remove the small values is to do that programmaticaly in VBA.
I would like a method that I could call with two parameters : graphname and a threshold value as of which small value datalabels are not displayed.
I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it.
This makes alignment of paragraphs tricky, especially when you are trying to insert a bold faced word into the middle of a block of text by using a separate label.
I am using Access 2000
How can I list the printers installed on the computer in a listbox? The following code list them in a message box, but I need the user to be able to select one to save it in a table. The listbox is called lstListPrinters and the table tblPrinterSelection
Code:
If Printers.Count > 0 Then
' Get count of installed printers.
strMsg = "Printers installed: " & Printers.Count & vbCrLf & vbCrLf
' Enumerate printer system properties.
For Each prtLoop In Application.Printers
[Code] .....
I have this Access application. The Incidents table was created incorrectly. apparently the design was not thought over. The Incidents table was created to store employee accidents. However, since the employee data is based in nicely normalized data, all Incident reports will have the employee's PRESENT data, instead of the Department, Cost Center, Location, etc., that the employee was at the time of the incident. I want to de-normalize the Incidents table and add the Department, Cost Center, Location, etc., that belong to the employee at the time of the incident, I have added the columns to the table, but I am having problems getting the data from the normalized tables to the Incidents table in the Click event of the AddIncident command button. I have tried to create queries, but can not get them to work. I was unable to send the mdb, but attach is the AddIncident event. In the Fields statement, I want to get a field data from another table. For example, the present Employees table, which always has the employees present info, contains the AutoNumber Key to the rest of the normalized tables, Department, Cost Center, Location, etc; I want to get the actual Department name, Cost Center number, etc, and put it in the Incidents table. The Employees table has the data I want for the time of the incident. But the employee may change Department, Cost Center, Location, etc, before his next incident. :confused:
View 4 Replies View RelatedWhat should I do? I really don't know what filter is that.
View 4 Replies View RelatedHey all, I have a problem I was hoping that someone could help me with. I am trying to add my digital signature to my report. Since I have added an activeX Control to my form which display and stores my signauture, I would like to display it on my report as well (if it apperas with the record) So I added it like any other control to the report but when it is saved it is letters and numbers, so I have to make it back into a digital signature. Can anyone help me.Thanks
View 4 Replies View Related