Posted and mailed.
> We have an access database, which I set up that is quite
> happily running in a multi-user environment, has the usual
> array of tables, forms (some with VBA some plain), queries,
> reports and modules. The problem is that we recognise now
> that other offsite locations could make good use of the
> database but not all have or need the full MS Office suite,
> we don't want to use MS Developer as we have several db's
> we could use in other locations. I have been asked to have
> a go at using VB, we currently have a copy of VB6 I copuld
> use and are willing to buy Visual Studio .Net if it makes
> it easier for me. I have very little VB experience, I don't
> even know how to get the tables written in VB! so can
> anyone suggest
> a) What are the biggest problems I may encounter (excluding
> lack of experience)
> b) Is there a good book I can buy to help me
> I really do want to have a go at this and can try a simpler
> db first.
I was, and still am in the situation you find yourself in. I
have made my living off of Access for ten years this month
beginning with Access 1.1 and now using A2k2. I was recently
asked by a client to convert an application I had written for
them to VB 6 and they were willing to compromise the delivery
time for a reduced payment schedule (only fair for an extended
Well, I am at the 3/4 mark, and the client is happy, I am
having a wonderful time, and realized I can still learn.
I am relying on five resources and have found them to be quite
sufficient to get through whatever problems I have
encountered. The first 3 are books..in order of least to most
3. "Visual Basic 6" by Patricia Hartman, PhD, Wiley
Publishing, Inc, $29.99.
2. "VBA Developers Handbook Second Edition", Ken Getz
& Mike Gilbert.
1. "Programming Microsoft Visual Basic 6.0", Francesco
Balena, Microsoft Press, $59.99.
And then there are two newgroups. The one you are reading now,
Comp.lang.basic.misc. If you have a problem, post it. You will
And, as you learn, you will find yourself going back to change
some of your methods; for one of the most intriguing aspects
of VB is that there are so many ways to do a finite number of