mainrotor
asked on
I need assistance saving on a click event in ACCESS 2013
Hi Experts,
I need to save a record in an ACCESS 2013 to my tblJOb table on a button click event. When I save the record using a VBA sql query, I want it to return The JobID (auto generated key) that was given to the newly created record. How can I do this? These are my table fields:
tblJob has the following fields:
JobID (Primary key - auto generated)
JobName
COntactName
ContactPhone
ContactEmail
thank you very much in advance,
mrotor
I need to save a record in an ACCESS 2013 to my tblJOb table on a button click event. When I save the record using a VBA sql query, I want it to return The JobID (auto generated key) that was given to the newly created record. How can I do this? These are my table fields:
tblJob has the following fields:
JobID (Primary key - auto generated)
JobName
COntactName
ContactPhone
ContactEmail
thank you very much in advance,
mrotor
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Scott McDaniel (EE MVE )
Are you using bound forms? If you are, then there's no need to use DAO to save the data. Let Access do this instead.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Scott,
I am using an unbound table.
I will try Thommy's links and Helen's code a try.
mrotor
I am using an unbound table.
I will try Thommy's links and Helen's code a try.
mrotor
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
