CookieCoder
Last Activity: Jun 11 '12, 01:22 PM
Joined: Feb 22 '12
Location:
-
Thank you very much, this works like a charm!! -
Excel VBA create new record in Access Table - 2007 Office
Hi, Good Morning Experts!
I'm trying to create a new record in Access from Excel VBA. I've got a button in the Excel file, that when pushed will put data from the excel sheet into a NEW record in Access. Here's what I've got so far, but it keeps failing on "Set rstTable = oAcc.Recordset. Open("C:\Docume nts and Settings\ecook\ My Documents\Share Point.mdb")"
...Code:Sub cmdPassDownItem_Click() Dim oAcc
No activity results to display
Leave a comment: