Updating After Printing

May 9, 2006

I have a command button that brings up a report on my form. After the report comes up and the users has viewed it and printed it, I want a message box to come up saying "Are you done with the report." But when I set up the message box it comes up right after the report comes up. And the user is force to make a decision before its able to do anything.
Is there a way to insert something in VB between the DoCmd.Open Report and my message box to tell the message box, wait until the user has hit the print button?

View Replies


ADVERTISEMENT

Modules & VBA :: Printing Code Slowing Down Printing Reports?

Feb 25, 2014

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.

View 1 Replies View Related

Forms :: Updating Fields Via Code Not Updating Table

Dec 16, 2014

I have a form that has combo boxes and text fields (as well as sub forms). There is also a button linked to some code that says'

Private Sub cmdQuote_Click()
'Creates quote date and prints quote
Me.QuoteDate = Now()
Me.cbAgentID.Requery
DoCmd.OpenReport "Quote", acViewPreview, , "BookingID = " & Me.BookingID
End Sub

When the button is pressed the QuoteDate field (it is bound) should be be populated, but unfortunately it is not. I have played with refresh and requery but cannot derive a solution.

View 1 Replies View Related

No Changes After Printing

Nov 14, 2005

My database is a Reservations System. I want the following to happen:

1. Once a booking has been made it CAN be modified and cancelled.

2. Once the ticket has been issued (printed) it CANNOT be modified.

3. Once reprinted the words "DUPLICATE" should appear on the face of the reprinted ticket

4. Keep track of who made what changes.

View 3 Replies View Related

Printing Sub-Form

Apr 12, 2006

i have a search form with a sub form displaying the results, how can i send the results to a report to print out or just print the results?:confused:

View 5 Replies View Related

Printing From Access

Jul 25, 2005

Hello,
I have one machine that gets this error when trying to print or e-mail a report:
the microsoft jet database engine could
not find the object

Any other machine can print from this db.
Access 2003. XP Pro, SP2.

View 7 Replies View Related

Reports- Printing

Nov 29, 2005

Hey 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

Printing Dependancies

Sep 13, 2006

I just started using A2003 and find the Dependancies feature very useful. However, I can't figure how to print them other than by doing screen shots. Is there any way to print the dependancies?

View 3 Replies View Related

Printing Problem

Jun 4, 2007

When i go into print preview on all my existing forms the information is displayed over the 'x' amount of pages it covers. I have created a new form and when i go into print preview it only displays a blank page.

Any help would be very appreiciated, thank you.

Matt

View 1 Replies View Related

Printing Problem

Aug 22, 2007

hello,

I have a form which has a "Printing Button" The printing button has to print (through a macro) a report that I created based on the form's information. Now, it works perfect on the PC I work on (which has ACCESS 2007), but it gives me an error when hitting the same button from a PC using the runtime version (with no ACCESS 2007 installed).

The error is:
The command or action 'Print' isn't available now.


The code of the macro that executes when hitting the button is:

SelectObject Report, PersonalUncompleted Tasks, Yes
RunCommand Print

How would I fix this?

Thank you very much

View 1 Replies View Related

Printing Querie

Jul 20, 2006

How Come When I Change The Page Setup To Landscape In A Querrie..
Then Hit File Save...when I Close And Reopen This Querrie And Go To Print Preview It Is Still In Portrait Mode

View 2 Replies View Related

Printing Options

Feb 28, 2005

Hi,
How do i create an option inside the form, such that when the user ticks this option, it will print the form in this particular report. If user ticks another option, it will print the form in another particular report format... Thanks...

View 1 Replies View Related

Printing Records

May 7, 2005

If you have a Print button on your form where you add records, can you set a specific font and background colour when you print or does it have to be the same as what's on your form? I have a red background on my form but I want to print just the text and in black and white.

View 4 Replies View Related

Printing Only The Subform...

Feb 16, 2006

Could anyone give some assist on how to print only the subform in a form. I'm looking to create a print preview command button that will allow only the sub form to be printed... Thanks for the assist.....

View 6 Replies View Related

Form Not Printing Anything

Apr 26, 2006

I have a form with multiple subforms. When I hit print selected record I get a blank sheet of paper. What could be set to not allow the data or the background of the form to print?

If I just print the subform out by itsself it works good. However when I have the main form open then try to print I get blank pages.

