Đã Đóng

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.

Kĩ năng: Lập trình cơ sở dữ liệu, Microsoft Access, SQL, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 4 nhận xét ) Omaha, United States

ID dự án: #16366471

21 freelancer đang chào giá trung bình $70 cho công việc này

VladimirLilenko

A proposal has not yet been provided

$30 USD trong 1 ngày
(95 Nhận xét)
6.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 Thêm

$133 USD trong 3 ngày
(49 Nhận xét)
6.1
royalcalif

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 Thêm

$30 USD trong 1 ngày
(55 Nhận xét)
5.6
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 trong 1 ngày
(9 Nhận xét)
5.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 Thêm

$25 USD trong 1 ngày
(47 Nhận xét)
5.2
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 Thêm

$30 USD trong 1 ngày
(8 Nhận xét)
4.6
AlexandrUKR

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 trong 7 ngày
(15 Nhận xét)
4.6
$25 USD trong 1 ngày
(12 Nhận xét)
4.0
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 Thêm

$66 USD trong 1 ngày
(13 Nhận xét)
4.2
Carlosemadrizmor

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

$25 USD trong 1 ngày
(2 Nhận xét)
3.0
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 Thêm

$200 USD trong 1 ngày
(2 Nhận xét)
3.7
$111 USD trong 1 ngày
(3 Nhận xét)
3.3
bnrajumnc

A proposal has not yet been provided

$66 USD trong 10 ngày
(6 Nhận xét)
3.2
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 Thêm

$35 USD trong 1 ngày
(0 Nhận xét)
0.0
HawkGuyIA

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, Thêm

$50 USD trong 1 ngày
(1 Nhận xét)
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 Thêm

$20 USD trong 5 ngày
(0 Nhận xét)
0.0
$25 USD trong 3 ngày
(0 Nhận xét)
0.0
limasuhendra

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 Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
$111 USD trong 4 ngày
(0 Nhận xét)
0.0
$55 USD trong 2 ngày
(0 Nhận xét)
0.0