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

Sabtu, 10 September 2011

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 Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Sun, 11 Sep 2011 00:57:34 +0000
Subject: [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, tblTrainingGroup.TrainingGroupName FROM tblEmployeeTraining INNER JOIN tblTrainingGroup ON tblEmployeeTraining.TrainingGroupID=tblTrainingGroup.TrainingGroupID;
>
> I have uploaded a snapshots in a Word document that includes relative table structures and forms to the Needs Assistance folder.
>
> Please review the notes in the document and see what you think.
>
> What I would like to do is add the record for mandatory trainings when I add a new employee reecord. It would contain the employeeID and the traininggroupID and the training date would be null.
>
> THis way I can un a report for employees missing mandatory trainings.
>
> Thank you,
>
> Arthur Lorenzini
> Sioux Falls, SD
>