Find Jobs
Hire Freelancers

Some Access DB edits to merge with a word document

$30-250 USD

Completed
Posted over 11 years ago

$30-250 USD

Paid on delivery
If you know Access, Excel, Word 2007 and vba, this one will be easy for you! just need you to create a db with a form for entering based on this excel file I have. I'll be able to select a person and all the items for that person will show up in the form to enter. Then when a button is hit, it will save that form's data to another table with a unique id and also merge that information to a word document. I ALREADY HAVE THE MERGE CODE FOR THE WORD DOCUMENT and the WORD DOCUMENT IS ALREADY MADE. All you have to do is design the database and fit the merge code in. I estimate around 5 hours of work. Thanks Thanks! Here are detailed notes: Start with the basics Then to merge 0. put in all the fields from the tables in the forms. 1. inv form Choose client dropdown: a) -dropdown linked to client table -displays nameuse b) -fills in monthrecur subform -fills in currentexpenses subform -fills in client history subform - fills in special message - fills in for 2. Monthrecur subform (editible) - item(s) that gets added everymonth - if an inv has been generated with it in it, that monthrecur month gets set to YES (default no) 3. Currentexpensestemp (editible) - just a temp table - I can enter in values and it will store it there until the inv button is pushed 4. Client inv history subform (not editible) -client history shows every inv with month recur items, client name, inv num , currentexpenses items on one line that was created 5. Create inv button - creates the inv in inv table - only includes the monthrecur if check mark (include recur) is checked - if it includes the monthrecur, set the latest monthrecur month that is a "no" to "yes" (that will be the month indicated on the merged document and in the inv table) - includes every item in currentexpensestemp, currentexpensetemp table goes blank for that client, while those values get stored in currentexpenses table) - merges with word document -fills inv field: sent with the current date - 6. merge with word document procedure (attached word document) - merges with word document based on invID - creates word document in a special directory with the filename: [login to view URL]
Project ID: 4050727

About the project

16 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
i have a good experience of working with Access. Have developed 2 complete applications in MS Access
$50 USD in 3 days
5.0 (1 review)
1.4
1.4
16 freelancers are bidding on average $93 USD for this job
User Avatar
I have 20+ years of experience programming ms-access & sql server. At your disposal for any doubt or question, Regards Fabio
$95 USD in 3 days
5.0 (626 reviews)
7.1
7.1
User Avatar
Hi.. Expert database developer here. Assure you accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards
$100 USD in 5 days
4.9 (92 reviews)
6.4
6.4
User Avatar
Hi I am interested in this project. Ready to take up immediately.
$70 USD in 2 days
4.9 (137 reviews)
5.8
5.8
User Avatar
As discussed previously.
$180 USD in 4 days
5.0 (26 reviews)
5.5
5.5
User Avatar
Hello, After reviewing your project posting, I believe that I am well suited to fulfill the project's requirements and am thus submitting my credentials for your consideration. My development history in a nutshell... I have been designing and developing MS Access applications since its initial release back in '93. At the time, I was running the Legal Dept. at Logitech, Inc. and began by developing the Docketing and Invoicing system for one of the patent attorneys representing our company. I then left Logitech to develop full time. My first gig was with the Access Development team at Digital Equipment Corporation out of Livermore, California. There I worked on various projects for the silicon wafer manufacturers in the area. I then moved over to Hewlett Packard where I worked on an Oracle/Access application to control product data flow between their 40 plus manufacturing plants. During the next several years I continued to increase my expertise and to provide my services to a plethora of clients in the Silicon Valley area including: Chevron, E*Trade, First Republic Bank, Wells Fargo Bank, Bank of America, Bridge Bank, BEA Software, Baush & Lomb, HealthNet, and many, many more that can be seen on my attached resume. During this time I worked on applications within a multitude of industries including: Health Care, Banking, Insurance/Risk Management, Retail, Hotel Management, Real Property, Medical Reseach, Optical Care, Manufacturing, Technogy, Consulting, Education, Training, Charities, Chemical, Sales and Marketing, Governmental, Oil and Gas, Stocks and Bond trading, Construction, Recycling, Data Processing, Legal, and others. Thank you very much for the opportunity to bid on this project and I'd love to learn more about your project and to work with you towards making your requirements a reality. Many thanks, Drew
$125 USD in 3 days
5.0 (6 reviews)
5.4
5.4
User Avatar
Ready for this project. Long experience in developing DB in Access. Newbie to freelancer.
$30 USD in 1 day
4.9 (10 reviews)
3.9
3.9
User Avatar
Contact me when you want to start :)
$90 USD in 2 days
5.0 (8 reviews)
3.6
3.6
User Avatar
Dear ansales, I can help you quickly and cost effectively design and develop a Microsoft Access database/system that satisfies all of your requirements for your Microsoft Access database/system. I have been designing and developing Microsoft Access database(s)/systems for over fifteen (15) years. I look forward to hearing from you and working together with you towards the successful completion of your project soon! - Michael S. DeVries
$75 USD in 7 days
4.8 (2 reviews)
3.3
3.3
User Avatar
I can help
$100 USD in 3 days
5.0 (8 reviews)
2.6
2.6
User Avatar
I have 4 years experience in Excel VBA development. I can finish your app soon with high quality.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I don't have a degree or anything fort his, but I have done it before, and I can give ti a go for you.
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Am Chilean Programer, and i think's is very easy make you DB. hope you contact.
$150 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working in Microsoft Access from 6 years as database administrator.
$55 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am an advanced Access developer who works for both small and large organisations. I can do this task quickly and accurately should you so desire.
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
May I help you ?
$125 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Mississauga, Canada
5.0
182
Payment method verified
Member since Apr 19, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.