Automation - - Car Database 1

[HiT]

Hi I am writing this out of desperation due to time limitations!!

Can any one help ? Anything will be something! Thanks.

I need to design a automated database but am a total beginner any tips on VBA code or hints would be most appreciated.

What I need:

1 An access database with car details (a simple database is sufficient) e.g Car_id, Company, Model, Price. (001, Lexus,IS200, £21,000) which I have tried to create.

2 VBA automation code for transferring price information from the database to the spreadsheet and loan repayments from the spreadsheet back to the database. (The spreadsheet I have created already using the built in PMT () function)

The spreadsheet works out payments on loans the spreadsheet gives the schedule for a £15000 loan at 7.2% over 2 years. The loan amount is put into cell B2.

3 Automated word letter for revised payment schedule.


Thank you in Advance for any help you can offer me.

HiT
hit79@hotmail.com

 

[RickSpr]

I'm afraid this is not a beginner project, so in effect you're asking paid professionals to work for you for free. I don't think you'll have much success with that approach.

See if you can do some of the design work yourself, and bring specific problems here. We don't mind taking a few minutes to help somebody learn--that's what we're here for--but asking us to do your design for you is too much. Rick Sprague

 

[Gzep]

Hi.

I agree with Rick, I won't write it for you.

BUT: lookup office automation objects, they let the different parts of office "talk" to each other from code.
Look also at the fact that you can embed a spreadsheet into Access, and there is an active-X object that is an RTF "textbox", where you can use a saved copy of a letter, and add the fields, colours of text and fonts that you like right within Access!!!

Still not a beginners project! Maybe layout your data so that you can cut-and-paste between apps will get you started.

Gzep.