Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 3rd, 2007, 10:47 AM
Registered User
Join Date: Jan 2007
Location: Beverley, , United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Where do I start - HELP !!!!

I am new to this site in the hope I can progress further. I am currently doing a course - MCDBA (Microsoft Certified Database Administrator), and having swiftly passed through the Step by Step Access book, I find myself unable to get to grips with 'Access 2000 VBA', I just don't get it, and don't get me wrong I have read through the first few chapters with no problem, then I hit the code, I just do not get it, and cannot therefore do the solution at the end, and for some reason I can see the solutions on my CD it just freezes, is there anywhere that has the solutions. Or is there an easier way to learn. I may as well be learning Japanese it seem that difficult, but I so want to learn this, as I can only develop my databases so far without VBA for access. PLease someone HELP!!!

  #2 (permalink)  
Old January 3rd, 2007, 12:19 PM
Authorized User
Join Date: Nov 2006
Location: Seattle, WA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts

Learning a new language in this case, VBA is like anything else. I have been working with Access for a number of years but I never really did any programming. What I mean is, I did the DoCmd.blah kind of stuff and copied and modified code. But, just recently I have been working through a book that has really helped me to really understand VBA. It's called Microsoft Office 2003 Programming by Example with VBA, XML, and ASP by Julitta Korol. It's published by WordWare Publishing. ISBN-13:978-1-55622-223-8, dated 2005.
It has over 300 exercises and explains everything quite well.

It's geared for the Introductory to advanced user and should get you on the road to understanding all of the ins and outs of Access VBA.

Good Luck!!!



  #3 (permalink)  
Old January 3rd, 2007, 09:07 PM
Friend of Wrox
Join Date: May 2006
Location: San Diego, CA, USA.
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts

There are a lot of things you can do to help you get through this.

Posting to forums like this can bring help, so that is a good start.

I would also suggest that you search around for developer user groups near you. These groups typically meet monthly, and there are usually people at these meetings who are helpful. There are no "rules" about what these groups do - but they usually have presentations of interest to developers, and sometimes there are beginners sessions, as well as study groups. Each one is different.

You can probably also find an instructor lead tutor at a college or learning center near-by. There are also various courses on-line. Here in the US we have community colleges that provide both on campus and online courses.

Trying to do this on your own is possible, but when you are just starting out it can be very helpful to find someone who can help you "in person".

It will seem very difficult at first, and it might take a long time to get through this, but don't quit. You will eventually start to understand how to make things work. But also, you have to understand that this is a subject that will require constant study - you never "know it all" - there is just too much to know, and things are constantly changing, so you have to be able to "learn how to learn", and to keep yourself motivated and interested.

Have fun!

Woody Z
  #4 (permalink)  
Old January 4th, 2007, 05:55 AM
Registered User
Join Date: Jan 2007
Location: Beverley, , United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Thank you kindly for your replies, I really do want to continue and learn, I feel at 29 my life has gone nowhere really, and am in a low paid job that doesn't really stimulate me, yes I have introduced loads of access based databases to my company and now run along side the current in house systems, but I want to know more that what the wizards and standard building tools can do, and eventually try and design my own systems to sell to companies. YES I will continue, and hopefully success may follow.

  #5 (permalink)  
Old January 4th, 2007, 02:49 PM
Friend of Wrox
Join Date: May 2006
Location: San Diego, CA, USA.
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts

You will do fine. One little step at a time. You are at a good age to make changes - you have enough life experience to know what you want to do, and how to focus on something and make it happen.

Here is my own story, and it at least shows that it can be done.
My first 15 years in programming I was pretty much on my own - I didn't have time to take any classes (and there was no internet, and not many colleges offered programming courses), and I had a lot I wanted to do with software that wasn't available commercially in those days - so I learned to write it myself. I studied books and did a lot of experimentation. I was about 29 at that time myself. Those first 15 years I was mostly programming applications that I used in a business I owned that had nothing to do with software, but I became more and more interested in the programming so I switched to that being my main focus. The last 10+ years I've been programming for a living as a consultant or contractor, and now as an employee where I work as a senior software engineer. So - it can be done. And I work with a lot of other programmers who have followed a similar path.

