I would like to insert the records in the specific table when a new employee is added. What would the insert command look like?
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Saturday, September 10, 2011 11:24 PM
Subject: RE: [MS_AccessPros] Re: Insert records from a command button
Art,This sounds a bit like an un-matched query. Have you tried the wizard?Duane HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Sun, 11 Sep 2011 00:57:34 +0000Subject: [MS_AccessPros] Re: Insert records from a command button Just wondering if anyone has any ideas about this?--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:>> I need to automatically insert a set of records into a table from a command button. I have a form called Employee Details which contains a tab control. One of the pages on the tab control is called Training dates which contain a subform called Employee Training Subform. This subform contains datasheet of training dates and training name for a employee. This is the query that supports the subform:> > SELECT tblEmployeeTraining.TrainingDate, tblEmployeeTraining.CompletedFlag, tblEmployeeTraining.TrainingGroupID, tblEmployeeTraining.EmployeeID,
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar