I have an access POS application which prints receipt on a receipt printer. I do not have a specified length of the receipt as sales vary in the quantity of items . Does anyone know how I can code it so that the last text is the end of the report and the paper is cut off right there? And also the printer is connected to Parallel port so i want these print commands to go to this particular port...
I wonder whether this could be done with printer driver installed.......... If so how the page length of receipt template has to be set. the width is ofcourse limited to 3 inches but as I told u guys length is unkown.....and dont think stillwe can resolve printing to specific printer issue(having driver nstalled).
I have recently changed computers from a WindowsNT to and XP. When using the NT machine, I am able to print my Access report. However, when I hook up the XP machine and request a report from one specific database, I get the following message....this message also comes up if I try to open print preview or page setup.
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
I don't think it is a printer error as the error is occurring in this one database. I have successfully printed a test page and can open up other Access databases and print. I also tried converting the database to the 2002 format....but that did not make a difference either. There must be a setting in the database that is causing the error.....
We have an Access database that opened some cash drawers attached to the computer through USB and it is working perfectly. We have some of the cash drawers that are attached to the EPSON Receipt printer and we also want to open those Cash Drawers attached to the receipt printer. Looking for code to open the cash drawer attached to the receipt printer, Is there any command available that I could send to the receipt printer and it would open the Cash Drawer.
I have also taken the screenshot of the utility program that will show the information regarding the printer and I am very expecting to get this working soon as we have build the Microsoft Access database that would checking the cash drawer status and also open the USB cash drawers.
I've created a pretty powerful Access Database that pulls information out of some ODBC tables we have on our local server. Of course, I created the database and all the forms and reports on my work computer here. But, when I was finished, I sent that entire database out to probably 20 or 30 people in the company. On a daily basis, they run the same program from their own computer and they like to print/export/etc. the reports that are produced. However, I don't understand why those reports print our on my personal printer (the printer is on the network). If they have a default printer at their site, why wouldn't it print there? Also, I haven't included any printing macros or VBA coding. I'm tired of having 30 or 40 sheets of paper print out on my printer daily. Any suggestions?
Does anyone know if there is a way to setup a button on a form that when pressed, will print to a specific printer (that's not the default)? For example, I have one button on my form that prints 2 copies to the default printer, then I want the other button on the form to print on another department's printer.
I hope I can explain this right(and its in the right forum)....newbie....How do you distribute microsoft access 97 front-end program to several users on a network, along with printer properties for multiple printers? Any help would be greatly appreciated. Thanks :o
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?
I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.
I can't find anything in the Properties that specifies whether this prints in color or black & white.
I am currently building a database which holds information on insurance policies. Each policy holder has the option of paying their annual policy either monthly, quarterly or annually.
At this stage I won't get too in depth, but I have built a table (TblReciepts) which the User enters each receipt as they arrive.
I would like to be able to match off each receipt against the outstanding balance on a realted policy, in this instance the policyholder should give their policyno as a reference in the receipt so that is where the relationship should be.
Can anyone suggest the most effective method of allocating a recipt to the outstanding balance in the table (TBLPolicy)
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, we ran into quite a serious problem the other day whilst batch printing a large number of reports from Access 2000.
For some unknown reason the print job got interrupted part way through, resulting in a large number of reports not printing at all.
Our database uses an sql fragment to set the field 'isPrinted' to true upon sending reports to the printer. This is primarily to prevent records being printed more than once.
However, if, as above, the print job doesn't successfully complete the db still, as expected, marks the record as such. This provides us with a somewhat flase account of the status of the print job.
My question is this, is there a way in vb that Access can verify the success/failure of a print job?? Are there modules or code examples available that might help us interrogate the printer and perhaps abort on error?
I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.
I am still using Access '97 and although in the code, the default printer does revert back to what it was originally, the Default Printer status 'tick' no longer appears under Start/Settings/Printers.... Consequently, subsequent print jobs outside of Access go to another device and not my DEFAULT printer.......???
Any ideas would be gratefully appreciated.
Oh - in case I wasnt clear - I want to do this in code NOT using the Print dialog box.... !
I know I am not alone on this one, as I have seen this problem posted elsewhere before.
We have installed Access 2003 on 2 workstations in a Windows Server 2003 domain, and on both these workstations, when you mouse over the print icon in the toolbar, it reports "No Printer" and indeed, we cannot print to the network printer from Access 2003, even though a printer is installed and working.
All other Office applications print to the printer OK, its just Access that doesn't seem to find the printer.
Hello, i develope with ACCESS2003, i used the printer object : dim xxxx as printer, it works fine but when i install my program on my client PC which doesn't have ACCESS2003 but only ACCESS RUNTIME2003 i have an error (error c++ ... run-time terminates abnormaly), this PC have ACCESS2000 and when i run my base through ACCESS2000 to debug it i have an error (undefined object) on the dim instruction. I was thinking all aplication developed with A2003 was running with run-time2003, apparently no, is something missing ? Thanks in advance for any help. VINCENT
I used the code below to hide all the toolbars and then created my custom ReportToolbar so the user can print the report. All works OK; however, the PRINT button on my custom toolbar sends the report imidiately to the printer. How can I create a button that I could add to my custom toolbox which would open the dialog box that allows to choose the printer, number of pages to print, etc.. (same action as I can get by going to File->Print)?
PS> Also, is there any way to remove the drop down arrow from my custom toolbox? I disabled Customize Toolbox but the pulldown arrow still appears. I found making an MDE would take care of this, but was wondering if there was another solution.
Code used to hide toolbars:For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i
We're trying to print a barcode (characterset "3 of 9 barcode"). If we print the data starting from an Excel-document on a Dymo-printer there is no problem to "read" the barcode with a scanner. However, if we print the same data starting from an Access-database, the barcode cannot be scanned. Does anybody have a clue how to solve this ?
I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the landscape settings. If so, please tell me how. Thanks.
I have a button that I click and it gets a value from my form and opens a query linked to a report, grabs the records, populates the report, and previews the report.
What I want to do now is Run the Query, dont show it, but print it to a deisignated Printer.
1. How can I run the report, not show it, but print it?
2. How can I force a print to a specific printer on my network?
IT guy quit. New forms printer installed and unable to relate/find form or query that default printer is pointing to to change to new printer. Non programmer. Clueless. program is 10MB and database is 2.3MB searched through forms/reports/ and queries. too much **** to look at
This may take a while so please try to stay with me on this: I have set up a query and a report (using label wizard) so that I can print a label of the current record viewed in a form. This seems to work until I get to the actual printing stage.
The printer I am using is an Epson LQ-300, printing onto a continuous sheet of labels (Avery's I think. 1 across. Dimensions 1 7/16" x 4").
When I press print I get the following code at the beginning of the label: @EJL 1284.4 @EJL followed by endless blank labels. From what I can find on the net this is a driver problem but not sure how to fix it.
Also, in the label preview, should it be showing the single label as a full page report with the label text stuck in the top left? I have a similar report to print multiple labels and this also shows each label on a separate page. Doesn't seem right to me. Am I doing something wrong in the wizard set-up?
Is it possible to get Access to open the print dialogue box instead of printing direct to the default printer when using the print command from a button?
How can I setup my form print button to print to a specific printer, and then to a specific tray? We need to use different colors depending on the item we're printing. This is possible by changing the printer settings as I print each form, but I'd like a more automated way to do this. Help please. Jolene
When opening Access, the default printer changes from "Letter" to "User-Defined". The output is then unreadable. I then change it back to "Letter" and all is fine until I reopen Access with the same result. I'm using Access 2003 with a Brothers HL1440 How can I make Access leave the printer's default setting as it is?
My workstation has a default printer that only prints A4, but I have an Access 2007 file with reports that require A3.
When I open these reports they see the A4 'default' printer.
If I try to change to the A3 printer in the report page setup (in design or print preview mode) it doesn't change - it keeps the default 'A4' and/or Access crashes.
If I change my workstation default printer to
The A3 printer and then open the Access file & report it works Ok (it picks up the A3 printer as default).
Can I use VBA to set the default printer and page setup to A3 when the report opens?
