These days more and more of my databases are wanting to be accessed via the web as well as from MS Acess. I guess this is the norm these days but in most of our (office) dbs it's just 'web for web's sake' and there is no real need to access it outside of Ms Access.
Bu hey that's what they want...
Problem with one such db is that a lot of the fields are memo fields and hold a LOT of text and they want to create MS Access reports/PDFs as well as have nicely formatted html for the text on the web pages.
I seem to be able to cater for one or the other but not both.
1. I can leave the memo fields as raw text and the reports/PDFs look fine with the report formatting, but on the web page there is no formatting and the text ends up in one block paragraph with no formatting.
2. Use a html control for the hmemo fields and store all the html tags within it. The web page looks nicely formatted but the html tags will show up in the PDFs!
I've tried various tag stripping tools but they seem to give unpredictable results.
I also don't want to just dump the PDFs on the web, as they will be static and it's just plain lazy!
(too many unnecessary PDFs on the web IMO)
I can not get my Access Report to give me a total number of pages by group. I've been able to have it give the correct page number per group but not the total number of pages in each group. I've looked at the threads and it appears that in order to get this, you must do a 2 part pass. 1st to get the page number and then to get the total papers per group.
I've used the code supplied and when I do a print preview, I get the message that it can not find the control, Me!ctlGrpPages. This is the control I created and placed in my page footer section of the report. I've also seen numerous references to the report, "Employee Sales by Country" in the Northwind database. I downloaded the database but could not find this report in the database.
I have a text box on a report from the Control Source CSCS Expiry Date. The format in the table and query and report is Short Date. The Text Format is Plain Text.
I have named the text box txtCSCSExpiryDate. I would like to make the background red when the date is 01/04/2013. I have ensured the text box back style is normal.
I am using expression [txtCSCSExpiryDate]=#01/04/2013#
And in case it was the Control Source: [CSCS Expiry Date]=#01/04/2013#
I also tried: [CSCS Expiry Date]<Date() [txtCSCSExpiryDate]<Date()
I applied the formatting each time, tried closing and re-opening the database. Changed the background format colour to green instead of red and even restarted my computer and it just stays exactly the same.
I've just noticed something else. I have a screen only button on my report header with
The expression On Click you entered as the event property setting produced the following error: A problem occurred while Employee Details was communicating with the OLE server or ActiveX Control.
Is this linked to my formatting not working?
I've just checked and on my 5 reports all of the print buttons are giving me this error! (I added the button as they are part of a navigation form menu which only shows report view, I am editing in the original report design view though.) They were working yesterday! Is it because I compacted and repaired the database?
I would like to change the text formatting (color, italics, bold etc) of the contents of a control based on a boolean value in the underlying datasource of the report.
For instance, I have a report that generates a "Proforma Invoice" i would like to ability italicize the prices of certain items based based on a boolean value (EstimatedPrice) in the underlying datasource.
I am making a planner in the access 2010 report. I am showing which activity finished when but I also want to highlight/ shade the cell to the corresponding month on the planner to the right. See picture above. I tried conditional formatting with date rage 1/1/2014 and 31/1/2014 but it does not gives me accurate result.
My new and previous laptops are both 64 bit and installed MA 2010 on both of the computers running win 8.
When I run reports on my new laptop the reports are not formatting. They are reflecting on 4 pages and not on 1 page like on my previous laptop running the same programs.
On my new laptop I installed Office 2013 and old one office 2010 but I used the same Access 2010 on both laptops which is a separate disk as office was not the professional one.
I can generate an email by clicking on a button on a MS Access Report. In the body of the resulting Outlook email you have formatted text. I have also included an array of values which are displayed in this email but I need to highlight certain items in the array in red based on whether or not another column for that record is checked. Here is an image of the email. Notice that I have circled "ZWO" and that it is red. I need for this to happen programmically.
I have a report where the detail section, holding 4 subreports, takes up 5 inches in the middle of the page between the header and footer. We want the entire 5 x 8 area enclosed in a box on every page. I have tried to achieve this by putting a line in the Detail_Format section:
Code: boxDetail.Height = 5 * 1440 * Pages
However, when I run the report, I get pages 1/3 correctly, then 2/3 and 3/3 with no detail section or box, and then pages 4/3, 5/3, and 6/3 with blank detail sections and no box. If it's a 1-page report, the same - page 1/1 is perfect and page 2/1 is blank, no data and no box. I also sometimes (but not always) get overflow errors from the Detail_Format event.
I know it's not a margin error because that would be every other page, and the page count wouldn't be doing that. (Still, I have scrupulously checked every margin, and they all look fine.) Getting this look on the report is a priority. Any way to achieve the same result with the box without causing the missing data and extra pages?
I have already created a summary report that is one page long, however, every time I view my report in report view, export to PDF or print, the report has duplicate copies! Not blank pages. Just duplicate copies of my one page. The report is generating hundreds (about 700) of the same exact page. How do I force my report to have just one page.
I have a form that looks and prints exactly as I want it to, except for two little things. These things are extra pages. They don't appear on the print preview, but they always show up on the printer and on the pdf file when I email it. One page is blank and the last page has "Page 1 of 1" at the bottom right corner of the page. I would always limiting the printing to one page.
I have a DB with all my patients and (among other things) all their referral source.
I would like to print a status report of all my patients, grouped by the referral source, and fax them to the appropriate offices. Easily done with the report wizard.
What I need to know is, how do I create one report, but force a new page for each referral source?
My records are huge, with 2 memo fields. One memo field has the complete content of journal articles, so it's quite a lot of text. What I'd like to do is, per the title, split record data into 2 report pages each with the first page holding the summary field data and the second page holding the journal content only.
I've experimented with the page break functions, can grow / can shrink properties and some of the other things that would be relevant here but can never seem to get them to work.
I'm working with getting a 3 page report to print/create PDF of the 3 pages. Right now I have the formatting set up for the 3 pages but each is an individual report.Is there a way to combine the reports into a single report? I've been messing around with subreports but can't get it to display correctly.
I have a report I want to generate in Access 2010. I have a text box with the following:
Code:
="Page " & [Page] & " of " & ([Pages]+[Forms]![ReportForm]![PageCount])
What I am attempting to do is increase the maximum number for the total number of pages in the report. As it reads right now when I go into print preview it looks like
"Page 1 of " That is all. It doesn't seem to calculate the new total number of pages. Yes the report form is open, and yes there is value in the PageCount in the Report Form.I had this working in another database, but this one isn't being as nice. The reason for adding to the total page count is because additional pages will be added to the report that aren't in the database. how to increase the total number of pages in the report.
I was able to create only 3 pages in access report. I am not able to go beyond 3 pages since the page footer is not moving down, means I am not able to drag it down.
It is a simple report of resume with only text boxes. My report comes around 10 pages.
Send only one or two pages of a multi-page report. I have a report that has three pages. I only want to send the first two as a pdf file. Can this be done with VBA? I know it can be done using Exporting Data on the External Data ribbon, but how can I do it via VBA?
I've got a report, which on the screen is three chrts and a page break in between. Page is set up to print landscape.
When I print the report or save to pdf it adds a lot of pages in between 2 and 3. It seems to be of chart no.2 getting smaller and smaller. I've attached a copy of the pdf so you can see what I mean.
Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number of records in the query) and then make the chart go from one page and continue onto another.
I have set up a report in Access. However, when I look at it in print preview, I get the message that the section width is greater than the page width, and that some pages will be blank. It is obvious that the Detail Section is the issue, but I can't figure out how to reduce the section width. The detail section only contains a few text boxes that are well within the margins of the other sections.
How do I adjust the section width so there won't be any blank pages?
For a text box in a Report, I am trying to use the "SumOf([UnboundTextBox])" as the Control Source in the Report Footer to add the unbound text box in the Details section. I know it works with a bound text box, but does it not work with an unbound text box?
I created a form letter as an Access 2007 report. I want the greeting to read, "Dear [first_name]," e.g., "Dear Alan,". The [first_name] field is bound to said field in a query. When I just use the [first_name] field, I get "Dear Alan" with no comma. I've tried to add the comma various ways:
I've made an adp (access project ) file. I want to permit some users to look in the data but i'm not certain they have access installed, can i give them read-only rights by placing a data-access page in a network map? Can they use the functionality of a data-access page without having access installed?
I am getting very frustrated(and surprised) to see there was no answers to my question regarding Data Access Pages yet. I searched the web and manuals and help in Access, but no luck yet... Can anyone tell me if Data Access Pages really works? I just came to know about it while developing MS Access application...I just thot it will be cool to go web with less effort...