`hi all,
i was wondering about having a userform from excel with its data feeding into an access table. Is that possible? I expect the answer is yes but......
at present my userform enters simply into a spreadsheet behind it
i.e textbox1 = a1 etc.
I have unfortunately cant attach my current workbook but if you email at [email protected] i will send it to you and if anyone can tell me how this can be done i would be most appreciative
I have specified the current code below aswell if that helps.
I have really only used access back in my uni days so i need some help here!
If anyone can help me, i have a spare google acccount or two! (gmail).
thanks in advance
steve
Worksheets("Sheet4").Range("b13").Value = combobox1_input
Worksheets("Sheet4").Range("b14").Value = combobox2_input
Worksheets("Sheet4").Range("b15").Value = LocalAccount1.Text
Worksheets("Sheet4").Range("b16").Value = Description1.Text
Unload Me
Sheets("Sheet4").Select