LevelThought
MIS
A challenge!
Using Access 2003 database with links to an Oracle 8.1.7 database.
Have a form with a set of 30 textboxes - 6 rows with 5 textboxes per row. The label for the 5 textboxes are - "AccountNo", "Charges", "Payments", "DateCreated" and "InMainTable?"
Instead of the end-user entering all of the fields along each row, he/she should just enter 1 to 6 account numbers in the "AccountNo" textbox and all of the remaining fields should populate when the first command button is clicked.
This is done to mimimize data entry errors and save time.
For example, "Charges" and "Payments" should be populated on the form with the value in Oracle for the specific AccountNo that was entered and the "DateCreated" should reflect the current day and "Yes" or "No" should be within the last field that indicate if the AccountNo is already within my local Access table.
When, the second command button is clicked, all of the "new" records on the form should be inserted into the
local Access table.
I have created the form but am having a hard time trying to conceptualize the coding needed for the command buttons.
Thanks in advance for any insight.
Using Access 2003 database with links to an Oracle 8.1.7 database.
Have a form with a set of 30 textboxes - 6 rows with 5 textboxes per row. The label for the 5 textboxes are - "AccountNo", "Charges", "Payments", "DateCreated" and "InMainTable?"
Instead of the end-user entering all of the fields along each row, he/she should just enter 1 to 6 account numbers in the "AccountNo" textbox and all of the remaining fields should populate when the first command button is clicked.
This is done to mimimize data entry errors and save time.
For example, "Charges" and "Payments" should be populated on the form with the value in Oracle for the specific AccountNo that was entered and the "DateCreated" should reflect the current day and "Yes" or "No" should be within the last field that indicate if the AccountNo is already within my local Access table.
When, the second command button is clicked, all of the "new" records on the form should be inserted into the
local Access table.
I have created the form but am having a hard time trying to conceptualize the coding needed for the command buttons.
Thanks in advance for any insight.
