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 feeling this is not going to be an easy answer. I would like to create a bar graph or pie chart as an MS Access report. The problem is that I am trying to put multiple fields onto o...
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 was getting an "error executing command" from the switchboard in Access 2007 on Vista. The app was Access 2002-2003 based, but after converting it to 2007 it still happens.
When I run the...
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...
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...
Hello Experts,
Okay, need a little help with this one.
I want to concatenate the firstname and lastname fields on my report to display the following format:
Lastname, Firstname
I co...
how to filter the report based on selections from combo boxes
I have a report and I want to select values from field to exhibit only some data.
So from a form I push a button.
Until now it ...
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...
Hi Expert,
I have a quick question.
I am seeking a function that can change words into bold format in a textbox.
for example,
="Today Date is " & Boldfunction(Date()) & "."
the ...
Hello All,
I need to generate a monthly report that shows billed amounts.
I wrote a crosstab query that will show me customers as rows and invoice dates as columns. I was able to write a...
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 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 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...
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...
Hi,
I have a form in Access and a Report all setup. I am trying to have it so that a user enters the "ID" number of a certain record in a form and then based on that number a report is gene...
I need to print a single record on a 1 page report, each time I enter a new record.
I will enter Job details (on repair of equipment), then want to click a print button to print a separate...
In DesignView, report properties shows me Name, Force New Page, etc... How I can make my title appear on every page of the Report? "All Pages"? but where do I type that in?
Simple form design but detail runs to several pages. Every other page is blank i.e. the continuation of the data on page 1 is on page 3
Cant see where to prevent this, have looked in
File-...
I am working in a report in Access 2003. I am attempting to insert a text box into the report and then link it to a control source that will populate the text box with data from a table. Aft...
I have an Access 2003 database with a table that lists different companies, employees, job titles and salaries. I have a query that sums the salaries together based on job title. I need to inp...
Looking for suggestions as to the best way of outputting a document populated with Access Fields through web form to a PDF Report for print and or e-mail.
Any direction would be appreciated.
I have a field in a database that is in military time. I would like to know how to change this to standard time either in the query, report or the VBA code. Thanks.
I have created a report that looks great in Access however when I send it out as Excel the formatting goes to crap.
When I send to xls format the columns jumble and the time date columns lo...
I am making an Access Report that pulls data from an Access query. Nothing too difficult. However, the one field is a string that has multiple lines. For a line break, a square character is...
