Hi All, I have a conditional formatting expression i would like to convert to code, and need some help! I want the code to be in the OnOpen event of a...

I am trying to use the same report layout for multiple queries but am having some trouble. The button code is: Private Sub cmdOpenProjectReport_Click() On...

I would like to know how I can send to print multiple reports at once? I have a form that lists an office within that off there are pts that go to that...

Hi Sorry if this has been answered elsewhere, I have checked and cannot find what i am looking for. I want to have a report that I can use for name labels...

I have a report with subreports in it. When one of the subreports is empty I would like to have a standard phrase show up such as "There are no additons...

Hi, Hope someone can assist me with this problem.I have varios command buttons setup on my form. What I would like to do eventually give rights to certain...

Hi - I have a report with about 12 text boxes lined one right after the other - all with the shrink and grow properties = yes. The problem lies that for a...

I have a report that pulls from a single query. This query is made up of two tables and 9 queries. The tables include: 1) Employee information that requires...

Hi, I Need some help and was wondering if someone can assist me. I have this code below set up to transfer ny form data to excel spreadsheet .This is the...

I've seen a post or two regarding this, but not exactly what I need..... I have a list of employees and their supervisors. I've created a main report which...

I need to display the results from a field in a table based on the following information: 3 files - 2 tables and 1 query 1. ModelHeader (table with at least...

Hello, I have a report based on categories i.e. Appointment Booked; To be Completed; Completed etc. I have totalled each group in a footer based on the...

Hello all, especially the MVPs ;-) First, a reason for the crosspost, for what I think is really a query problem: The query I'm having a serious problem...

I have a report that is trying to get a total damage rate for employees as they load trucks. I have two fields setup. Loader 1 and Loader 2. Each employee can...

What's wrong with this code? Access 2007 I want the label to be invisible also if the value of the text box is null. Private Sub Report_Load() Dim strRpt As...

I have a Purchase Orders Database. I would like a field that count and display the number of records in a report. One of my report would display all orders...

I have a report based on the following query Where I can input an order number and select the amount of labels I want to print, It works very well, SELECT ...

I had an earlier post on this but need to round out the solution. I added a post after I thought the issue was resolved, anyway.....I added..... "I guess I...

hello all! i was wondering if any of you have seen this - i have a parameter query from which i generate a report. the last time i ran it, there were two...

I am trying to create my first chart in a report. I would like to know how to set the data in the x axis to show the month-year example Jan-07. I would like...