Need VBA in a database - but cant think what for

[crazymarvin]

I have a simple database - 4 tables, 10 records in each. It's for a fictional company called DC Glass; it holds customer information and order information. I need to put some sort of VBA in it; I want to know what I could use VBA for (no matter how useless it would be in relation to the intended purpose of the database).

This is for part of an assignment I'm doing in college - I havent had a tutor for about three months and when he was there didnt teach us any VBA, despite the fact we need to know it....

you wouldnt think a tutor in a college would be too much to ask for, its like a bar without beer

any ideas would be great, or any examples/good websites on VBA would be good

so far the best idea ive come up with is a few message boxes, I know a good bit of VB .NET, so im hopeing ill be okay with writeing VBA code
Many thanks

 

[boblarson]

If you just look through some of the recent posts in the VBA category, I"m sure some ideas will come to you.

 

[geekay]

Dont think that "I want some VBA for the sake of VBA". VBA is needed when you can not do something in the natural way. First you must feel the need for something. You are not feeling this only because you have little imaginations regarding your project. Once you imagine for something and you find that it can NOT be done by your existing knowledge you will feel the need for vba.
There are various occations that u need VBA
some simple things first...........
> want your own close button apart from the close button on the title bar of a form
> for a groups of values in a control (say textbox control) another control (say a command button) should be disabled and for another group this must be enabled
> want to load a record into the controls of a form which depends on a value you enter in a textbox control
> The changes you apply in a forms controls must be saved into the database only after you click a save button in the form
> want to create a function which returns something as per your needs
Eg: A textbox control shall be loaded with a date in words such as "Tenth June Twenty hundred and seven" while the the date saved in the database is in dd/MM/yyyy format only.

Always assume that you are not the end user of your project. You are doing it for some others who has very little knowledge about RDBMS

I hope this is enough for a start