I am building a database which produces a report which I have formatted as a letter, I know I could have done this via a mail merge etc however...
What I am wanting to achieve is when this report(letter) is run, is there a way that when it is produced from a macro button embedded in a form that this report can then be saved as a pdf attachment within the same access database attached to a client record?
I have a non standard size report (for printing labels)
The report is just over 10cm wide and just over 15cm deep.
I have solved the blank pages caused by exceeding the width but I'm still getting a blank page when I move some data down. I am still within 15 cm but it's throwing me a blank page. Even if I extend the in design mode depth to say 20cm (ie the height in Detail) it's throwing a blank page (I can see this in print preview).
I initially set up the report (it's a long time ago so memory fades) using the label wizard setting up a label 4*6 inches (10.16 * 15.24 cms) and it is this i'm trying to tweak. Is there a property I'm missing somewhere?
I would like to ask about on how to display my attached pictures to my report. I'm using MS Access 2007 and I have a table names:
Projects - ProjectID, ProjectName, StartDate, EndDate;
Task - TaskID, ProjectID, TaskName, Pictures;
Picture datatype is Attachment and it is multi-valued field so I created a query to extract picture per ProjectID and to be used as a Subreport. Query results shown below:
ProjectID Attachment
11 tulip.jpg
11 hill.jpg
10 panda.jpg
10 shark.jpg
Now, I have created the sub report and linked it Project table. Result is the pictures add up vertically or downward where there is a big space on the right side, I want to have it from left to right or horizontally.
I have an image within the attachment field on a table.The particular table is not linked with the data within the report.I tried to use DLookup but found it only showed the picture name i.e. signature.png..How can I display an image (in fact the only image) in the attachement field on another table within the report?
View 1 Replies View RelatedWhat I want to do is save a daily report to a map source, each day the map name changes so for today the map name is "Report2013-10-03", and tomorrow the map name will be "Report2013-10-04".
Is this possible? is there some function like save(Report%s) where %s = date() ?
I have developed an Access Database for my Co-Op work term workplace, and everything seems to be running smoothly with the exception of the report generation phase. The company I am at has a set template for all reports (Clients column always goes in a specific place on the page, and the report always contains the same categories in the same locations; things like that). The problem is that, every time I go to make a new report, I have to re-format and re-make the report. Is it possible to save a report`s format so that, when I go to make a new report, it automatically applies that format to the data being used?
View 3 Replies View RelatedThe below code is intended to:
1. open outlook mail;
2. copy the email details into the database;
3. save the attachment into a E: drive location;
4. move the email to another folder.
1,2 and 4 were working fine until I tries to save the attachment and got stuck on the SaveAs line.
Dim Ola As Outlook.Application
Dim Nsp As Outlook.NameSpace
Dim pf, Inbox, ib, newdest As Outlook.MAPIFolder
Dim msg As Outlook.MailItem
Dim Atts As Outlook.Attachments
[Code] ....
I am working on an Access DB and I need to email individual reports to email addresses linked to the corresponding email. I would like these email to be sent though outlook and the attachment to be a PDF.
View 10 Replies View RelatedMy form: "Dailyissue"
My attachement field: "Attachement_1"
I attached an image in Attachement_1, I want to set that image in a cell of excel using VBA. How can I do it? (I don't want to read the image from the PC, I want to use the attached image).
I have a database that has the table [tblAttachments] to store various attachments. In this table I have a primary key [ItemNumber] and an attachment data type field. This table holds all attachments for a Customer/Record.
What i am trying to accomplish is being able to code a command button to send the Attachment file (eg. various type of files .doc; .exl; .jpg etc) as an attachment in an email.
I have found some info on saving them to the local harddrive but this is not going to work for my specific needs.
I have an access form. It has
-Two textboxes with client first and last name
-Two textboxes with a contact 'email1' and 'email2' for the client
-A combobox with a list of templates to use for the email.
-A checkbox to include a copy of the statement on the email.
I want the user to be able to press a button which does the following
-Sends an email to both 'email1' and 'email2'.
-Attaches a secific report as PDF if the user has selected the checkbox
-The body of the email includes a greeting line using the clients name from the record.
-The body of the message includes below the greeting line a html email template depending on the users combobox selection.
I have some code below that exports a report to PDF.
It works fine, I just want to know if it's possible to export the PDF without saving it? I can't seem to find anything on my search about it.
Code:
'Open Report From Query
DoCmd.OpenReport "rpt_BLT_PrintReport", acViewPreview, Me.Filter
'Output Form to PDF
Dim strUserName As String, strPath As String
strUserName = Environ("username")
strPath = "C:Users" & strUserName & "DocumentsPoliceReport.pdf"
DoCmd.OutputTo acOutputReport, "rpt_BLT_PrintReport", acFormatPDF, strPath, True
'Close Report
DoCmd.Close acReport, "rpt_BLT_PrintReport"
Thanks for the help so far...
I have managed to export areport to file but I lose all the formatting. I get the option to output as html, xls, txt, rtf or snapshot format.
Is there a way I can output the file whilst maintaining the look of the report as it is in print/preview??
Cheers
Hello all!
I would like to have one stupid question, because I could not find any answer on this forum.
I want save the Form as Report. I can do that from "Menu bar", but I want to do that from the code (VBA or Macro) without inputting the output parameters by users.
Do you have any idea how?
Many thanks.
Krava
Can anyone tell me how to have Access automatically close a report without saving any changes.
I do not mind if the user closes the report manually but do not want Access to prompt the user to save changes. I want it to automatically abandon any changes that were made.
I have built several reports and I have set the layout to Landscape. When I go into the reports after a few days, it puts the format back to portrait. How can I stop this from returning to portrait?
View 2 Replies View RelatedHi all - I'm new here and am very glad to find this forum for some help!
I've been using Access for several years and I do the same type of reports over and over and all of a sudden I'm having trouble.
I typically modify existing queries - changing the name of the department in order to pull up their info - and then I format a report and modify that same report over and over with the "Properties" key where I pull in the new query info and then use SAVE AS to save the report with that department's information.
For the first time ever it will not let me SAVE AS with the new info. Sometimes it just does nothing at all - appearing to save but then the report isn't there - sometimes giving me a pop up box that says it couldn't find the search key - I don't even know what that is!
I can SAVE AS with queries, but not reports. HELP!
Thanks!
PDF was generating and saving to the correct location, but when I open the PDF file ... it's blank =P am using access 2003 and acrobat standard 9
Code:
Private Sub cmdPDFByAssetNo_Click()
Dim MyFilter As String
Dim MyPath As String
Dim MyFilename As String
[code]...
I'm running into a Run time error 3014 Cannot Open Any More Tables
I have a report in Access and I am using the below VBA to save the file by the content of the "File" column in the DOC_AP_MASTER table. It works wonderfully for about 60-120 (it ranges and I don't know why) but then I get the lovely error above.
My report closes after each save... what tables am I opening without knowing?
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim MyFileName As String
Dim mypath As String
Dim temp As String
mypath = "C:Testing"
[code]....
I have a report that prints labels.
Every few times of opening the report, the page setup settings revert back to default i.e. 1" margins, 1 column etc.
how can i assure that these settings remain unchanged??
thanks!
Hi,
I was wondering if there was a way for a report to be automatically saved as an excel file. Also, the Access database is stored on the company's server so would you be able to choose the path where the excel file would be stored?
Cheers,
Ben
I have generated a report in acviewreport, after viewing the details I want to save the report as a pdf file with the client name, invoice number and date. In the report design view I added a cmd button and successfully coded it. However, it saves the report WITH the cmd button showing. I don't want this button saved. Is it possible to remove the button from the report AFTER I have clicked it?
View 4 Replies View RelatedI have done some searches and found out about creating joins and have almost achieved the results I want. I have 4 tables (Invoices, Labor, Purchases, and Payments). All are linked by Invoice number and all of the data is enter via a form called invoices and has a subform for all of the other parts. I am creating a query to pull the total amount of the invoice from the parts of the table and then taking the payment and showing a report for this.
I created 4 total queries and then have nested them into a query. I then perform the calculations and have my results that I can then put into a report. Only problem is that if there is not data in the labor table for an invoice it does not show the invoice in the final query. Homever, if there is no payment data or purchase data it will show the invoice and leave those fields empty. Not sure why this is happening I used the same type of join on all of the queries.
Would love to try and understand why this is not working correctly. I can get around this by just entering a 0 for work hours on the subform, but I am thinking that there should be a way to this without doing that.
Anyway, if any one can help me understand the problem, it would be greatly appreciated.
I have attached a very scaled down version of the tables I am working with and the problem is in the InvoiceTotalsQuery. I have not performed the calculations in this, just want to see why invoice 7 is not showing.
Any help is greatly appreciated.
My raw data contains a text string with various codes separated by an underscore. For example, my raw data would contain a string like this, "SAMPLE_DATA_ABC1_NYC", and each of those codes would have corresponding name that is mapped out on another table.
I'd like to set up a query that would evaluate the raw data, look up the associated code (e.g. "_ABC1_") and then return the corresponding name. (See screenshot for an example.)
I tried using IIf and InStr statements, but I keep getting excess rows.
Code:
SELECT st.Campaign, st.Month, st.Week, st.Placement, st.[Placement ID],
IIf(InStr(st.placement, ic.[findInventoryCategory]) > 0,ic.[InventoryCat],"N/A") AS [Inventory Category],
IIf(InStr(st.placement, pth.[findPathway]) > 0,pth.[Pathways],"N/A") AS [Pathway Name]
FROM RawDataFile AS st, mpInventoryCategory AS ic, mpPathway AS pth;
I have code to open a new email and populate the BCC field. My problem is the company usually uses a template for all emails they send, from access how to I het outlook to use the the usually template?
Thanks
Paul
Hi all,
I am performing the following query using an ADO connection from Excel;
SELECT [Date], SUM([Batch Qty]) As [Batch] FROM [Speed Fastener Packing] WHERE ([Date] BETWEEN #03/04/2006# AND #05/04/2006#) GROUP BY [Date] ORDER BY [Date]
When I execute this statement in Access it generates The following;
Date Batch
04/03/20063463000
06/03/20062747000
07/03/20062738000
08/03/20063867000
09/03/20064970000
10/03/20066235000
11/03/2006757000
13/03/20062170000
14/03/20063864000
15/03/20066929000
16/03/20063342000
17/03/20067017000
18/03/20063440000
20/03/2006985000
21/03/20064330000
22/03/20067578000
23/03/20064367000
24/03/20065003000
27/03/20063726000
28/03/20064383000
29/03/20066367000
30/03/20064358000
31/03/20064840000
01/04/20063136000
03/04/20061102000
04/04/20063000000
05/04/20065724000
06/04/20061687000
Why is the statement returning results that are not between the dates specified?? The [Date] field in the Db is in format Date/Time Short Date dd/mm/yyyy.
Dont have a clue what I'm doing wrong! TIA, any ideas appreciated!