I have a series room numbers which are geographically sorted so that rooms 1-10 are in one block, 11-20 in another block etc. Sometimes there are ten rooms...

I have a report that displays a group by different teams. I want the report to color code the team in a report. IS there a way to do this?

We want to start sending our invoices by email from our existing Access 2000 reservation system. How can I print my invoices to a PDF file and automatically...

I know there are quite a few people who have seen posts about my report problems, however, I am getting nowhere because I don't seem to be explaining myself...

I hope this isn't a repost.... I have a database that use to create Class Listings each month. It works pretty good, I am trying to enhance it this...

Hi, is it possible to call a print dialog box to print a selected page in a report after viewing its preview? Right now I can print the whole report...

I am trying to have a field display different data depending on what one field says. the one field will contain 20 different options and based on which one...

How to get reports to print with only 2 decimal places ? Needless to say the control element "decimal places" does nothing I've set what appears to be the...

I have been exporting access reports with job numbers dates times and employee names, Since I have started using a jobnumber that looks like this (0701-001)...

I need to pull the Value of a Label on a form to a Report. I tried putting this on the command button of the form after the report opens but it doesn't...

Hello, I am working in Acccess 2007 and am wondering if there is any way to make Access give rows outline numbering. THis database consists of sequential...

I'm trying to hide a subform when it has no data. However, the HasData property doesn't seem to work. When I use the HasData Property, I get a #Name?...

I am trying to turn columns on an off in a report by using checkboxes on another form (called frmAdvancedSearch). The code below is run when the report is...

I'm trying to create a month view calendar report. I've searched the group and found several references to Calendar samples by Duane Hookom. I've tried the...

Hello All, The code below shows on the report as last name and then first name. Would like add a comma after last name to separate the two. Having a heck of...

Hi, I am having problem when I transfer data from a Report to Excel. Here is the code that I am using: strWhere = " Between " & _ ...

Hi there, I still do not get it completely with the report record source via the 'docmd.openreport'. I created and sql statment in the variable stgFilter ...

Hi, I hope this makes sense. I have a report that I want to "hide" the from if the drug is listed on a different table, . There are only about ten...

Folks, I have a report based on outlets turnover. Records are grouped according to outlets. There may be multiple outlets whose total should be calculated. I...

Hi, I am trying to get my report to display multiple records on 1 page. Right now, the multiple records display one separate pages. Any help would be...