I am sure someone changed a fairly small setting, but I do not know what has been changed. Thanks.

View 1 Replies View Related

Printing A Table

Jul 25, 2006

Hi,
I have a form with some fields on it.. it's a subform. It has multiple rows. Is there any way I can print the rows as in a report. I Dont know how to pass the subforum values from the form to the printer? I tried the print table macro but it prints the whole table data and not just the data in the subform

anyone offer any help on this?
thanks
Craig.

View 5 Replies View Related

Printing A Form

Aug 9, 2006

:eek: When I go to print the form, it repeats the detail section over and over. Instead of being one page, it is 1414. How can I fix this problem? Thanks

View 4 Replies View Related

Printing From A Subform?

Jan 2, 2007

I have my subform on my main form and when I press the print button that I created it prints the main form 200 times due to the amout of records in the table.

When I open the subform by its self then press the print button that I created it will print what I want, the subform only.
Please help!! I want to print this subform from the main form.

Thanks,

View 1 Replies View Related

Printing In Access

Nov 18, 2004

Hi

Anyone who can help me out?


I have a report in access.
I have designed the report such that. When a user wants to print
there is a prompt for the user to enter the order number.The report displays
all the orders for that order number.A number is assigned for that print out.This
number is unique for every order number the user enters.

How do i capture the generated print out NUMBER, store it in a table so that when
there is another printing for the same order number No NEW PRINT OUT NUMBER is
displayed.The user should also be prompted that he/she is printing an already printed orders.
However in case of a new order number, the generated print out number should be differnt which
should also be stored for future refencing.

Please help

View 3 Replies View Related

Problems With Printing

Dec 15, 2004

I have what is hopefully a quick question. I am writing a simple program for my credit union to generate the paperwork for mortgages. Everything works with one small exception. Ther are two documents (actually Word Templates) that need to print on the front and back side. The credir union has an HP Laserjet 4P with a duplexing unit.

What I need to know is how to send commands to cause the duplex printing. Do you know how to do this or can you point me in the right direction on how to find this answer. I am including the relevant code for this section below, which works perfectly in every other aspect, just can't figure out how to get it to duplex.

Thanks,
Phil Reames
Kalamazoo, MI

MergeDoc = "c:MortgagedocsNote.dot"

Wrd.Documents.Add MergeDoc
Wrd.Visible = True

With Wrd.ActiveDocument.Bookmarks
.Item("Date1").Range.Text = MonthLgl(Forms![editform]![Mortgage_Date])
.Item("Date5").Range.Text = DayLgl(Forms![editform]![Mortgage_Date])
.Item("Date6").Range.Text = YearLgl(Forms![editform]![Mortgage_Date])
.Item("City").Range.Text = Forms![editform]![City]
.Item("State").Range.Text = Forms![editform]![ST]
.Item("Address").Range.Text = Addressvar
.Item("MortAmt").Range.Text = FormatCurrency(Round(MortAmtVar, 2), 2)
.Item("Int").Range.Text = Forms![editform]![Interest_Rate] * 100
.Item("Date2").Range.Text = MonthLgl(Forms![editform]![Mortgage_Date])
.Item("Date3").Range.Text = DayLgl(Forms![editform]![Mortgage_Date])
.Item("Date4").Range.Text = YearLgl(Forms![editform]![Mortgage_Date])
.Item("MortPay").Range.Text = FormatCurrency(Round(PaymentVar, 2), 2)
.Item("Date7").Range.Text = MonthLgl(Forms![editform]![First_Payment_Date])
.Item("Date8").Range.Text = DayLgl(Forms![editform]![First_Payment_Date])
.Item("Date9").Range.Text = YearLgl(Forms![editform]![First_Payment_Date])
.Item("Balloon").Range.Text = Round(BalloonVar, 2)
.Item("Date10").Range.Text = MonthLgl(Forms![editform]![Maturity_Date])
.Item("Date11").Range.Text = DayLgl(Forms![editform]![Maturity_Date])
.Item("Date12").Range.Text = YearLgl(Forms![editform]![Maturity_Date])
.Item("Date13").Range.Text = MonthLgl(Forms![editform]![Maturity_Date])
.Item("Date14").Range.Text = DayLgl(Forms![editform]![Maturity_Date])
.Item("Date15").Range.Text = YearLgl(Forms![editform]![Maturity_Date])
.Item("Date16").Range.Text = MonthLgl(Forms![editform]![Maturity_Date])
.Item("Date17").Range.Text = DayLgl(Forms![editform]![Maturity_Date])
.Item("Date18").Range.Text = YearLgl(Forms![editform]![Maturity_Date])
.Item("Applicant").Range.Text = Borrow1Var
.Item("CoApp").Range.Text = Borrow2Var

