Ok That worked fine.
Know, once I fix the problem with my pdf writer I am going to revert to previous system. How do I determine whether the report prints to a pdf document or to my printe...
I'll do my best to explain what this chart should look like. My main problem is that in the chart wizard I can't select the custom chart I want to use. Once the chart is created I can't figu...
I have a Pay Period Table with begining and ending dates
an Attendence table with Student ID, Date Worked, and hours worked
A Skill table with rates for the various grades,
and Student tab...
I Have an ACCESS 2003 db Report that is filtered from a open Form with many records. In one field ("MaterialB"), there are multiple records that have multiple items. I need to get a summary ...
hello experts,
I have a report with the following sql and would like to display only the records that have a count of [FacilityDetailsID] >1 under the tblFacilityAmountHistory. In other word...
I have a query that pulls information from a table. In the table there are checkboxes. I want to produce a report based of the query which displays the different fields from the query. I also ...
I need to total selected records (selected by date range), probably in a report and then divide the total sales by the customer count. Here a selection of the records. The total of the sales...
I have created a print log for users. It logs specific details everytime a user prints a form or query. I tried to do this for reports using the ON PRINT function of the report but this functi...
I have an Access reports. I want to click a button for it to automatically export to Excel xls.
Gentlemen,
I have a report with the usual address textboxes: Name, Address1, Address2, City, State, Zipcode.
By concantenating the City, State, and Zipcode, I wind up with 4 potential li...
I have the following code in the "no data" event of a report, to prevent the report from running if there are no records:
Private Sub report_nodata(cancel As Integer)
MsgBox "there are no ...
I have a database in Access 2003. It has several forms, tables, queries, reports and modules. I have done extensive re-working of the db. I have also renamed some tables. The current remaining...
Access novice here. Very small, basically uncomplicated Access DB runs a report and subreport from basic queries. For some reason, in the subreport, if there is more than one entry, the print...
Every time I choose to view a report in my access database (2007) - the program crashes and I need to restart it. I don't lose any data, its just very time consuming. I know very little about...
I would like to be able to have a command button that exports a report to excel file without automatically without having to choose from a list of possible export formats. I would only like to...
I am getting the following error trying to import Access reports into a Report Server project:
Error : An error occurred while the report "reportname" was being imported: Reserved Error
...
Does anyone know how to have an Access report print the last page first and then print the rest of the report or have the pages print in reverse? Either through Access properties or programati...
I have a pretty basic report in access that lists all the IT cases I have opened and lists them by their "category" field. At the bottom of the report I want it to display the quantities of ea...
Hi,
I build a report to list all the data that current on the form, but I have problem to print a report that only shows current data. Everytime I print the report and it have 100 pages si...
I'm just trying to get widow control on a Microsoft Access Report's GroupFooter -- i.e. trying to make sure that the whole group won't finish with the footer on a single page, it takes at leas...
I have a report in access that basicly takes all the data and puts it in an excel sheet. This report used to work but then when I added several new fields to the table it now goves the followi...
One of our consultants has a requirement to create an MS Access 2000 (jet; .mdb) database with an associated Access form that includes a "Report" button. On-click, the "Report" button generat...
Is there anyway to display images in a horizontal rather than vertical format in a MS Access 2003 Report? For example the report currently displays the images as:
Image 1
Image 2
Image 3
...
I have a report that as a variable [BalReason] in it so that when the report is opened it prompts the user for input that is added in to the report. I would like to now have the input box tha...
have a report that I have grouping levels of cities
City1
City2
City3
City4
What I want to do is if City4 happens to be the same as City3 (the group above) th...