Need Help Generating Reports in MS-Access

Ditutup Dipasang 6 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

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.

Pemrograman Database Microsoft Access SQL Visual Basic

ID Proyek: #16366471

Tentang proyek

19 proposal Proyek online Aktif 6 tahun yang lalu

19 freelancer rata-rata menawar $61 untuk pekerjaan ini

VladimirLilenko

A proposal has not yet been provided

$30 USD dalam 1 hari
(261 Ulasan)
7.1
zu02

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 Lebih banyak

$133 USD dalam 3 hari
(70 Ulasan)
6.5
jonathanpradas

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 Lebih banyak

$25 USD dalam 1 hari
(70 Ulasan)
5.8
havit

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 1 hari
(12 Ulasan)
5.6
VBAautomation

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 Lebih banyak

$66 USD dalam 1 hari
(42 Ulasan)
5.8
SergeyKyiv

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 Lebih banyak

$30 USD dalam 1 hari
(10 Ulasan)
4.6
Carlosemadrizmor

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

$25 USD dalam 1 hari
(3 Ulasan)
3.6
whitehorsetechn

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 Lebih banyak

$200 USD dalam 1 hari
(3 Ulasan)
3.9
bnrajumnc

A proposal has not yet been provided

$66 USD dalam 10 hari
(6 Ulasan)
3.4
imranparvejsk

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 Lebih banyak

$35 USD dalam 1 hari
(0 Ulasan)
0.0
pnkfld11

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 Lebih banyak

$20 USD dalam 5 hari
(0 Ulasan)
0.0
ahapng7788

A proposal has not yet been provided

$30 USD dalam 3 hari
(0 Ulasan)
0.0