I have an MS Access Report with Unbound Text Boxes. I have code that creates SQL Queries, stores them in array arguments (such as arr(1) as seen below) and then assigns the RESULT of that que...
Hi all,
I am attempting to create a dynamic graph utilizing MS Access that involks a crosstab query. See below.
My problem is, check out the legend / order of the graph by dates. It simp...
I have a report in Access and I have a field in my table that lists a value. In this case it is a year.
there are about 6000 records but only not all of them have the "year" filled in. I ...
I have a report that prints a list of employees in a particular status.
Ive been asked to add the department (which I did) and then to page break on each change in department. (which I can...
hi, i need to compare two tables in ACCESS 2003.
There is a master memebership table1 that i need to compare with membership table2. I need to find the missing members in table2 that are act...
I have a relatively simple report form with an image control in a group header.
A different picture should appear for each group in the report. When I "Open" the report, the images do not a...
I have a report that is Has a page header, detail section and page footer. None of these have any starnge vba, or calculations just some simple addition and multiplication. There are only 3 re...
So I have been working on this Access Report that essentially lays out a schedule of events for various activities at my company. We currently generate these things using Excel spreadsheets a...
I want to open a report using the [ENTER] prompt for the underlying query to filter the returned data by a value greater or less than (ie: not equal to) the text supplied. EG: if 2007 is ent...
My database is a tracking database for a manufacturing facility. I need a query to return data based on dates. For example: when an employee completes a task for a job my database records the ...
I have a MS Access report on which I would like to have a sequential number assigned to each record that appears on it and in addition a total for the total number of records. Is this possible?
OK, searched all over for this one, with no luck, hoping some experts can help me. Setup a main form with 2 subforms, where if certain criteria was met one subform shows up, otherwise the oth...
How to export an Access report to a pdf file.
I can not get MS Access to print Reports in color - it always prints in black & white (gray tone).
The reports are in color in Design View and Print Preview; but the hard copy is black & wh...
I'm trying to write an Access query to compare records and give me exceptions where values don't match in some fields and do match in others.
I have a table which lists customers, policy ID...
I have a report with one group. When the group header displaying, I want to suppress the page header (the group header contains same information as page header + some addition information). Th...
In my MS Access 2007 application, I have a report (ReportMain) & a sub report (ReportSub) embedded in the footer of MainReport. ReportSub has 2 Unbound OLE Objects that are MS Graph, OLEGraph1...
I have created an Access 2007 database that captures employee clock in and clock out times. What I would like to do is generate a report that calculates their daily, weekly, and monthly total ...
I have a report that produces a sum total in the footer. If the sum equals zero, I would like the textbox and the tag to be invisible. I know It is an easy question, but I could use the help...
Hi,
Is it possible to filter a report before it is opened? I currentl have a form which filters a report, however the report has to be opened in order for the filter to work. I would like...
I need to rotate text on my report to read sideways, bottom-to-top. I'm having trouble with the Stephen Lebans approach which I will describe below but first I'd like to ask the Microsoft reps...
I am needing to export data from a table in access to word in an outline format. Is this possible to create a template in word and export the data to the template from access?
I am using Access 2007.
I have a report that actually opens a WORD file that contains the report instead of using the Access report writer. I setup the WORD file so that the merge fields co...
I would like to loop through a list of employees and print (print to pdf) individual reports. I don't want one large report, I need a separate report for each person.
I currently have the...
In Microsoft Access, I am trying to import pictures into a report or if necessary the access database automatically according to a file path generated in one of the forms. Is there a simple c...
