I think you need to know, how to make a good DATABASE first, then
after that you can jump to programs. You'll find the way !!!
Bye . . .

i know how to make a good database...but i have never used vba before, and i have no idea how to use it :)

MMC, thanks for all the help, really appreciate it :)

Okay, the wizard should write all this code for you. If you want to see what it has written, in Design View, right click the button, open Properties, then select the Event tab, and you will see [Procedure] written in the On Click line. Click the elipses button to the right of the line [...] and VBA will open showing the code for that button, and for all the other items on the form.
Hope that helps.


mmcdonal

PMJI, but your original post about needing more than 100 tables proves you don't know much about databases, either. You should go purchase a good database design book - I highly recommend Database Design for Mere Mortals.


John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"

Yeah, a good design book should be very helpful. Taking the time to lay a good foundation (knowledge-wise) will make Access much more enjoyable, make your solutions more powerful, and decrease the frustration level considerably. A quick count of books at my desk shows:

Access: 8
SQL: 2
Scripting: 4
VB.NET: 1
C++: 1
ADS: 1
VBA: 2
Windows XP: 3
Office XP: 1

   And that's just at work. I have that many at least at home. The first ones I got I read cover to cover, and after that I didn't read all of each one, but they are essential for references.

   Listen to the author dude.

mmcdonal

MMC, do you use any chat services like IRC, or msn i can contact you on for further help?

and dam, thats a lotta books :|

Email me and I will give you my msn name.

mmcdonal

i sent an email :)