NotInList Pasting Multiple Records into one Combobox (1 Viewer)

hubelea

Registered User.
Local time
Today, 12:43
Joined
Nov 9, 2011
Messages
33
I am relatively new to Access, using 2007. I have a form with a subform, subform in datasheet view. I was successful in setting up NotInList so that when I add a record to the UPC combobox it will update the appropriate table if a new record.

However, I've set up the form in datasheet view specifically so that I could copy and paste (and/or append) large numbers of records from excel. The NotInList works when I manually add one record at a time, but not when I paste multiple.

I'm thinking there is an 'event' in there I need to set up, but after spending quite a bit of time I'm lost as to which one, and how to do that. Any help would be much appreciated? (and please understand that writing code, while not impossible, is not simple for me...)
 

vbaInet

AWF VIP
Local time
Today, 18:43
Joined
Jan 22, 2010
Messages
26,374
It's a clipboard to Access thing so if you want to do that then you need to find a way of interfacing with the clipboard item. An API perhaps but since you're relatively new to Access this is very advanced.
 

Users who are viewing this thread

Top Bottom