In a report, I added the bound controls (fields) I need in the detail section. I added unbounded controls to round the value of the original controls. How to I create a sum of the new unbounde...
Hi EE,
I need to save report to pdf, and name the pdf based on the student's name.....
found this post on EE
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Repor...
I have a reprot which contains null values, instead of displaying nothing I want the field to display a zero
If I preview the report first and then print it will print in color, but if I use the code below it always prints in black and white.
I need some code to force the report to print in color...
Print Preview looks a lot like Report View.
Why would one want to use Report when you can just go into Print Preview?
Seems redundant.
I have a report in access that uses a specific printer with custom paper. The printer is called PO printer, the paper is called PO.
In the report page setup I set the Printer to specific p...
I am having trouble hiding the page header of a report once I come to a certain page, which is defined by PageBreak61. This page break is in the report's footer. The problem is that this pag...
I have a label that has text in it that is to long.. I want the text to wrap.. How do you do this?
I'm new to Access, and I don't know SQL or VBA at all, so please be patient with me. I need to prepare a report based on a crosstab query. The report wizard won't work because there are no f...
Hi,
I was experimenting with microsoft access 2007 a while back...and i am not sure what i did on it, but now whenever i try to create a new database, it pops up a logon window. I dont hav...
I am working in access 2007. I have created a form with a button to bring the data from the record to a report that has been created.
I have put the code below. The problem I am having is...
I need vba code help to manipulate a grouped header in a report. I have no clue what to do. I have found bits and pieces of code online and here is the summary:
The report in question is ca...
I'm exporting a query from access to excel. I have several query fields formatted as "Currency" and when i export them to my excel sheet they look like dollar figures but excel is still interp...
I have a report that pulls in a full image path as text from a field in table. Instead of it showing the full image path "C:\whatever\whatever\images\pic.jpg" I want to format so it shows onl...
A Query to group by LID and the give last LID_TRN.
Input data is a query sort by LID, LID_DATE and LID_Time
Example of data:
lid lid_date lid_time lid_trn
174569320 04-May-09 171727 NI
...
Need big help guys!
I am trying to have an output from my query wherein the row is going to be just the merchant_customer_id. With the columns, I need it to be the sum of daa_total_gms but ...
I have a textbox that pulls a value from a subreport textbox.. The problem is if the subreport has no records my textbox display #error.. Below is my code.. How do I display a 0 in the textbo...
Our company recently upgraded from Office 2003 to 2007. We use Access 2007 to print some reports and often need to export the report to Word 2007. When we had 2003, we didn't notice any sign...
I have a recordset displayed in a Access 2007 report that inlcludes vacation time for an employee.. If the employee has FMLA which is a 'fmla" code I want those records to be highlighted or co...
I have built a database for the Phys. Ed instructors to use to enter and calculate student grades. The process is: the teachers enter a 1 to 4 grade every day for student work. These grades ge...
I am very aware of all the different opinions and techniques available as they relate to displaying images on reports. However, I write custom reports for an accounting and project management...
I have added text/fields into the page footer in an Access 2007 Report but it appears in the report immediately after the detail section. The same thing happens if I put the text/fields in the...
I have a report and I need to turn one field to different colors based on the value of the field, but there are 8 different values. I'm not really familiar with VB, and thought I could write ...
I have a report that has the order and the line items in the order. I need the count of orders.
Ex:
Order 1 Line 1
Order 1 Line 2
Order 2 Line 1
I need in the summary Total Orders 2
T...
I am trying to make a report that shows the Average Turnover Rate per week.
I have two fields in the "detail" section, one that counts the number of new hires per week [startcount], and one...
