RE: [MS_AccessPros] Re: Insert records from a command button

Art,
Did you try create an un-matched query to see if these are the records that should be inserted? You may need to filter by EmployeeID.

If you tell us if this works or not, we should be able to suggest how to change this to an append query.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Sun, 11 Sep 2011 10:07:12 -0700
Subject: Re: [MS_AccessPros] Re: Insert records from a command button

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]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/