Create Access forms/fields using a table giving vital information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to create Access forms using a control table giving vital information.
Example: Field type/Field positions/Field description/Field valid ranges/plus
more.
Currently have over 400 programs, running in QBasic, which use external
tables to manage all data display/entry/edit. Thanks for any help that you
can provide.
Using Access 2002 and 2003. jnh11
 
Hi Arvin,

Thanks for your quick reply.
The Wizard will not serve my needs. I may have not provided enough details.
Am trying to replace some business applications using app 400 QBasic
programs running under DOS (and still running strong today).
One of those programs reads a control table/file/matrix. Entries in this
control table specify the field screen position (vertical/horizontal), field
description, data length, data type and several more controls/codes that
control data edit/flow and file updates.
This allow me to add/modify/delete fields (and even new screens) quickly
without any other manual intervention.
Maybe you can point me in some additional directions (is VB the potential
answer ?)
Have a great Holiday Season. jnh11
 
It is not "crystal clear" what you are expecting to do. With QBasic, you
must draw your own UI and screens, which Access provides. I've worked with
various forms of "table-driven application" on mainframes, minicomputers,
and under DOS. What I was often trying to do was overcome the limitations of
the far-from-rich UI... you just don't have to do that with Windows
applications.

It was often "wizards that weren't run just once" -- an implementation of
interpreting code (sometimes, as in QBasic, also done with interpreted
code).

Perhaps if you could clarify what you have and what you are trying to
accomplish, we could be of more help.

Larry Linson
Microsoft Access MVP
 
Back
Top