I'm looking to rewrite a substancial existing MS Access/VBA app in VB
6, as a multiple document interface. I'm very solid in VBA in Access,
and refreshing myself in VB after a long time having only done simple
I'm looking for any advice given the information above. Best
practices, etc... before I go beyond exploratory, testing code.
After playing with ADOC I found I had terrible problems getting a
DBCombo to bind, and had success using the standard data control. So
I was thinking I'll have better luck with that. I'm using an access
I'll be using a lot of forms having tabular data, with combo boxes in
the rows, linked to other data. My Access version has lots of forms
w/subforms with tabular data.
Since I'll be using a single mdb file, is there a methodology where I
can globally have the data control active at all time, and accessible
from any form? This of couse would simplify things, especially since
I was thinking of giving the user the ability to load, or close and
load another database.