A
ArielZusya
I've got a table (tblMain) which stores information about people. I have
another table (tblMainEvent) which stores events for each users. There is a
one to many relationship between these tables as tblMainEvent stores a number
of events for each record in tblMain. The way I use these two, for the most
part is as follows:
I import an excel spreadsheet into tblMain which contains information about
each user. I then have a form (frmUser) which I use to manipulate the data
for each user, one at a time, imported into tblMain. That same form,
frmUser, contains a subform (frmUserEvent), which I use to add events to the
current-record-person from tblMain. All of this works without a problem.
The thing is, I'd like to automatically insert a record as the first event
for each user when I import the excel sheet. In other words, I'd like to use
VBA to insert a new record into tblMainEvent for each record imported into
tblMain as I import it (or just after). Is there an easy way to do this?
Thanks for your help!
another table (tblMainEvent) which stores events for each users. There is a
one to many relationship between these tables as tblMainEvent stores a number
of events for each record in tblMain. The way I use these two, for the most
part is as follows:
I import an excel spreadsheet into tblMain which contains information about
each user. I then have a form (frmUser) which I use to manipulate the data
for each user, one at a time, imported into tblMain. That same form,
frmUser, contains a subform (frmUserEvent), which I use to add events to the
current-record-person from tblMain. All of this works without a problem.
The thing is, I'd like to automatically insert a record as the first event
for each user when I import the excel sheet. In other words, I'd like to use
VBA to insert a new record into tblMainEvent for each record imported into
tblMain as I import it (or just after). Is there an easy way to do this?
Thanks for your help!