On an Access 2003 Report, I need to filter the output for a "acOpenReport". At the presant time I am filtering the print with "DoCmd.OpenReport "ThisClientsMaterials", acNormal, , "[W/O]=" & ...
I have an Access 2003 Report in which I'd like to insert a Word Document as an OLE Object. I need to be able to specify the path of the word document at runtime. How can I accomplish this?
I have an Access report with a details section.Is there any way to refer to all the controls in the section and turn them to .visible = false if a criteria is met? I don't want to have to name...
I have a report that I send via email in rtf format. Is there any way to make the file read only so that the recipient can't modify the document?
I need to show in a pie chart what percentage of values in sngAvg are above 29.99, what percentage are below 20 and what percentage are between those two.
I need to combine two tables tblTe...
In my access DB i have 4 columns
A, B,C,D
A=1, B=2300,C=3, D=11
I would like to have another column that has the sum/total of the other Columns by row
1+2300+3+11 E =2315
I don't want...
Hi all.
I have an access report whose source is a SQL View, there are certain records that do not have a sales amount for a month, so I want it to display 0, instead if there is nothing it ...
Hi
I have a database that was upgraded to Access 2007 recently. In the database I had a form and buttons on that form that print reports automatically print to a specific printer, some are...
Is it possible to get images to display horizontally (in columns) in a subreport? I am able to get it to display like I want it to in the main report ( see attachmend RptImage) but when I try...
I have a table (tbl_Charges) which lists by individual a main charge classification and within the main class, it lists up to 5 infraction classifications. These are in text form. I need to be...
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...
I am trying to count three different groups. The first counts correctly every time. The second and third groups set in different headers but with exactly the same control source, =1, give me...
I have an unbound form that is updating two tables view VBA with sql query insert statments. I need to have on a button the ability to print a report that is run by a query. The problem I am r...
I have a report in which I put a text box that returns the average. (Done for me) However I forgot to make sure that it rounds up. I tried to format it but cant seem to get it correct. her...
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...
How do you combine two queries into one report?
Dear Experts,
a client of mine asked me to alter their system so they can print their Access based invoices directly to PDF and then to Outlook. This now works like a charm.
There's only...
My report is set up to respond to parameters provided by the user. Even if the report is very short (one or two lines of sales) I still get a blank page at the end with my report footer(which ...
I have built an Access database and I need assistance on creating a report. My database is a Product Price catalogue. I have tables for Items, and two separate tables for related itme ( supp...
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 trying to build a report that counts the total records within a date range and then breaks the various types of records into their respective groups nd shows the percentage that the repre...
I created an Access report with two subreports grouped by a company id field. The company id field also has a header in the report. This report prints the data for all the companies at one t...
I need an Access 2003 Database running on Windows to run a report behind the scenes and then return the page number where a specific record "starts".
Example: My Flower database holds man...
Is there a way to put a subreport on a form?
I have a user form. When users click the report button, I want them to be able to see the report preview in a box on the form. Will someone tel...
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...
