I found the vba to generate multiple pdf's from a single report which is working well (see below).
The script below generates about 15 pdf files and stores them in the specified directory
I'd like to be able to now email these to the individual users (SCNAME) but cannot work out where to start, i've tried a lot of things from the research on emailing, just not working.
All the information I need is in one table which includes the users email address field (SCemail).
I've also created an update query which generates a unique file name into the field (SCInstallDate) (currently not using this field data)
Code:
Private Sub cmdSC2PDF_Click()
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("SELECT DISTINCT [SCNAME] FROM [Schedule];", dbOpenSnapshot)
Do While Not rst.EOF
strRptFilter = "[SCName] = " & Chr(34) & rst![SCNAME] & Chr(34)
I am trying to make an automation in order generate reports based on query ( person name,person email address ) , export them to a folder in PDF and then send them one by one to each person email address.
What is happening:
- the reports are generated and exported fine - the email are sent to the right addresses but the first person receives the correct report , the second person receives the report from the first person plus its own report and so on.
Here is my code :
Private Sub MakeReportSendEmail_Click() Dim MyDB As DAO.Database Dim MyRS As DAO.Recordset Dim strSQL As String Dim strRptName As String
I have to compile a report from more than two queries. All queries have a field common between them.
E.g. query1 gives name, address and contact number of all the 30 students in a class query2 gives semester wise marks obtained by each student query3 gives performance in sports of each student.
All the three queries have name of the student common in them.
Now I wish to generate a report card which should be as under:
1. The record of query1, query2 and query3 corresponding to a particular student should come together. 2. The record of query1, query2 and query3 corresponding to the next students should come after that and so on.....
I tried using a sub-report but it ends up displaying all the records of query1 first and then all the records of query2 and so on...
I have a report named PIRREPORTFORMD17792. Every time I try to print out a record, the MS Access 2010 uses PIRREPORTFORMD17792 as a default file name.Instead of using PIRREPORTFORMD17792 as a default file name for all the reports, I would like to use a field on the form for the file name. This field called PIRNO. This field will automatically generate a number whenever a new record is added.
If I am on a record shown PIR20014-0001, then I want the file name of this report (in PDF) to be PIR20014-0001.
I created a database to set-up contracts, record receipt and issue of drawings and generate procurement schedules for construction projects. The database has been in use for over a year and I have only now encountered an unforeseen problem, the fix for which is beyond my skillset. I am unable to generate the reports as I have done for the other projects in the database.
The problem is in the Drawing Registers section. When the drawings are issued, I have to log the date they were received, the drawing number, drawing title, revision letter/number and note any changes on the current drawing. The drawing number is the Primary Key and is linked to several other tables, forms, reports, etc. The problem I have now encountered is that Architects arent that creative when numbering their drawings and tend to use the same numbering sequence for each job. So I can have several jobs with the drawing number A01. I have managed to still keep this field unique by adding a prefix (either a job number or an abbreviation for the job name). This way I am not changing the actual drawing number. However, on this current job the Architect is using the numbering sequence A1, A2, A3A25. Because he is using A1 and not A01, the drawing register reports are not sorting the drawings in the correct order and drawings A10 is listed after drawing A1 and A20 after drawing A2.
I found a round-about way of getting the drawings sorted by adding a second field. The primary key would be my version of the drawing number where I can enter it in a manner that the drawings will sort; the new field would be the actual drawing number as seen on the drawings. The reports would be sorted by my field but this field will not be visible on the reports.Is there another way to sort these records?
these are combo selection and the report is working fine with these 3 filters. filtering by a query. all 3 feilds on the same table.what i am unable to do is make these filters as option to select with a check box. like if i dont want the third filter product but to generate report with the other two filters sales_person and client_name.
edt: uploading my DB Form report_generator on medical_request_query and table medical_requeset
Using a table with employees, I created another with equipment that uses a lookup to assign each piece of equipment to an employee (more than 1 piece of equipment can be assigned to each employee)
I want to be able to select records using a form, either by checkbox or listbox of which employees to include in the report that shows what equipment each is assigned. The problem I am having is creating the form/code to create the and/or query to generate the report.
I need to build such a report, Unfortunately, I do not know how to use VBA to create each group (grouping by type) had a different header.
The problem becomes bigger that everything must generate queries dynamically cross, the number of columns in a given type may vary depending on the number or the size of the products in which they occur.
I have a table called bookings, three records within that table are;
arrivaldate departuredate breakfast
This Table (Bookings) is linked to the guest table via GUESTID..Assuming that a guest arrive on the 5th and leaves on the 10th, I am trying to create a breakfast voucher for the guest for each day of their stay.
So 5 vouchers, 1 each for the 6th, 7th, 8th, 9th, and 10th.I have created the breakfast voucher as a report and a query to include data but I dont know how to propagate the new data to actually create the vouchers. All I can get is data for the arrival or departure fields.
I have created invoices as reports but now I'm looking for a way to add an invoice number to it. It needs to be an auto increment number for every invoice for every client.
I have 10 different clients and I want them to have their own incremented invoice number. Every client has it own unique number. So for example in week 1 I want to have the following invoice numbers; 01-0001, 02-0001, 03-0001 etc. In week 2 I want them to be; 01-0002, 02-0002, 03-0002. It is important that every client has the invoice numbers without gaps.
I have made a query with the name "Confirmation" and it is setup like this:
Name trainee Email Training John John@mail.com Tr one Mary Mary@mail.com Tr two
I also made a button in a report with the title "Send Mail" now is my goal that if i press that button automatically multiple e-mail message's will be generated with data from people in that query. So if click on that "Send Email" button i want two different mails messages generated that will be send to John@mail.com and Mary@mail.com with in the mail body their data.
I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.
I have a main form (Parent) along with a subform(Children). I want to have a button that generates a report with the Parent information as a header and the items in the subform as details. In addition, I want the report to show only the children that were recently added not all of the children.
I want to be able to email a report to several individuals and have only the data that pertains to that person attached in the email? Is this possible?
I am using vista and access 2010, what I want is to be able to email a report from access that was created by a form with DoCmd.OpenReport "ReportOrder", acViewReport. I have a button that when i click it it will send the report via email, but the email address has to be a variable so when the report is created i can use the email that is attached to the report data.
Every month I have to make a report about registration of hours of a group of employees. (These employees have a deal with direction about travel hours vs. working hours).This report has to be send to the group members but only the data which is valid for the group member in it. There are 11 persons in this group so I have to send 11 reports.
I made a query with the hours registered from this group. I couldn't export it because it was read-only. That was because the query contains joins to the employee table. After that I tried it with a report. That nearly went well but it contained all data and not the seperated info.What I need to know:What is easier/better: use a query or use a report?Is there code which looks in my query or the report and makes it into seperated reports?I've tried the code of Tony Hine but I can't make it work.After that I need to do a mail-merge. But first of all do I need to make the seperated reports to work.
I am trying to send an Email from a report . Using this code
Code: On Local Error GoTo Some_Err Dim MyDB As Database, RS As Recordset Dim strBody As String, lngCount As Long, lngRSCount As Long DoCmd.RunCommand acCmdSaveRecord Set MyDB = DBEngine.Workspaces(0).Databases(0)
I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.
So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .
Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?
I have a form where we fill in information for supply of equipment to employees.
Each item must be signed for on a printed report.
I am encountering problems trying to create enough rows in my report detail for each signature of the items supplied.
For example, on the form I will select the "equipment" - 4 hats supplied and 3 boots. On the report I want the equipment set as the group and the detail to be a number or rows which equals the number of selected items. therefore under the Hats group heading I want 4 blank rows which are made up of 3 text boxes - Print Name, Signature & Date and another group heading for boots but with 3 lines.
I want to create a simple data base, in which I have to record Payments received from each customer on daily basis. and on daily basis i want to generate a report for the transaction I have made. example of data table is as follow. payment mode is cash or bank transfer.how to generate reports for day to day transaction.
I want generate and load the report using vba when a command button is clicked . (automating the report generation) For example i have table in access that has name, address and email fields and onced command button is clicked the report is generated and loaded.I be happy if some one show me wprking example.Thanks
I have the following very general question, but I hope you can give me a few hints so I can start and find things out on my way.
I just created a database which via VBA procedures runs all kinds of queries and puts the results in tables, for instance I have about 20 tables now with 10 fields each and for every table I want to run the same type of report. I already made one report for one table via the report wizard, I would like to use the layout of this table for all other tables using a VBA code, so when I run this code it will create all these reports for me. What is the best way to start?
i have two combo box, one is cboMonth and one is cboYear. i am trying to get the values from these 2 combo box, and used the value to generate report. however, when i click the btnPrintSummary button, system keep prompting me to enter parameter value.
Code: Private Sub btnPrintSummary_Click() Dim stDocName As String Dim stWhere As String Dim blnTrim As Boolean
