In reports I have a report I print by Alpha (A,B,C), called jobs by alpha city. I can only see and print the A's. How do I enable all (A-Z) fields to be...

Try DoCmd.OpenReport "HC_labels", acNormal, , "=" & !! If PatientID is a string field (and not a number field) then you need to add text delimiters to the...

HI Im trying to create a chart on a report so that when the user opens the report, the user is prompted to eneter start date and end date and the chart to...

Hi Im trying to create a query that will prompt the user to enter a start and end date. The query will then display the count of records saved each day between...

I have 3 locations using the same database, each one inputs different records. What I would like to do is this. at the end of each day I would like to send...

Hello, we are setting a page break visibility to TRUE within a subreport, however no page break is being entered. any ideas on why this should happen . we...

I am having an issue where each report per record is printing out multiple times. I only need one report to print. any ideas?

In a report I need in each page to have a subtotal (in the page footer) to be forwarded to the nex page (in the page header).The subtotal of a page should be...

Hi, I have an MS access database where table entries are each assigned to 1 of multiple users. I also have the same report that shows summary data about each...

Hi I have a report, which also contains a subreport. Within the sub report there is a quantity field. What I want to do is to display in the main report,...

The following formula displays in full years only: =(DateDiff("yyyy",,Now())). How can it be altered to display years and 10ths of years. AARGH.

Hi, Is it possible to suppress printing of individual group header lines, depending on a condition - say the value of the group header control or the value of...

I have a series of reports that I want to print. I would like to have a form with radio buttons, the selection of a particular radio button indicating which...

I am trying to report on 30 +/- rows of information by month, with months being in columns. I run into the 255 field limitation when I try to create an array...

Hi, I am using code in the Onformat event to assign values to a textbox from a query. The problem i am having is that if i paste the same code in the OnPrint...

Hi Ive designed a database and only have the reports part remaining. I want the user to be able to view and print an invoice for a selected client between...

I have a sub form with multiple records for each customer that i would like to print only the current record being viewed. what code do i need for the print...

Hi, Hope someone can help me. I need to automatically insert into a report the month and year, so that if the date was Greater than 30th March 2006, I would...

Hello, i have been working on an invoicing system in Access 2k for a while now. we have successfully got vertical lines working in the sub-report thanks...

Hello, within the detail_format() function can VBA determine which page the sub-report is currently on? thanks