Map5 & MS Access Forms

[dougculbert]

Hi,
Does anyone know how to connect an existing MS Access data base that has forms developed with VBA to Map 5. What we are trying to do is invoke this predeveloped application with the 'on-click' event of a block or line insertion. We wish to add the data associated with that line or block to the attached database with the form from the MS Access project. The form would have a number of drop-down boxes, radio buttons, check boxes, etc. that reference tables with the default data.
Is this possible?
Thanks in advance !

[Anonymous]

Doug, first, I don't believe Map recognizes forms, per se. Something you might want to look at is getting the user input via Dialog Control Language (DCL) and passing it back to the table via VisualLISP. DCL is suprisingly easy to use and has all of the features you're looking for in your form such as the drop-downs, radio buttons, etc. It sounds like what you're trying to do would be wonderful in terms of data entry and validation. Russell Gibson

[Anonymous]

It is possible to connect an object to an Access form. However, you must
use some sort or program interface to accomplish the task. I use CAO and
VBA.

Dana Chapman
RGibson wrote in message
news:f06f644.0@WebX.maYIadrTaRb...
Doug, first, I don't believe Map recognizes forms, per se. Something you
might want to look at is getting the user input via Dialog Control Language
(DCL) and passing it back to the table via VisualLISP. DCL is suprisingly
easy to use and has all of the features you're looking for in your form such
as the drop-downs, radio buttons, etc. It sounds like what you're trying to
do would be wonderful in terms of data entry and validation. Russell Gibson

[Anonymous]

Hi Dana,

Can you supply more details?
Which API do you use to access forms in mdb file?

Thanks,
Jadranko

Dana Chapman wrote in message
news:D09F1B705590B7B920A28317CFFDEE48@in.WebX.maYIadrTaRb...
> It is possible to connect an object to an Access form. However, you must
> use some sort or program interface to accomplish the task. I use CAO and
> VBA.
>
> Dana Chapman
> RGibson wrote in message
> news:f06f644.0@WebX.maYIadrTaRb...
> Doug, first, I don't believe Map recognizes forms, per se. Something you
> might want to look at is getting the user input via Dialog Control
Language
> (DCL) and passing it back to the table via VisualLISP. DCL is suprisingly
> easy to use and has all of the features you're looking for in your form
such
> as the drop-downs, radio buttons, etc. It sounds like what you're trying
to
> do would be wonderful in terms of data entry and validation. Russell
Gibson
>
>

[Anonymous]

Jadranko,
The easiest way is VBA. Open up a new VBA session while AutoCAD is
loaded, make sure you reference the Access methods, and your on you way.
For some examples of VBA code, search the connectivity newsgroup for 'Access
connections'. Most examples show how to open a table or query. Just
replace their OpenTable, etc. with the OpenForm method. Once you have the
from open, the next step is writing the code to select an individual object,
pass the key link stored on the object to the form, etc.
FWIW, we have a programmer who wrote tons of database connectivity routines
(including open access forms) completely in LISP. The first step is knowing
that it can be done.

Dana

Jadranko Stjepanovic wrote in message
news:B15ED542D0B57566CF93707CEF673867@in.WebX.maYIadrTaRb...
> Hi Dana,
>
> Can you supply more details?
> Which API do you use to access forms in mdb file?
>
> Thanks,
> Jadranko
>
> Dana Chapman wrote in message
> news:D09F1B705590B7B920A28317CFFDEE48@in.WebX.maYIadrTaRb...
> > It is possible to connect an object to an Access form. However, you
must
> > use some sort or program interface to accomplish the task. I use CAO
and
> > VBA.
> >
> > Dana Chapman
> > RGibson wrote in message
> > news:f06f644.0@WebX.maYIadrTaRb...
> > Doug, first, I don't believe Map recognizes forms, per se. Something you
> > might want to look at is getting the user input via Dialog Control
> Language
> > (DCL) and passing it back to the table via VisualLISP. DCL is
suprisingly
> > easy to use and has all of the features you're looking for in your form
> such
> > as the drop-downs, radio buttons, etc. It sounds like what you're trying
> to
> > do would be wonderful in terms of data entry and validation. Russell
> Gibson
> >
> >
>
>