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'm writing a report in Access 2003. I have a field [esstatuste] that will contain one of three options: supervised, unsupervised or null. I'm trying to create a text box that will show eith...
Hello All- I have a VBA program that creates a Graph Report in Access. I would like to see some code that will export this Report to a PDF and place it in a folder. Thank you for your help ...
What I have is a report that works off off a Query. I have something called a branch in the query and I break them into differnet sections on the reports. What I need to do is count the two ...
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...
I am attempting to set an Access Report Filter via my Visual basic Code.
I have some variables, arr(0), arr(2) which hold some values that are being compared
When I have the line:
Me.Fi...
One of the fields in an Access 2007 database (which is actually a link to an Excel CSV file, the CSV file being exported from an accounting program) contains text which can be a variable lengt...
Hello i have a table with 2 dates (format d-m-yyyy h:mm:s, example: 3-12-2007 9:05:03)
Is it possible to get the days between those dates?
I have the following table:
date1 ...
I am trying to figure out the elapsed time for two date/time fields I am keeping track of. The process works well when I do this:
ElapsedTime =[delivered]-[released]
The field format is se...
I have a rather odd report. I use queries to collect the data I need into a make table. The report shows multiple stores within multiple counties. One of the criteria that I append repeats ...
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...
I've been creating reports in Access for 6 years, and only now, in Access 2007, I can not do some simple things. I'm trying to create a report in Access 2007 running on XP. Using the report ...
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 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...
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 ...
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...
Hi there,
I'm very new to using MS Access, and am creating a report for a batch of employees - basically a form letter with employee-specific data. In particular, I'd like to make a nice s...
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...
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 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, 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...
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...
I have an export that works in another database and so I figured i could use it in my current project so I did the copy and paste and then just edited the areas i thought needed changed but no...
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 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...
