Error Printing A Access Report To An Epson Printer

Jun 14, 2005

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.....

Does anyone have any suggestions???

View Replies


ADVERTISEMENT

Printing Receipts On POS Printer-Epson

Apr 17, 2007

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).

thanks

View 4 Replies View Related

Reports :: Access 2007 - Report Printing Black And White On Color Printer

Jan 21, 2014

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.

How to print this in color?

View 5 Replies View Related

Modules & VBA :: Open Cash Drawers Attached To Receipt Printer EPSON T-20

Mar 24, 2014

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.

View 6 Replies View Related

Reports Printing To My Own Printer

Jan 10, 2008

Good morning,

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?

View 3 Replies View Related

Printing To Specific Printer

Apr 20, 2004

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.

Thanks!

View 4 Replies View Related

Printing/printer Properties Distribution Issue.....

Nov 7, 2005

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

View 1 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

General :: Memory Error When Printing Report

Dec 5, 2014

I am getting an error message when printing a 2 part report. It does not appear until I have already printed the first part and I am ready to print the second. I have 6 users and all seem to experience intermittently with the exception of 1 who it is constant. The message is as follows;

"There isn't enough memory to update the display. Close unneeded programs and try again."I have tried deleting the registry "KEY_ CURRENT_ USER SoftwareMicrosoftVBA" with no avail and have installed all available updates from MS.

View 3 Replies View Related

Printing Report To PDF In Access

Oct 22, 2015

I have an Access Database installed on a server that is accessed remotely by numerous users. I have a button to print out a specific report. The problem is that in order for a user to print the report their print driver must be loaded on the server. Due to the number of users, and the numerous types of printers available, this is impractical. The current code on the button is currently:

Private Sub Command PrintReport Click()
Dim strWhere As String
strWhere ="[Property Number] = " & Me.[Property Number]
DoCmd.OpenReport "RESERVE REQUIREMENT REPORT", acViewNormal, ,strWhere
End Sub

I would like to know if there is some code that would send the report to PDF, so that any remote user could then print the report from PDF.

View 2 Replies View Related

Margin Error When Printing Reports In Access 2007

Apr 25, 2012

I am receiving the following error when printing different reports to several different printers in Access 2007: "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank. For example, the report width may be wider than the page width." According to my co-workers this issue began immediately following the upgrade to version 2007 from 2003.

View 1 Replies View Related

Printing Sequence Of Access Report

Sep 6, 2004

Hi,

I have 2 single-page Access reports. The first report has the following fields:
FirstName, LastName, StreetName, HomeNumber. The second report has the following fields:
MerchantA, MerchantB, MerchantC.

The data for the first report are taken from tblBuyers, the data for the second report are taken from tblMerchandise.

I need to print 2 copies of the first report and 4 copies of the second report for the first Buyer, then 2 copies of the first report and 4 copies of the second report for the second Buyer and so on. Can I help on this problem ?
Rgds

View 1 Replies View Related

How To View Access Report Before Printing It

Aug 20, 2014

I have an Access program that prints various reports with a button.I would like to view the report in full screen prior to printing, how do you do this?

View 6 Replies View Related

Reports :: Access Report Only Printing Some Image Files

Apr 20, 2015

I am running Access 2013. I have created a report where the tables are linked to a SQL DB

I am trying to run a sales report that includes an stored image.

I am adding an Image and then using the control source to look up the 'filepath' stored in the DB. When I run the report on screen all the images are showing but when I try to print it (including exporting to PDF or XPS) and Print Preview only 2 of the 9 images print per page. The images are around 2-4 Mb.

I'm guessing its to do with the files sizes but cannot do anything about the size.

View 1 Replies View Related

Printer Object Error Need Some Help.thx

Sep 9, 2006

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

View 1 Replies View Related

Run Report Force Printer

Apr 3, 2008

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?


Thanks..

View 12 Replies View Related

Reports :: Unbound Report - Print Preview OK But None Of Fields Print When Report Directly Send To Printer

May 25, 2013

I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:

Code:
Me.txtAddrMainLine2 = "NAME " & UCase([Forms]![frm_OrderRx].[txtPatientName])

This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.

I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.

View 3 Replies View Related

Reports :: Possible To Change The Default Printer For The Report?

Sep 18, 2014

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?

View 2 Replies View Related

Reports :: Can Report / Printer Margins Be Changed At Runtime

Nov 10, 2013

Access 2007 RUNTIME.I have 2 different printers, 1 for invoices A5 & one for general use A4.

I use

[URL]

and can change printers & some stuff but can't change margins.

Is there a way to change these margins via VBA that can be set in RUNTIME.

Like now, I have just had thousands of invoices pre-printed layout but the company managed to move the margin 5mm over so I have to program my MDB reports to reflect that.

View 3 Replies View Related

Modules & VBA :: Can Send A Report Directly To Printer From Code

May 19, 2014

Can you send a report directly to the printer? We have Clients with multiple Contact Notes, by multiple Clinicians, each of these are separate tables. Every month we print two reports for each client that had at least one contact in that date-range. Usually 200 clients, takes a lot of time. My approach so far is a query within a make-table query to get a list of unique client ID's that had one contact in the date-range. Then I use that table in code to create a recordset, use a Do Loop within that where I print the two reports for the 1st client, move to next record and loop. Now that I've got it working I'm not sure how to print all the reports My 1st question, can you send a report directly to the printer from code? The printer is a networked Konica Minolta Biz-hub so I think it can handle that many jobs being queued that fast.

View 4 Replies View Related

Forms :: Added A Print Button To Form To Send Report To Printer

Feb 10, 2014

I have a project which produces a report of names, addresses, etc. I added a print button to the form to send the report to the printer. The code is as follows:

Private Sub Command32_Click()
Docmd.SetWarnings False
'Docmd.OpenReport "rptAddresses", acViewNormal
Docmd.RunCommand acCmdPrint
Docmd.SetWarnings True
End Sub

Both alternatives in the code produce the same result described following.However, the printed report includes only the first 2 colums of about 10 of the 90 plus records. If I send to to a PDF, it works fine. If I do a print view on the screen ir looks fine.

View 1 Replies View Related

No Printer In Access 2003

Jul 4, 2005

Hi All,

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.

Has anyone come across a fix for this problem?

Cheers,

Alan

View 2 Replies View Related

Connect MS Access With Fiscal Printer

Feb 12, 2012

I had made MS Access application for a company.

After a while they asked me to connect that application with fiscal printer.

I don't know how to do that.

View 2 Replies View Related

Access Alters Default Printer Setting

Nov 14, 2007

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?

View 8 Replies View Related

Access 2007 Not Finding Specific Printer

Jan 16, 2014

When attempting to print a report in Access which was setup to print to a specific printer I am getting the following message.

This document was previously formatted for [printer name] which is currently not available. Do you want to use the default printer [printer name]

I don't understand because the printer and port name it is referencing is available and matches perfectly! I've tried removing the printer and deleting the port and re-adding it with no success.

View 5 Replies View Related

Access 97 - Error When Using Report Wizard

Jul 16, 2007

Hi all,

Using Access 97 :( to create a fairly simple database for a couple of users.

When setting up a report using the wizard, I am given an error message of "No Current record" when I try and Finish the wizard.

I have re-installed Access 97 - which I thought would have most definatly fixed the problem - but doesn't seem to have done the trick.

Any thought are welcome?

Thanks, Neil

View 8 Replies View Related







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