Colour Printing From Report
Jan 17, 2007
Hi all, i'm having a rather annoying problem. When I view my report I have 2 sets of conditional formatting that run, one that changes the back colours of certain fileds when the criteria is meet, and the second, the text colour of certain fields, both of which work fine when previewing the report. However, when I print the report, any of the back colour in the preview does not print out but text colour does. If I print from another office programme i.e. Word, block colour is printed fine its just seems to not work in my access.
Please note that if the same report is printed from another computer, it prints fine.
Please does anyone have any idea on why this is happening and how to sort it. Thanks in advance for any ideas and help.
View Replies
ADVERTISEMENT
Dec 10, 2014
I have access table that stores details as attached. Just to give an example how data is stored , I copied data from Access table to excelsheet. Now I would like to create a report that will run when a button is clicked on the form and the vba code should display the last 7 dates from todays dates in the report along with all the data and colour the record Green,Amber and Red depending upon the Update Date and Target Date. If the Target date exceeds then that records should be coloured "Red" and if todays date equals to Date then the record should be amber and if greater than Date but less than Target Date then it should be Green.
So the report should display the last 7 dates records from todays date and the appropriate color of each record to let everyone know if its under target, meets target etc.
View 4 Replies
View Related
Jul 11, 2006
Hi I am new to the forum. :)
I am creating an access database that holds customer information for a friend of mine. I am struggleing to think of ways to make Access do several tasks.
I have created several forms that display when reletive buttons are clicked and some run automatically using queries, one of which runs a query that displays any upcoming service inervals that are within thirty days of the current date, and allows the user to print a report that is designed to be a service notice for the relevant Customer/s which contains the customers address, phone numbers and service due date with a small pre-made text insert that advises the Customer about the upcoming service recommedation. The Form also provides the ability to print address labels for the same customers, making it quick and easy to send them out by post. The problem that I am having is that I would like the customers information that has already been printed to be removed or greyed out in someway so that the query does'nt print out duplicates but also have the ability to allow user control to reprint any result that may for any reason need reprinting.
Thanks for any help
Christopher
View 2 Replies
View Related
Aug 30, 2006
Hi
I'm pretty new to all of this. I've set up a simple database. I have a form in it for inputting information and then there is a command button on the bottom which prints out a report I've created with the information on it. This is all working great except it prints evey record and I only want the current record printed out.
I've tried the help and it goes into detail about OpenReport and PrintOut in macros. I have no idea what a macro is or what to do with it.
Can anybody please help me and give me step by step instructions as to how to print out only the current record in the report from the command button.
Your help is greatly appreciated:)
View 1 Replies
View Related
Nov 1, 2006
I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout)
Here is my current code for the print button on the form page:
Private Sub btnPrtOrderFrm_Click()
On Error GoTo Err_btnPrtOrderFrm_Click
Dim stDocName As String
stDocName = "rptOrders2"
DoCmd.OpenReport stDocName, acNormal
Exit_btnPrtOrderFrm_Click:
Exit Sub
Err_btnPrtOrderFrm_Click:
MsgBox Err.Description
Resume Exit_btnPrtOrderFrm_Click
End Sub
The only problem is when I tell it to print if I am on record number 2 on the form, it prints both record 1 and record 2. I only want the current record i am in to print. Any ideas much appreciated
Dean
View 2 Replies
View Related
Jul 28, 2006
I had made my own database for my own business.
I am trying to print a report from a form. Once i enter an order detail i finish off by printing a letter. At the moment we are doing this via a query by entering the order id.
I want to automate this so for the form record i am in i want a button to print a report for that record only.
I know this can be done as i rember doing this in college but i cant get my head round it at the moment.
Please help
View 2 Replies
View Related
Nov 6, 2006
Hi, Ive read all I can on forums and web and am still unable to print the current forms report using a command buttons on click. This is the code i have been playing with:
Dim strDocName As String
Dim strWhere As String
strDocName = "Home_Oxygen_Report"
1. 'strWhere = "[general_info.HospitalNumber]= Me!Home_Oxygen_Form!general_info.HospitalNumber"
2. strWhere = "[general_info.HospitalNumber]= "" & Me![general_info.HospitalNumber] & """
3. 'strWhere "[general_info.HospitalNumber]='" & Me![general_info.HospitalNumber] & "'"
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
Number 3 gives the closest result but it prompts me to enter the primary key when i hit the command button but i need it to do this automatically. The primary key is a text box not number. Note that the primary key is HospitalNumeber of Table general_info (form and reports record source is query of many tables).
any help would be muchly appreciated!!
Tania
View 3 Replies
View Related
Dec 3, 2004
MS Access 2003
I inserted an image (jpg) in a report, it appears in PrintPreview, but not when I print it on my printer.
Please help me. I do not if the problem is with my printer or I'm doing something wrong when inserting the image.
update: It seems to work when printing from Print icon, but does not work when printing from File/Print menu. Is this a known bug?
View 5 Replies
View Related
May 14, 2005
Need how to help on printing reports in Access
Problem: I have a databse that is on a network at the office. My users are out in the field using mobile data computers linked to the network using verizon air cards (56.6 kbps modem). Whenever they want to print a report, since the front ends of the DB are on their computers and the back end is on the server, the mobile computer has to send the actual report from the computer over the air card to the server for printing. Each page takes 5-7 minutes before it prints at the office.
Question: Since the data resides in a table on the back end on the server, Is there a way to have the reports reside on the server as well and have the Mobile computers simply send a command to print the report from there so it's not having to send all that information over the incredbly slow air card? Or am I just going about this the wrong way altogether?
I'm not totally up to speed yet on all this computer lingo so please use little words (LOL).
View 5 Replies
View Related
Jan 13, 2015
I have a report with one sub-report. It previews correctly and prints correctly from my ACCDB. However, when I create an ACCDE, the sub-report previews correctly and then does not print. I have tried the following and none work: In the main report, deleted the links and changed the subreports record source.
Changed layout for print to no
Changed filter on empty matches to no
Moved everything from detail to page header.When I put code in the subreport to set a flag when loaded and queried that flag in the main report, the subreport never admitted to being loaded when run from the ACCDE (again works fine from the ACCDB).
View 4 Replies
View Related
Mar 1, 2013
I'd like to print out a report so that each record should be printed into an individual pdf file. When printing manually, record by record, I use an app called cuteprinter for converting reports into pdf. But that one needs saving path for each individual pdf file. What could I do if I'd like to make a series of record printing? Would there be a way of automatic generating path and file name for each record's print?
View 1 Replies
View Related
Jan 3, 2010
I am able to print a report of all records from a command button on a form with
DoCmd.OpenReport "General Input Info", acViewPreview
I can also print just the current form to the report with
DoCmd.OpenReport "General Input Info", acViewPreview [ID] = & [ID].
What I would like to do is print a report showing the current form and all the forms after that form. In other words, none of the records previous to the current form listed but do show the current record and all others after that as determined by the auto number ID field. I am able to filter by form in the ID field with >45 showing me all records with an ID of 46 and above but I want to be able simply print the report from the command button that is on the form.
View 8 Replies
View Related
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
Jul 19, 2007
Hi Everyone,
I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report.
Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the form. When the client clicks on the button it prints all the records ("result reports") of all the clients...no good of course.
Here's the code for the button:
Private Sub PrintSingleChamber_Click()
On Error GoTo Err_PrintSingleChamber_Click
Dim stDocName As String
stDocName = "SingleChamberPrintOut"
DoCmd.OpenReport stDocName, acNormal
Exit_PrintSingleChamber_Click:
Exit Sub
Err_PrintSingleChamber_Click:
MsgBox Err.Description
Resume Exit_PrintSingleChamber_Click
End Sub
Can someone point me in the right direction? :confused:
Thanks again,
Mark
View 1 Replies
View Related
Jan 31, 2008
I have a report with several subreports which run agains a very large table. If I decide to print the report after examining it, all of the underlying queries must run again. Is there any way around this to avoid this delay, other than exporting as rtf or snp?
Thanks,
Randy
View 1 Replies
View Related
Jan 23, 2006
I have a report that I want to pint the beginning date and ending date range that the report was based off of.
I have a query that prompts for begining date and ending date
I want the print to look like this.
Current Report Date : 01/01/06 to 01/30/06
Any Ideas
Thanks
Dean C
Giles Chemical
View 14 Replies
View Related
Jun 13, 2006
Hi all..
I have a drop down list on a form that prints a report based off of the selection in the cbo box...
(I have already changed the query and relationship for the lookup and maintable)
Here is the code that works fine,(this is on a command button)
Private Sub cmdViewStreet_Click()
stDocName = "rptStreetName"
On Error Resume Next
DoCmd.OpenReport "rptStreetName", acViewPreview, acEdit
Me.cboStreetName = Null
End Sub
What I am doing now.. is this: the look up table that had the street names but did not have an autonumber or primary key. I added in a autonumber and primary key. I can get the cboStreetName to list the street names and not the autonumber.. and I can get the main table to store the autonumber not the street name (this is what I want).. but now I can't get it to view what is in the cboStreetName... When I hit the view button it does nothing... Any suggestions?? If you need more info please let me know...
I tried something like this to:
Private Sub cmdViewStreet_Click()
On Error GoTo Err_cmdViewStreet_Click
Dim stDocName As String
stDocName = "rptStreetName"
DoCmd.OpenReport "rptStreetName", acPreview, , "[StreetName]=" & Me.cboStreetName.Column(0)
Exit_cmdViewStreet_Click:
Me.cboStreetname = Null
Exit Sub
Err_cmdViewTitle_Click:
MsgBox Err.Description
Resume Exit_cmdViewTitle_Click
End Sub
R~
View 1 Replies
View Related
Jul 27, 2006
Okay, here is the situation that is slowly driving me crazy.Form: Clients ACTIVESubform: Clients ACTIVE - closureReport: Clients ACTIVE - closure (created by a save as by the subform)My database was created to keep track of clients in a centre. The clients files are eventually closed by a checkbox. Then a number of reasons are inputted in as for why the file is now closed by means of a combo box (lost contact, graduated, etc). After the files are closed, the users want to print a simple one-page report that they can put in their manual (paper) file. I created a subform that allows the users to preview what will be on the resulting report. I also created a button that they can click to print the report.NOW for the problem,The report will not show the new information (closed checkbox = yes, reason for closure, notes about closure, etc). I can't refresh because then the client no longer shows up in the form as it only includes ACTIVE aka open files aka Closed=No.Here is my coding for the button that I have:Private Sub Closure_Click()On Error GoTo Err_Printable_Click Dim stDocName As String stDocName = "Clients ACTIVE - closure" stLinkCriteria = "[StudentNumber]=" & "'" & Me![StudentNumber] & "'" DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria Exit_Printable_Click: Exit SubErr_Printable_Click: MsgBox Err.Description Resume Exit_Printable_ClickEnd SubHELP ANYONE??? :) My only idea is to do this is something like where is matches the student numbers, refreshes the form, and prints the report. BUT no matter where I put the refresh or requery command, it doesn't work. It ends up printing a blank report as it can not find the student number in the ACTIVE form as the client is now closed.
View 1 Replies
View Related
Oct 4, 2006
I have a subform that displays results based on selections from cascading boxes on the form. I am trying to print them to a report. I think my procedure is correct for the print button and Im afraid my problem is that the form is not based on a seperate query. Is that they only way to be able to print? It is based on procedures defined in the cascading boxes. How can correct it so it will print the results to a report? Thanx.
View 2 Replies
View Related
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
Jan 6, 2005
I have a form which is used for data entry for a new record only. I then wish to print some of this record's details on a report, using a command button on the form. At present I cannot filter to get just the current records details on the report - I am getting the report containing all records in the table.
Thank you
View 3 Replies
View Related
Feb 11, 2008
With Access XP, I have a simple two page report (with a subreport included). When I go to print it, it prints out about 32 copies.
Of course, in the Windows print que, it is set to one copy.
There has to be some setting in the report causing this.
Thanks
View 9 Replies
View Related
Feb 10, 2015
I have an application where I have some users in the field with tablets and they deliver a package and the receiver will sign for it (like UPS or FedEx essentially). They sign my application and then the application saves the signature to a SQL Database in binary data. I'm using the Microsoft InkPicture ActiveX control to achieve this. After they sign, I have a line of code that equals:
Me.RecBySignature = Me.RecBySig.Ink.Save
This works fine and I can also recall the signature to the form when the form is re-opened.how to do is to put the signature on a report. Is there a way to "draw" the signature on the report? Or to print it to the screen?
View 1 Replies
View Related
Jun 1, 2014
Any code for viewing Report between two dates. So when you open the report it will ask for the starting date and ending date.
View 4 Replies
View Related
Oct 22, 2013
I am trying to have a macro button so when I click it it Emails to a particular person but also prints off a copy.it all works fine but for some reason it wont print the image off, my macro is as below
RunCommand - Print
SendObject - Report, RPTDailyReports
Close - Report, RPTDailyReport
when I do CTRL + P and put the print quality up to 'Super' it prints fine
View 4 Replies
View Related
Aug 4, 2015
I have a report that comes from a query.
On the report I use the group function on a field called assemble part number and select no duplicates in the property field . so I don't get that part number on every line below that group.
When I print the report it gives me the assembly part number on every line can the report be printed without it on every line just the group line.
View 1 Replies
View Related
