How Do We Get Feedback From The Printer??

Dec 18, 2007

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?

* Standard Disclaimer:

VB Noob! Gentle brow-slapping only please!

View Replies


ADVERTISEMENT

Id Like Feedback On My ER-D (LDM) Please Have A Look!

May 4, 2007

Hello, Im creating a database for a charity. Im in work based learning at the minute as part of my degree course. Basically, I have my ER-D which im going to use in a few days to produce the database. Please have a look at this and criticise it!

Here it is: 17333

Well, basically, i want to know if its going to work... (anything ive missed too)

Please help, Ant...

View 2 Replies View Related

Database Test... Feedback?

Jun 14, 2006

Hey all,
So I'm pretty much done with this database project, but I've got a few minor snags... 3 actually.

1) get error when use delete button and select any option other than "yes"
2) my listbox selection does not load the record in the main subform area as it is supposed to (but I think I just don't know how to set this one up)
3) the frmAdd does not allow user to enter values into the fields for some reason, don't know what's up with that one

If anyone could take a peak, check it out, let me know if there is anything I need to fix, or more importantly, how to get those above things sorted out. It would be greatly appreciated. thanks in advance

View 1 Replies View Related

Visual Feedback In A Combobox

Sep 13, 2005

I searched everywhere, but I think my ignorance of correct terminology is preventing me from finding the answer I need.

I have a form that holds two cascading list boxes. I want to be able to incorporate another list box that holds a record of which selection that was made, and how many per selection. The idea is to give user a visual feedback of what they selected, and be able to modify the selection.

I tried

Let Me.IDSelection.Value = Me.CategoryID.Value And Me.Specifics.Value

but the box stayed blank.... What am I doing wrong?

View 13 Replies View Related

Vote And Feedback On MS Office 2007

Mar 16, 2007

Just wondering what the consensus is on MS Office 2007 package. I find it tasty and is quit different from the past versions. That being said, I am relearning the options and finding many new features that weren’t available in the past.

I am very impressed with it thus far.

Kilch

View 14 Replies View Related

Feedback On Prototype Attendance Database, Please

Jul 13, 2007

I had trouble figuring out how to 1) register a group of people for a class, 2) create a list of dates to meet for a class (which I call sessions), 3) track attendance per sessions. Having looked for templates at Microsoft, I found plenty of Excel templates, but no Access. The closest is Student Registration template, which doesn't track attendance at all. So I figured I'd make a prototype to help me understand how everything works. Since I got so much input from everyone, I figure I'd return the favor and perhap make it a sample database, especially for those who desire a spreadsheet-like data entry while maintaining a properly normalized data structure.But I would prefer that other has tested and given feedbacks on the prototype before I put this in sample database forum (if that's okay with you admins) as this is my first time and I don't want to give others bad template. So anyway, here's the prototype.Note: The database is 100% undocumented, 100% error-handling free, and 100% unsecured. Use it wisely. :)PS: The attachment will reference a extraneous library. If you are getting an error, clear the reference for MS Office 11 Web Components.PSS: I knew I forgot something: There is still unsolved problem of correcting sorting the columns in datasheet view. While the underlying query correctly sorts the recordset, it seems to be ignored entirely in datasheet. If anyone has a solution, I'm all eyes here.

View 14 Replies View Related

Please Give Me Feedback On My Table Structure, Will It Work?

May 2, 2007

Hello dear experts!
Will this table structure work? - Please help!
I need to be able to see if certain members have paid subscription, see if stakeholders have paid for their room bookings, etc. Will it work, does it look ok to you?

Im trying to brush up my normalisation skills and logic.

Please click the link below to see my ER-D:

17320

Thanks, Very much, Ant...

View 8 Replies View Related

Alternative Printer

Nov 6, 2006

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

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

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

Printer Dialog Box Before PRINT

Nov 15, 2006

Hi,

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

View 3 Replies View Related

Barcodes On A Dymo-printer

Jul 12, 2007

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 ?

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

Can't Save Printer Settings

Sep 10, 2005

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.

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

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

Cannot Change Printer From Default

Feb 24, 2006

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

View 3 Replies View Related

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

Label Wizard / Printer Problem

Jul 18, 2007

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?

Any advice on this is most welcome. Thanks.

View 7 Replies View Related

Print Dialogue Box? Chosing Printer

Sep 14, 2005

Hello,

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?

Thanks

View 1 Replies View Related

Print Dialogue Box? Chosing Printer

Sep 14, 2005

Hello,

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?

Thanks

View 3 Replies View Related

Select Specific Printer And Tray

Mar 4, 2008

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

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

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

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

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







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