Very Computer

> > Hi,

> > 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.

> > Thanks
> > SteveB

> Steve,

> 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
> learning curve).

> 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
> important..
> 3. "Visual Basic 6" by Patricia Hartman, PhD, Wiley
> Publishing, Inc, $29.99.
> 2. "VBA Developers Handbook Second Edition", Ken Getz
> & Mike Gilbert.
> SYBEX, $49.99
> 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,
> and also,
> Comp.lang.basic.misc. If you have a problem, post it. You will
> get help.

> 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
> "things".

> Good luck.

> 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.

> Thanks
> SteveB

> > Hi,

> > 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.

> > Thanks
> > SteveB

> As I remember it, MS Office Developers Edition comes with the Access
> Runtime programs you need to run Access on a computer which doesn't
> have Access installed.

> Ron
> --
> Ronald W. Roberts
> Roberts Communication

> To reply replace the zeros with O's