Looking for some vba examples

[mac]

I am new to VBA and am trying to learn VBA.

I need to create a screen where user will enter their part number and click
enter.

I looking for syntax for finding a record and also syntax for opening a
table or tables.

Thank you

 

[Lance McGonigal]

Mac...I learned by getting the Building Applications with Access 97 Book
from the Internet/Microsoft's web site. It covers everything you need to
know. That's where I'd start. All the code example you need are there and
will work through the latest copy of access (2003).

Bless you.

 

[Wayne Morgan]

Try the Access Developers Handbook and VBA Developers Handbook. You can find
information here.

www.developershandbook.com

 

[Todd Lemen]

Hi, Mac.
If yo learn best "hands on", try Microsoft
Press "Fundamentals" books. For example, "Access 2000
Visual Basic for Applications Fundamentals". Good
exercises to help you get started!

TL

 

[mac]

Thanks Lance, Wayne and Todd.

My database is in SQL2K. I hope same examples will apply to sql as well,
ofcourse with minor modification.

Thx

mac