Need Help Generating Reports in MS-Access

Imefungwa Ilichapishwa Miaka 6 iliyopita Kulipwa wakati wa kujifungua

$10-30 USD

Kulipwa wakati wa kujifungua

Imefungwa Kulipwa wakati wa kujifungua

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.

Kuprogramu Database Microsoft Access SQL Visual Basic

Kitambulisho cha Mradi: #16366471

Kuhusu mradi

19 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

19 wafanyakazi huru wanazabuni wastani wa $61 kwa kazi hii

Picha ya Profaili ya VladimirLilenko
VladimirLilenko

A proposal has not yet been provided

$30 USD kwa siku 1
(Maoni 261)
7.1
Picha ya Profaili ya zu02
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 Zaidi

$133 USD kwa siku 3
(Maoni 70)
6.5
Picha ya Profaili ya jonathanpradas
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 Zaidi

$25 USD kwa siku 1
(Maoni 70)
5.8
Picha ya Profaili ya havit
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 kwa siku 1
(Maoni 12)
5.6
Picha ya Profaili ya VBAautomation
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 Zaidi

$66 USD kwa siku 1
(Maoni 42)
5.8
Picha ya Profaili ya SergeyKyiv
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 Zaidi

$30 USD kwa siku 1
(Maoni 10)
4.6
Picha ya Profaili ya Carlosemadrizmor
Carlosemadrizmor

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

$25 USD kwa siku 1
(Maoni 3)
3.6
Picha ya Profaili ya whitehorsetechn
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 Zaidi

$200 USD kwa siku 1
(Maoni 3)
3.9
Picha ya Profaili ya bnrajumnc
bnrajumnc

A proposal has not yet been provided

$66 USD kwa siku 10
(Maoni 6)
3.4
Picha ya Profaili ya imranparvejsk
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 Zaidi

$35 USD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya pnkfld11
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 Zaidi

$20 USD kwa siku 5
(Maoni 0)
0.0
Picha ya Profaili ya ahapng7788
ahapng7788

A proposal has not yet been provided

$30 USD kwa siku 3
(Maoni 0)
0.0
Tuma Mradi Kama huu