R
Roshan Abbasi via AccessMonster.com
While working with a table-bound form, how to access additional table(s) for
data comparison or even updating them.
data comparison or even updating them.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Accessing more than one Table from a MS Access Form
R
Rick B
Base your form on a query and include all the tables you need.
If you open the form in design-view and go to the properties tab, you can
build the query right there and not have to save it separately in your
database.
If you open the form in design-view and go to the properties tab, you can
build the query right there and not have to save it separately in your
database.
R
Roshan Abbasi via AccessMonster.com
It is a brillian idea of using multi-table Qyery.
Is it also possible to open an ADODB.Recordset of a table and have better
control on manipulating the data? I tried to do it, but the ADODB.Connection
comes into my way as it needs open the "Data Source", which is already in use.
Any help on a way for creating Recordset, with anticipated thanks.
Is it also possible to open an ADODB.Recordset of a table and have better
control on manipulating the data? I tried to do it, but the ADODB.Connection
comes into my way as it needs open the "Data Source", which is already in use.
Any help on a way for creating Recordset, with anticipated thanks.