End With

Wrd.ActiveDocument.PrintOut

Wrd.ActiveDocument.Close wdDoNotSaveChanges

View 4 Replies View Related

Printing Subforms

Jul 12, 2004

I've created a form that contains 4 different subforms. Each subform carries behind it various calculations that display as totals on the form. If i print one of these subforms there are no difficulties at all in all the totals printing. However, when I print the main form all the totals within the subforms do not show up, even though they are displaying during the print preview and form view. Any ideas on how to correct this?

View 3 Replies View Related

Collate Printing

Jan 18, 2005

Hi all

I'm trying to find a way to streamline my printing.

I've made a student report card DB. I have a report for classroom stuff. I have another report for music and another report for physical education. (I do this because there's too much info to put on one report)

I have 1000 of each report. Historically, I'd print them all of then sit down with my 3 big piles of paper and collate them one at a time. A time consuming job.

Is there a way I can print all 3 reports and collate them for each student at the time of printing??

I appreciate any advice.

View 4 Replies View Related

Printing Forms To PDF

Jan 15, 2006

Not sure if this one is possible but here goes........

I have Acrobat Distiller 5.0 installed. Having set the default printer to this I can now print single forms (Screen dumps)straight to PDF using the command.

DoCmd.PrintOut me.currentview

What I would like to do, is on a click of a button, instead of just sending the one form to PDF which results in one PDF document, I would like to send several at once, resulting in still one PDF document but this time for it to contain all the screen dumps one after the other. (Each from a seperate form)

I'll explian why I'm trying this incase someone can think of an alternative. I have a Tabbed Form (Contains a dozen tabs) of which each tab contains a number of sub forms. Each subform is a query which produces a large amount of performance data from a main table.

I need to be able to present this data as a single report in written format.

As far as I'm aware, a report is not possible due to the number of queries / subforms being used (Unless someone can tell me how to pull the data from several continuous forms tied to different queries over to a report)

I tried using a single form containing all the data to print over to PDF but ran out of room before I hit for sixth tab.

Ideally, what I would like to do is send each of the tabs to a single PDF document. Failing that, I can set up a number of single forms and send them instead.

Any suggestions, either with the PDF or an alternative way

Thanks in anticipation of your help

View 1 Replies View Related

Label Printing Solution

Jun 8, 2005

I need to try and create a simple form that a user enters data into and then hits a print button and the text they entered is printed in a particular way.

i.e. they type in someones name, job and company into 3 fields and then hit a print button and this then prints :

PERSONS NAME
JOB TITLE
COMPANY

We also need the print to be formatted a particular way but that is another issue

This is for a small exhibition we are trying to run and we need something to print visitor badges with

Has anyone got any ideas that can really help as we have been let down by someone who was going to do this for us

View 3 Replies View Related

Printing With Watermark In MS Access

Aug 29, 2005

I want to be able to create a background image as a watermark for Access Reports when they are printed. Now, as I can figure, the Report has a "Picture" property which I can use to set this.

The catch is, the contents of the background image is not static, it must be generated on-the-fly. (for example, it can contain the date of report generation) So, I think, that's ok. I'll need to create an ActiveX object that will generate the image, then I'll assign the image to the picture property using VBA.

Now, my concern is, can I set it up such that even if users create a new report in the database, this behavior can still be automatically done? Is there a way?

Also, would it be possible to set a background image for query results also?

View 2 Replies View Related

Barcode Printing Problem

Jan 15, 2006

Hi,

I am using the downloaded "IDAutomation code 39" font recommended in this forum. It works great on laser quality reports and the scanner reads the codes fine.

But when I try to print to a Zebra TLP2844, the labels are intermittently faint, and not readable by the scanner. The whole label's quality is very sub standard.

I have been reading about the Printer and someone else suggested that I need a template stored in the printer and feed in the data to this template??

Has anyone had any experience with this type of printer / problem??

Many thanks

Dazadd

View 6 Replies View Related







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