Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations danielledunham on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to learn VBA?

Status
Not open for further replies.

lgvelez

Technical User
Joined
Jun 6, 2000
Messages
108
Location
US
The company I work for will probably stay with Access 97 for quite sometime. I have not learned VBA, but do need to start using it now. I would love to use CDT, since at the hour that I get to finally do training, books and videos put me to sleep; however, all of the CDTs that I can find are for Access 2000. Is the difference between VBA5 and VBA6 that great?<br>Also, are VB5 and VBA5 related? (I do understand that VBA is a subset of VB.) I would really appreciate any suggestions. Thank you. <br>Laura Velez<br><br> <p>Laura Velez<br><a href=mailto:lauravelez@home.com>lauravelez@home.com</a><br><a href= > </a><br>
 
I have found that when I learned Visual Basic 6, I understood how to write VBA in Access and Excel much better.<br><br>SmartPlanet.com has Visual Basic courses that are excellent.&nbsp;&nbsp;They are also cheap.&nbsp;&nbsp;You might want to see if your employer will buy you a years subscription for $99 (I think that's the going rate now.) and then you can take as many courses as you want...&nbsp;&nbsp;all you have to do is buy the books.&nbsp;&nbsp;Or you can take the self study courses instead.<br><br>John Smiley has put out the best programming for non-programmers books I have ever seen.&nbsp;&nbsp;His series is called Learn to Program and they are available at Barnes and Noble and Amazon as well.&nbsp;&nbsp;Probably other books stores too.<br><br>Just my 2 cents.<br><br><br>Mary :o)<br>
 
Thank you for your reply Mary. Did you find any confusion between VB6 and Access 97, as far as programming language or syntax? <p>Laura Velez<br><a href=mailto:lauravelez@home.com>lauravelez@home.com</a><br><a href= > </a><br>
 
Not at all... VBA just has more functions for that application.&nbsp;&nbsp;You can build forms do many of the same things that you can in VB6.&nbsp;&nbsp;It really made it easier to understand where the coding goes.&nbsp;&nbsp;YOu really need to keep MSDN Library handy though.&nbsp;&nbsp;It is a great resource when you are trying to figure how to do things.<br><br>You might also &quot;study&quot; forums such as this to learn what other people do to resolve a situation.&nbsp;&nbsp;There are a lot of good ones out there that are very active.<br><br>HTH<br><br>Mary :o)
 
Thanks again, Mary, for your opinion. I value it very much. I purchased Keystone's Win2000 CDs, which are great. My husband, who is using Access 2000, is very pleased with them. My thought is to begin purchasing the Access 2000 Developer series. Pricey, but should be very good, and definitely repeatable as needed. My problem with books is that when I finally get to sit down to read, one paragraph later, my eyes are closed. <p>Laura Velez<br><a href=mailto:lauravelez@home.com>lauravelez@home.com</a><br><a href= > </a><br>
 
Hey!&nbsp;&nbsp;Me too!&nbsp;&nbsp;But if you get John Smiley's books, guarantee.. no sleepy eyes!&nbsp;&nbsp;He writes in story book format.&nbsp;&nbsp;The setting is a classroom (he's an actual professor at the university in Philadelphia).&nbsp;&nbsp;And has students that interact with questions and confusions just like a real classroom!&nbsp;&nbsp;<br><br>I liked his style because he kept me going and seeing what a real world program development was like because they actually developed a program for a retailer who needed something for his business but didn't have much money to spend.&nbsp;&nbsp;Kinda fun reading really.<br><br>Mary :o)
 
I have found John Smiley's books on Amazon.com, and will order the Intro VB Programming one. Thanks much for your help, and your advice. I am a 55-year-old grandmother, and am hoping I can accomplish again what I did 2 years ago when I studied hard, and passed four MS MCP tests in a row. I want to move into Access development, and hopefully get to pass the Access 2000 MCP test. Which version of Access are you using? This company has so much invested in Access97 databases, that they probably will now make the switch for quite a while. <p>Laura Velez<br><a href=mailto:lauravelez@home.com>lauravelez@home.com</a><br><a href= > </a><br>
 
Hey Laura!  I'm a grandmother too!  I'm 44.  I've only one MCP so far.  Wouldn't have gotten that if I hadn't been laid off of my job last year.  Job Service paid for my education and at least 3 tests.  So 2 are still prepaid for me to take.<br><br>Gonna be working on getting the Win 2000 ones soon.  That's pretty impressive your passing 4 tests!<br><br>Where I work (my "customer's" ... I'm outsourced), they are still using Access 97.  But at home I use Access 2000.  But the company I work for is using Access 2000.  I got lucky enough to get to develop a database for one of my co-workers there.  So I've been really getting into it a lot lately.  <br><br>I want to be a database developer "when I grow up."  *G*  Right now my job is doing statistics for a major computer company on how often their files get downloaded.. among other things...  I've been pushing them to give me database type jobs when they come available.<br><br>Good luck with learning VB6 in John's book.  BTW:  his web site is <A HREF=" TARGET="_new"> LOL!)  He's a great guy and teacher.  I've had a few opportunities to chat with him.<br><br>Mary
 
I have worked as a contractor for years, but this company wanted hire only ... however, the benefits are **wonderful** and it's an old established company. However, because it's manufacturing, it's prone to cyclical layoffs; I do not think that that will effect me. I am probably going to stay here for maybe a year to build my advanced Access skills, then go back into contracting. My friend who is a contractor for this company is building the big chunk of this database. A large part of my job is being the Database Administrator for a 7 X 24 Access database. Its problem is that it started out to be a small, group database, and now is huge, but still has the small system architecture. We really need to start all over again, but the mere thought is causing hysterics.<br>I am really enjoying our conversation. Do you think we need to take it off the forum? <p>Laura Velez<br><a href=mailto:lauravelez@home.com>lauravelez@home.com</a><br><a href= > </a><br>
 
Hey sure!  I'm getting a kick out of chatting with you too.<br><br>It so easy to get caught up and forget where we are when we chat! *G*  <br><br>Mary :o)<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top