Re: VBA to VB

From: Tim Ferguson (FergusonTG_at_softhome.net)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 10:37:40 -0700

"Larry Linson" <bouncer@localhost.not> wrote in
news:Ok0WXrqcEHA.4032@TK2MSFTNGP11.phx.gbl:

>
> That's a very interesting observation. I've looked at a lot of
> developed Access database applications (single-user, multiuser, and
> client-server) and the only ones that I ever recall NOT using DoCmd
> are those that were strictly novice or casual end-user databases.
>
>

Fair cop -- what I was thinking about was the pseudo-database commands like
RunSQL, OpenQuery, ApplyFilter, PrintOut, and so on. IMO these are all
better replaced by interacting directly with the dbengine itself.

The DoCmd object also manages all the UI elements like OpenForm and
OpenReport, Close, and so on which are obviously neccessary to make
anything appear on the screen. You are quite right, it would not be much of
an application without them. Then again, these all have to be replaced as
part of migrating to VB too.

Thanks for the correction.

Tim F