VBA/MS Access database optimization

I have an access based contacts database that comprises UI as well. I need a VBA / MS Access expert to analyze/optimize the VBA codes in the DB.

Also, there is a functionality that has to be updated, which can trigger the change in DB structure and source code accordingly. This functionality shows if a postcard was sent to the selected manager’s contacts in a specific year and provides an option to check the checkbox in a field, if the postcard needs to be sent current year as well.

Currently, the selected year information is in one subform and beneath there is another subform with current year and list of contacts. But, I want to have them in one subform that will have 2 different columns – [Selected_Year], [Current_Year].

Skills: Microsoft Access, Visual Basic, Visual Basic for Apps

See more: create report template via vba access database, use vba read spreadsheet access database, importing excel file access database excel vba, ms access performance, cool things to do with microsoft access, how to speed up access database on a network, microsoft access 2016 tips and tricks, microsoft access 2013 tips and tricks, access query slow, optimizing microsoft office access applications linked to sql server, access database slow over network, export excel file access database excel vba, vba open access database, access database microsoft project using vba, vba access database multiple users, csv access database vba code, access database required field vba, access vba import append data access database, vba code ole object pdf access database, vba access database counter type

About the Employer:
( 58 reviews ) Freiburg, Germany

Project ID: #17818174

Awarded to:


Hi, my name is Mark. I have 20+ years of expertise with MS Access, Excel, VBA and SQL Server and will be happy to work on your project. I've designed, developed and maintained many Access applications and am well-verse More

€75 EUR in 2 days
(14 Reviews)

15 freelancers are bidding on average €74 for this job


Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years o More

€100 EUR in 2 days
(146 Reviews)

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Access because this is my favorite field and MS Access projects are among the tasks I work wi More

€80 EUR in 3 days
(149 Reviews)

Let me review the database to calculate the appropriate duration and cost as well. 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 requ More

€30 EUR in 1 day
(74 Reviews)

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access More

€77 EUR in 3 days
(49 Reviews)

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you with More

€70 EUR in 1 day
(70 Reviews)

Hi, I'm an Access / VBA expert developer and can make the required changes / modifications to your Access database, and can deliver in 1 week or less. Will make the required change to the form, and check / optimiz More

€80 EUR in 10 days
(38 Reviews)

Hello and Good day, I would like to help you on your project. I have been using MS Access for a long time now developing applications for business or personal uses. Feel free to message me so that we can talk more abou More

€48 EUR in 10 days
(53 Reviews)

Hello, I am an expert on MS Access, Excel, VBA, SQL and other Office applications. Please see my portfolio on the below Dropbox link. [login to view URL] Thanks, More

€100 EUR in 2 days
(18 Reviews)

I am very able to optimize the vba/access database flawlesdly as prrvyour requirement. I am ready to start. regards

€78 EUR in 3 days
(5 Reviews)

Please review my profile I am working with skills that you required for this job for 16 years. I am working with MS Access, Excel, MS SQL, VBA and .Net for a long time. I can definitely help you with this job, to ma More

€111 EUR in 3 days
(4 Reviews)

I have briefly read the description on vba-access-database-optimization development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well More

€80 EUR in 4 days
(0 Reviews)

I am expert in VBA and DB. please provide all file and screenshots of your project.

€76 EUR in 2 days
(0 Reviews)

I am working with Access almost every day. I cani work on your project 1 or 3 hours per day, in the evening.

€48 EUR in 6 days
(0 Reviews)

Hi! I am very interested in working on your project. Regarding the code, I offer you a simple and elegant solution. I have 20 years of experience with MS Access and VBA. I'm open to improve my offer in terms of price More

€50 EUR in 3 days
(0 Reviews)