Need Help Generating Reports in MS-Access

I have a very basic MS-Access database. It is basically comprised of Donors and Donations. I have been able to generate reports of the donations a donor has made between X date and Y date but I need help generating individual annual reports for each donor.

There is one caveat. Donors have an attribute called 'ReportPreference' which is set to either Mail or Email. If ReportPreference is set to Mail, then the report needs to be printed. If ReportPreference is set to Email, then the report needs to be emailed (with the To: field set to the Donor's email address). I have done been able to do this for the reports described in the first paragraph but I have no idea how to write the VBA required to Loop through to generate the annual reports for every donor AND include this logic as well.

Additionally, if the VBA could set the email to send via gmail instead of Outlook, that would be -amazing- but not 100% required.

Kemahiran: Pengaturcaraan Pangkalan Data, Microsoft Access, SQL, Visual Basic

Lihat lagi: how to create report in ms access, reports in access 2013, how to create a report in access 2013, access reports advanced, access report design, microsoft access reports examples, types of reports in ms access, how to create a report in access 2016, ms access sql server 2012 excel 2013 vba vba excel reports,, ms access sql server 2012 excel 2013 vba vba excel reports, i need help to write an article, i need help to write a report, need help generating leads, need help access, need help someone write book, need help write book, prepare reports ms access, hot migrate reports ms access net crystal report, generate ppt reports ms access, creating forms reports ms access

Tentang Majikan:
( 4 ulasan ) Omaha, United States

ID Projek: #16366471

21 pekerja bebas membida secara purata $70 untuk pekerjaan ini


A proposal has not yet been provided

$30 USD dalam sehari
(95 Ulasan)

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel de Lagi

$133 USD dalam 3 hari
(49 Ulasan)

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. I can do your all requirements that 1. Pdf reports with date range crit Lagi

$30 USD dalam sehari
(55 Ulasan)

Yes, the report will be composed on Outlook for each donor. Other will be printed on the printer on bulk. I hope you are using MS-Access 2010 or higher. Thank you.

$120 USD dalam sehari
(9 Ulasan)

I believe that my bid is sufficient to finish this project on time and within your specifications. We can still adjust the price depending on the actual difficulty of the project. I've been using MS Access for my perso Lagi

$25 USD dalam sehari
(47 Ulasan)

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Lagi

$30 USD dalam sehari
(8 Ulasan)

please send the database and clarify the report template: i can implements all noted question and can send first draft for your test within 4-5 days

$250 USD dalam 7 hari
(15 Ulasan)
$25 USD dalam sehari
(12 Ulasan)

Hi, I am a professional MS Access developer with 5+ years of experience. I can complete your project within 3 hours today. I am ready to start your project now. let's have a chat and get a clear idea about my knowled Lagi

$66 USD dalam sehari
(13 Ulasan)

VBA code tested and ready to use. I can help you and work full time. Free support after release.

$25 USD dalam sehari
(2 Ulasan)

Greeting, I have understood your Generating Reports in MS-Access task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database Programming Lagi

$200 USD dalam sehari
(2 Ulasan)
$111 USD dalam sehari
(3 Ulasan)

A proposal has not yet been provided

$66 USD dalam 10 hari
(6 Ulasan)

Hi I am a Technical Lead in an MNC in UK. I do support on an app developed in MS Access. This is my first bid in freelancer, please grants me an opportunity to deliver your project. Cheers Imran Relevant Skills and Lagi

$35 USD dalam sehari
(0 Ulasan)

It is possible for Access to send emails via Gmail. Do you have a generic Gmail email account (other than your personal email account) to use? I ask because it will need to be coded into the VB script itself. Also, Lagi

$50 USD dalam sehari
(1 Ulasan)

Hi, I'm an IT Consultant with over 15 years of experience delivering both small and large software solutions, using various technologies. I am based in Brisbane, Australia. I have years of experience with MS Access Lagi

$20 USD dalam 5 hari
(0 Ulasan)
$25 USD dalam 3 hari
(0 Ulasan)

I have developed Information System projects using Visual [login to view URL], C#, and Microsoft Access. My experiences will create faster results with the most advanced techniques. There will be progress reports for any comple Lagi

$25 USD dalam sehari
(0 Ulasan)
$111 USD dalam 4 hari
(0 Ulasan)
$55 USD dalam 2 hari
(0 Ulasan)