I am pretty new to vba in excel so please excuse my ignorance.
I want to use excel as a front end user input device to store data in access. I need to track loans and borrows between different shops. In order to do this i need to have a form pop up when the loan category is selected and force the user to pick what shop they are loaning to.
The form needs to have a predetermined list of shops so no mistakes in typing are made. I want that list to come from a table in Access. I also need for the number to decrease in the loaning shop and increase in the borrowing shop's total.
I have to use excel because i will also have a code that tracks which users change data.
Information about the excel sheet if needed:
The template for users to input data is as follows.
There are categories down column A (about 20 or so)
Dates Jan-Dec across the top (three years worth)
the excel sheet will be populated and then record the users inputs on a separate hidden sheet and log changes. It will also output changes to Access.
Thanks for any help
I want to use excel as a front end user input device to store data in access. I need to track loans and borrows between different shops. In order to do this i need to have a form pop up when the loan category is selected and force the user to pick what shop they are loaning to.
The form needs to have a predetermined list of shops so no mistakes in typing are made. I want that list to come from a table in Access. I also need for the number to decrease in the loaning shop and increase in the borrowing shop's total.
I have to use excel because i will also have a code that tracks which users change data.
Information about the excel sheet if needed:
The template for users to input data is as follows.
There are categories down column A (about 20 or so)
Dates Jan-Dec across the top (three years worth)
the excel sheet will be populated and then record the users inputs on a separate hidden sheet and log changes. It will also output changes to Access.
Thanks for any help