Hello,

I''ve written some software in Mircosoft Access97 and would like to take it
out of VBA and into Visual Basic.

Are there any decent software programs out there which can automate most of
this?

Any advice would be appreciated!

Kelsy

No advice, but I'm about to be thrown into the same fire. There is supposed
to be some import function in VB6, but it may only apply to forms. I don't
know how it treats controls and code. Let me know if you find an answer!

JF

Got burnt badly with AccessToVB.

it does do some things like converting code which doesn't need modication!
and converting forms but somehow messing up the sizes of the controls (how could they get *this* wrong?!)
It is no where near what is possible or what I expected .... a partial and useful translation needing some work on tricky constructs. AccessToVB is next to useless and there is "no return policy" ... "because the product contains source code".
What!!! a few little property get and let procedures and helper routines which I could have written better myself!
It doesn't even attempt to translate DoCmd methods which are the most obvious thing that needs to be done!!

These people obviously survive on passing trade and I'm sure there are lot of us to make it worth it.

Pass the word.
Phil King

Why?  A number of folks who work in both Access and VB have stated
that an equivalent VB app takes about 50% longer to develop.

See the list of such at my website.

Tony
----
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

There is a big difference between the two.  For one thing, VB doesn't use
Do.Cmd.  It's just as hard for someone familiar with VB to go to VBA for the
same reasons.

Suggest you take your forms in one at a time, get it working, then move on.
Once you are used to VB you will find it much more powerful than VBA.