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 RepliesHi Guys (again),
Hope you can help and I'll explain this as well as I can but I've put it in general as it's a culmination of things.
I have written a call monitoring database for a call centre (all good so far), but they want historical searches (again all good). I've written the relevant queries for these so that the searches can be done for Adviser, Manager and also by a date range. However, they now want to be able to print out the current search from the screen.
The way I have done it is this. I have written the report be adding in a subreport and putting in the relevant historical search form, and then written a macro that is assigned to a button on the historical search form to print the current record.
The problem that I am having is that when they click on the button to give them the history they fill in the relevant advisor or manager name and the date range which gives them the info in form format but, when they click on the button to print the current 'screen' if you like, it asks for the information again. I know this is because the actual report is written from the same query but is there anyway that it will just print what's displayed on the screen? I don't do VBA so if it has to be done that way could you please display it as it should be inserted.
I do hope that that has made sense and that someone can at least help me, cos you're all wonderful and I've had some really excellent help in the past from this site.
Thanks in advance.
Donna x :confused: (as always)
I have record in wich I would print the records whose fields A is filled but not field B or Field C is filled and not field D.
See appendices.
i've created a database for city permits to be issued (which works perfectly thanx to alll your help), but now i need to be able to print out 1 permit at a time when it is issued (immediately after the data has been entered into the forms). i have 3 tables & 3 forms: contractors/owners, permtOrders (which has tabs for the different types of permits), and permitOrderDetails. the problem is the forms are set up for data entry (and only open in add mode for obvious reasons)...i need to be able to print an actual permit (like the carbon copy, landscape kind that usually tears out of a book). once the user enters the information into the forms, i need a little bit of that info from each form to be carried onto the actual printable permit. i'm not really sure how to accomplish this. :confused: i don't really know if i explained this right, but any suggestions are greatly appreciated.
View 6 Replies View RelatedI have a main form with a subform. The subform has linked tables from the main form. People are on the main form with the index PersonId and they are linked to incidents by IncidentId.
I want to put in two buttons.
First put a print report button for each subform whereby it will only produce a report for the records I can see on screen . i.e. if a person is linked to two incidents I just want the report for those two incidents.
Secondly I would also like a print all button on the subform where it prints reports containing the current IncidentId number.
Is it possible to disable the printing function in a form ?
We are getting people clicking the print icon when viewing a single form record. This results in the printer printing all records !!
I've been trying to get my head round this one , but i'm just to thick to get it.
I have a continuous form that lists all items at a certain location.
The user selects a record by clicking on the record selector and then clicks on a command button with this code:
stDocName = "DivingInspectionCert"
stLinkCriteria = ("EquipmentID = " & Me!EquipmentID)
DoCmd.OpenForm stDocName, , , stLinkCriteria
The user then enters inspection details in to the "DivingInspectionCert" form which i want to store in a table (DivingCert) which will relate to the item. On completion of this form the user then clicks on a command button with this code:
DoCmd.RunCommand acCmdSaveRecord
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "There are no items to Print", vbInformation, "EquiTrac"
End
Else
DoCmd.OpenReport "DivingInspectionRpt", , , ("EquipmentID = " & Me!EquipmentID)
DoCmd.Close
When i click on this button, the report doesn't print and i get a message "No current record".
The inspection details are not stored in the table.
I did have the forms RecordSource based on the table "DivingCert" but that didn't work and i have just tried a query but it is still not working.
Would be much appreciated if you can help me.
Thank you
How do I go about printing specific records displayed in a form? I basically just want to add a print button on my form to do this
I have a main form with a button that displays/opens a form
I then want to print the records displayed in the opened form
(See attached pictures)
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.
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.
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 RelatedHello,
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.
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 RelatedI 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 RelatedWhen 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
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
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
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...
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 RelatedI 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.
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?
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.
: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 RelatedI 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,
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
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