I have a report (1200 pgs) that is grouped by advisor. I want to print report but seperate it so that printer can staple each advisor's report...

How can I force the subreport control to print even if it is empty (i.e., no data in the subreport's query)? I want the empty subreport to show up just like...

My Table (TblServiceOrders) has a Text Field (Status) that has these options: Billed, To Be Billed, Completed, Open. I'm trying to count off of this field...

We have an Access Database where we input answers to a pre and a post test given to youth before and after our program. Most of the answers are text (i.e....

I have a 1600+ page Access report that I want to print to a series of small pdf files (like pages 1 - 300, 301 - 600, etc). Some of my records have diacritics....

I have a report based on a query that uses the following calculation in a text box to calculate the total amount paid to an employee: =(+)* I would like to...

How code to make Field_label shrinkable dependent on field value in report? Field value set to "can shrink" takes no vertical space in a report. How code...

Hi, I have a continious form that displays four fields for each records of a table. On the form I have a sort button for each of the four fields which sorts...

What I want is tblInvoice.ClientDetail but if blank tblInvoice.HorseName but if blank...

Using Accesss 2007. I have a table that includes attachment type called SPics. On the form I can choose the picture(s) I want, with control source = SPics,...

Hi, I have a multi page report that I veiw using acPreview. When the report comes up my cursor is a magnify glass instead of the arrow. If I click on the...

My query will either pull duplicated data or no data at all. Can anybody help me?

I have an Access report that supplies data to a thermal receipt printer. I noticed the previous developer placed a label at the bottom of the report with the...

Hello, Access 2007 mdb file Using DAO in VBA module of a form to query data from SQL Server and make a local table. I would like to display the data on a...

I create an form in Access which requires an employee ID # to open the Form and enter data on the employee, the data then appears on a 5 page report. Problem...

Hi, I hope I have provided enough information for somebody to help me. I have built an Access database that includes a table that contains information that...

Is it possible to insert an invisible ole object under an ole object an make it visible only if the main ole object has nothing to show. For example, I have a...

In Access 2007, I have a report with 2 columns of data with sums created in a footer. At the bottom of the one-page report, I would like the Grand Total. I...

I seem to recall reading about this at some point in distant history, but I can't find any references online for it. I have a bound calculated text field on...

Using Northwind to set up quarterly reports in my db. The MonthOfQuarter: (Month() Mod 3) Separates the months quarters into 1,2,0 but the VB Code is set up...