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...
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 ...
I am developing an application in Access 2003. It has a table that lists various information about clients. One of the fields is a text field that has the path to an attachment for that clie...
I have a Access report that is a "Customer Account Statement"
The report lists Invoice Number and Dates along with the Amounts for invoices that are still outstanding.
At the bottom of t...
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 ...
Hi all,
I have an access table which stores the daywise prices of some 1000 shares such that any row in the table gives the price of the share in that row as on a particular date (Please see...
How do I change the page header on a subreport. I get the page header for the main report. what I am trying to do is have the main report first then the subreport. They have totally differe...
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...
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 There, I have a report in an Access Database that prints off onto a pre-formatted page. I am trying to get the area code, mid three numbers, and last three numbers in the correct position....
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 form & database.
Located on the form is all the information required to fill in the e-mail. (To, Subject, parts of the body, etc.)
Now the catch, I don't just want to...
I'm trying to allow the user the option of printing 0 lines, 5 lines, 10 lines, or all Notes (memo field)
The solution in here http://www.experts-exchange.com/Microsoft/Development/MS_Acces...
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 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 table containing over 3,000 employees and only 100 supervisors. I need to e-mail each supevisor his/her employee reports. So that means since there are only 100 supervisors, ther...
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 ...
I have a main report that is basically an empty shell holding 8-9 sub reports. These sub reports are separate reports generated from separate queries.
The problem I have is that, if a sub ...
I am currently working on CA unicenter Service Desk 11.2 , reporting . I am using MS access report of Service desk . I have total 18 categories . Category is a field name under table prob_ctg
...
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...
Access 2003
How do I change a reports page format property from A4 to letter during runtime by using VBA?
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 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...
I have a report in Access that has unbound labels in the "Page Header" section. The fields with the data is in the "Detail" section, all of which are in single row. When I run a report it will...
I have a record set with a field for where buildings are located ([Region]). I'm atempting to make a new report that groups these regions by a more broad field, [Zone]. For example, Region 1...
