damixa
asked on
insert statement in vba
Hi,
I was wondering if I can get some help with an insert statement I am running in vba.
I need to insert some records based on the current form
my code is something like this:
can I do a insert with a select statement with currentdb.execute? its erroriing out
thanks in advance
Vinnie
I was wondering if I can get some help with an insert statement I am running in vba.
I need to insert some records based on the current form
my code is something like this:
CurrentDb.Execute "insert into SER_FAXES_FILE ([ID],[STAFF-Resource NAME OT], [ADDRESS UNIQUE ID]) values (SELECT [ID],[STAFF-Resource NAME OT], [ADDRESS UNIQUE ID] from SER_FAXES_FILE_daily where SER_FAXES_FILE.ID = me.id))"
can I do a insert with a select statement with currentdb.execute? its erroriing out
thanks in advance
Vinnie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
First of all - you can embed into SP any logic you want, second, you can exec that procedure from more application functions than one.