Use Access Table as picklist in excel

cmeie002

New Member
Joined
Nov 4, 2011
Messages
2
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
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,912
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top