Sometimes I would come to a wall that I couldn't get over - something I couldn't figure out and couldn't get help on - I just worked on learning or doing something else while waiting for my knowledge to catch up with what I wanted to do. I read every book I could get my hands on, and slowly gathered up what I needed to know - but all the while I was writing useful applications that helped me in my everyday work. Everything you can write that works and moves you along is good. The rule for me is don't let anything get in the way of progressing - just keep plugging ahead.

Have fun

Woody Z
  #6 (permalink)  
Old January 10th, 2007, 04:56 PM
Friend of Wrox
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

Perhaps you could give some of the code you are running across that stops you. then someone could explain it, and that would serve as a Rosetta Stone for you.

All programming (to belabor the obvious--or would that be belabour for you?) causes the processor to carry out instruction is a sequence. There have been some clever tchnologies to establish more than one chain of instructions to run at a time, so it often appears more complicated, but at the core the processor still runs one instruction at a time.

For the most part, a running program reaches out and runs encapsulated groupings of code called routines. Sometimes these routines merely run then quit (those are declared by the programmer as Subs), and sometimes they return a result (those routines are declared as Functions by the programmer). The exception to this is event-driven programmin--more in a minute.

By return a value, I mean that the routine would be used as the righthand side of an assignment operation. Consider a Function called Get_A_Value() which “returns” an integer. It might be used like this:
    Dim iVal As Integer
    iVal = Get_A_Value()

OK. So the idea is that the running code reaches out for info, and to take actions. The exeption to this is a gizmo that raises events. The first thing you are likely to encounter that raises events is a control. And they raise a lot of events!

When an event is raised, a routine that is designed to respond to that event is notified that the event has occured, and the routine runs.

Take as an example the click event of a button. Clicking the button does not actually run the routine, per se. This is made clear by the fact that you can delete the routine, without causing the button to cause an error when it is clicked; it still raises the event, but no routine responds. If clicking a button actually ran the click-respond code, and you deleted that code, there would be an error, "Sub or Function not found."

You could think (metaphorically) of raising an event as similar to raising a flag into the air. Anyone who is lookning can respond to the fact that the flag has been raised.

The reason that I go into such detail here is that it was completely baffling to me how to find an “entry point” for code I wrote in Access until I finally got it. As it turns out, far and away the most common means of entry you will be using is events related to controls. Clicks, GetFocuses, Changes, etc. Even code that runs “automatically” often is responding to the event raised by a form opening.

Hope that helps you get a model in your mind for what happens with the VB you are reading.
  #7 (permalink)  
Old January 10th, 2007, 05:15 PM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

I believe Winston Churchill said it best: "If your going through hell, keep going." All programmers have their stories about how they got started and, in turn, they each have their own horror stories or bumps in the road that they have had to over come much like Woody said.

Like Woody, I was on my own for a long time, Internet documentation was far and few between and I live in area where Developers are a mythical breed so I did not have anyone to bounce ideas off of either.

Now, with more and more ppl using the Net there are copious tutorials for just about anything you can fathom and they are great...as a resource or learning tool and nothing more. The reason I say this is because I can liken programmers to that of guitarists, truly, programmers are becoming a dime a dozen because just about any one that can use Google can find a tutorial on how to do X and you don't really have to learn anything, just know where to plug in the code.

Strive to be the Hendrix or Claypool (ok so he plays Bass but is a damn good bass player) of the programming arena but, above all, have fun with it or it will consume you and you will come to resnt it.

Let us know if you need any help.


I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Similar Threads
Thread Thread Starter Forum Replies Last Post
Where do I start gcjetfan General .NET 1 November 19th, 2007 01:22 PM
don't know where to start timbal25 Access VBA 1 October 18th, 2007 02:17 PM
how to start MunishBhatia ASP.NET 3.5 Basics 3 October 1st, 2007 01:54 PM
how I start it?? italimeme JSP Basics 2 May 28th, 2007 02:07 AM
Don't know where to start......... Geneine Bugg BOOK: Beginning ASP 3.0 0 December 20th, 2006 12:00 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.