Reports :: Using Word To Format Access Reports
May 7, 2014
I've got a word mail merge document that is formatted exactly how I want it. I'm using an Access 2003 database to populate the word 2003 mail merge document.What I would like is to use a access report rather than a mail merge but correctly formatting everything is going to take me forever.
Is there any way I can use the word document I already have to enforce the formatting or must I spend hours positioning each line of text by eye and guessing where on my report it must go to match the word doc?
View Replies
ADVERTISEMENT
Jul 2, 2013
Is it perhaps possible to "copy" the format of an entire report and "dump" it on another? I have ample of forms and reports and I know how to use the Format Painter - but I need to alter the format of all the other physical reports.
View 5 Replies
View Related
Dec 19, 2014
I have been printing reports in pdf format, and the jpg company logo is blurry; my boss did not approve.....
Yet the same image in Word or Excel prints very clear.
I tried bmp, png, tif, etc., with no luck.
I finally figured out that if I check "Standard" publishing in Access then my images are clear.
But, I have to check the Standard box every time I print.
Is there a way to change the default pdf printing in Access to Standard???
View 1 Replies
View Related
Feb 27, 2014
Is there a way to export a report from Access into Word so that it keeps all its formatting etc. The only option shown is in RTF format.
View 2 Replies
View Related
Apr 18, 2013
I have developed a database using Access 2010. This is split into a Front End and a Back End.
In the same folder as the Back End I store a number of user modifiable files in either bitmap (.bmp) or MS Word (.doc to retain compatibility with older versions).
Unfortunately, the drive letter where the back end resides will change from location to location and I can't do anything about that.
I have set up a function that returns the location of the folder where the docs reside irrespective of the back end drive location, and this works perfectly with OLE linked pictures but not with OLE linked Word documents. User changes show correctly in Word document changes at locations with the original drive assignment but other locations show only the original doc contents even though they have been changed on the local back end location. - even if I delete the Source Item info on the report!!
An example of the code I am using for the Source Item is <GetBackEndPath() & "Footer.doc"> without the angled brackets of course, where GetBackEndPath() is a global variable storing the location of the documents folder ending with a back slash.
I have tried the above in the reports Source Doc property but Access won't accept this and says it isn't valid for this property.
View 2 Replies
View Related
Mar 7, 2014
I have set up an access application with a report being exported to rtf format. Would prefer word format if it is possible.
In the export document created there are line breaks on every row. This creates headache when the exported text is re-used in a word document.
is there any way how to have the export where the text is kept together without line breaks on every row?
View 2 Replies
View Related
Sep 2, 2013
I have been tasked with creating a database to log employee suggestions and then automatically present reports around the site. I have developed the database and it works OK and can output *.PDF reports, but I'm having problems with how to display these reports. My idea was to output the reports automatically as *.TIFF or *.JPG files and have them stored in a folder that the My Pictures screensaver uses. The reports (in fact, any site report stored in this folder) can then be shown on any screen dotted around the site when it goes into screensaver mode. However I can't find any way to output/convert to a picture file.
The other option is to create a webpage that rotates through the saved PDFs, but this isn't ideal as the PC users will have to load the webpage to display the reports.
View 4 Replies
View Related
Dec 28, 2014
I am trying to create a P&L statement in access. I know what I want to come out at the end. I am just starting to play with access and having trouble getting what I want to come out of it.
On the sales side I have a query that gathers all the revenue sources and calculates a total for each date. I then use a second query to just take out the data I want for the P&L report. I created a sub-report that displays the data I want. I use the grouping and grand total features to get the total into the report footer. So far so good.
On the expense side I created a form of a query to manage the one to many relationship to capture the data for expenses (one purchase with many line items). I created a query based of this query to get the relevant data for my expense sub-report. I created the sub-report and got everything looking and calculating the way I want it to. I use the same grouping and grand total features to display the data in the report footer. Still good.
I created a new main parent report with the two sub-reports (sales & expenses) on it and even was able to pull the totals from the sub-reports into the main (so currently the subtotals of the two sub-reports are displayed twice). Now when I try to use the textboxes I used to pull the sub-report totals into the main report to perform additional calculations (sales - expenses) I get #error. I have tried different things and gotten ?name.
Control source for the two textbox controls on the main that display correctly, but don't let me do any further calculations.
=[rptP&LExpensesOverview]![AccessTotalsAmount]
=[rptP&LSalesOverview]![AccessTotalsTotal Sales]
To do the subtraction I have tried using the references above, as well as just using the names of the unbound text boxes in the report that bring the totals into the main report.
As a work around, I tried to build one query with all the data from sales and expenses, but can't "filter" based on date and get the data I want in the query results because the two sets of data are not necessarily related. I either get a long list of records, or no records (I am currently only playing with about 5 days of data).
View 2 Replies
View Related
Mar 26, 2006
Right the thing is i can export my reports to word but when they export they don't hold the lines that i placed around the text boxes, this is becoming quite annoying as the reason i put the lines around the boxes,was so when the report is output it looks like the original.
Help please!!
View 7 Replies
View Related
Jun 4, 2014
I have a report with four subreports. If the subreports have no data I have a formula to put the word 'none' in the first field as follows:
=IIf(IsNull([Question]),"None",[Question])
I do a print preview and the word 'None' shows up and subreport looks good when I view just the subreport as well as when I view the full report.
When I print the subreport the text '#Error' prints. When I print the full report I just get a blank space.
I need the subreport to print with the word 'None' if there is not data. How do I accomplish? I tried the above formula both in the query and in the control source of the report. It just comes up blank when I put it in the query.
View 3 Replies
View Related
Apr 7, 2014
I have a Word template that I require my data to be exported to. Is there a way to import a .docx into a report design?
View 1 Replies
View Related
Apr 10, 2015
I have a report that groups by a project name and then a repeating field to list all associated detail having to do with the project. Then the projects loop to the next.Each project row is the same height as the combined detail rows. And to be able to print guidelines just as you would with a word table.
+-------+-----------------+---------+
| Project |.-detail row 1......| Open.....|
|...........|.-detail row 2......|.............|
|...........|.-detail row 3......|.............|
+-------+-----------------+---------+
This is what currently happens.
+-------+-----------------+---------+
| Project.|.-detail row 1......| Open.....|
+-------+-----------------+---------+
............|.-detail row 2......|
............+-----------------+
............|.- detail row 3......|
............+-----------------+
I'm thinking I need to do it with vba putting each into a variable then set the field to be the value of the variable. but i'm also not sure how to do that as it repeats like that.
View 8 Replies
View Related
Jun 26, 2014
I want to open a simple report (restricted to the current record) but I need it as a editable MS Word file, (not printed or pdf, etc.)
Quote:
Private Sub MyReport_Click()
Dim stDocName As String
Dim strWhere As String
[code]....
I've tried several combinations of vba..I'm using Microsoft Access 2007
View 3 Replies
View Related
Nov 16, 2013
I have a report, in which i have a unbound text box i want to control the size of the text box as actual characters means,
if the word is in box is elephant so in report it show complete word then next and if the word is small like cat then it resize then the other word next to cat comes automatically at normal space by auto resizing of text box ..
View 4 Replies
View Related
Aug 2, 2013
I'm trying to add the information from a form and subforms to a report. This would be a medication mar sheet and needs to be in the format of the attached word document. I'm happy to do it in a report and change the formatting if that will work better. The personal info needs to go at the top and the medication needs to be listed on each sheet.
The form is called FrmMarSheet. It basically needs the info from that like the "sample mar sheet.doc". I can only get one medication per page to work at the moment.
View 1 Replies
View Related
Jan 13, 2014
I was thinking today if it is possible to fill Access reports based on a specific Word template? I don't want to populate a Word file with Access data as users of my app might not all have Word. Or is there another solution using a WYSIWYG editor where users can format everything according to their needs? That would be fantastic.
View 2 Replies
View Related
Oct 21, 2014
I need to know if exist the system in Access 2007 to output a report in word document including images. Normally the output is "*.rtf", with a quite good quality but due to the file type it doesn't include the pictures.
View 1 Replies
View Related
Aug 9, 2006
hi guys. i just wanna know if the reports that will be generated by ms access can be in ms excel format.
btw, i am using ms access 2003.
thanks in advance. =)
View 2 Replies
View Related
Feb 25, 2014
I have a report bound to a query that includes zip codes as a field. Zip codes are formatted in the table as 99999-9999 and display in this format when the query is run. However, when I place that field in the report text box as
=[ContactCity] & ", " & [StateAbbreviation] & " " & [ContactZip]
or even as [ContactZip]
The zip is not formatted.
View 1 Replies
View Related
Dec 2, 2013
I have a report with a list of employee names (and other information). A handful of them need to be a different color (other than default). There will always be more than 3, so I can't use the conditional formatting tool.
View 14 Replies
View Related
May 14, 2004
I need to e-mail weekly reports to several parties, but both Word and Excel are not working for me because I am losing the original formatting. For the sake of consistency and readability I need to preserve the original report format, but I am totally stumped as to how to do this. Please, someone, help!
View 3 Replies
View Related
Mar 21, 2015
A report field data is sourced from a query which displays its values as a string eg "George Renee", however in the reports it displays data as a number eg 42. It is true that the query field obtains its data from a table which gets its data through lookup Wizard. I really want the report to display string type.
View 1 Replies
View Related
Apr 20, 2013
I have browsed a few forums and am still having trouble creating a pie chart that has the proper layout that I would prefer.
I have created a query that will list the data I would like to organize into a pie chart. The query, when run, will prompt the user for a start date and an end date and then display the data in this form:
EmployeeX | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
EmployeeY | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
OK, now that I have the data in this format I would like to create a report that includes tabs for each employee, each tab will have a pie chart that has one employee and a pie chart showing how their hours are allocated to each task. e.g. tab 1 would have Employee X and the pie chart would show what percentage of this employee's hours was dedicated to project/demo/admin/etc...
View 1 Replies
View Related
Apr 30, 2014
How do I format:
First 25% of records - Gold
Second 25% of records - Green
Third 25% of records - Yellow
Fourth 25% of records - Red
View 4 Replies
View Related
Oct 21, 2013
The first part of the request is to capitalise all the below fields, when they appear on my report in addition to removing any <null> values. I can't seem to get them both in the format area
my fields are
Title
Fname
Sname
Address1
Address2
Address3
Town
Postal
View 5 Replies
View Related
Sep 12, 2013
I need to replicate an existing report that has a number of 3 columns across the page and has 35-40 rows down the page...it's like a table in Word or a spreadsheet in Excel. I need to print the column and row lines.
Is there a simple way to include these in the report other than me drawing each and every line?
View 2 Replies
View Related
