I'm using MS Access 2007.
I've two Access databases: dbTables, dbApplication.
dbTables consist of data tables (dbTables is Password Protected e.g. abc123)
with tables with primary key ID in each table:
Customers, Products, Orders, OrderDetails
dbApplication consist of Forms & Reports.
with forms:
Customers, Products,
A single main form Order Book with a continuous sub form Order Details,
Through these forms I've to enter data for New Entry, and View & Edit existing data already entered.
with reports:
Customers Index, Products Price List, Orders Index, Order Details
I need help for following issues in this regard:
1. How can I save data into dbTables, entered in dbApplication on main form and sub from? I need of help to connect the two databases in run time through VBA.
2. How can I view data saved in dbTables on Forms in dbApplication, how can I bound objects on Forms in run time through VBA?
3. How can I get data saved in dbTables on Reports in dbApplication, how can I bound objects on Reports in run time through VBA?
I've two Access databases: dbTables, dbApplication.
dbTables consist of data tables (dbTables is Password Protected e.g. abc123)
with tables with primary key ID in each table:
Customers, Products, Orders, OrderDetails
dbApplication consist of Forms & Reports.
with forms:
Customers, Products,
A single main form Order Book with a continuous sub form Order Details,
Through these forms I've to enter data for New Entry, and View & Edit existing data already entered.
with reports:
Customers Index, Products Price List, Orders Index, Order Details
I need help for following issues in this regard:
1. How can I save data into dbTables, entered in dbApplication on main form and sub from? I need of help to connect the two databases in run time through VBA.
2. How can I view data saved in dbTables on Forms in dbApplication, how can I bound objects on Forms in run time through VBA?
3. How can I get data saved in dbTables on Reports in dbApplication, how can I bound objects on Reports in run time through VBA?
