PC Review


Reply
Thread Tools Rate Thread

Apending and Updating from a form

 
 
=?Utf-8?B?UGl4aWU3OA==?=
Guest
Posts: n/a
 
      22nd May 2007
I don't think my last question was clear. I have an Employee table, a Course
table and a Registration table to connect the employees with the classes. I
was looking for a way to add more than one employee at a time to a class. I
have created a yes/no select box in my employee table and made a subform
(from a query) with EmpID, Name, and the select box. The main form is the
rest of the information needed for registration such as class name, date
taken, complete or incomplete and so on. I created an update query and an
append query and here are my problems:

When I run the update query it unchecks all the boxes however I can't do
anything else because it tells me a related record is needed in the employees
table. Can't see why.

When I run the append query it adds a registration (autonumber) and the
employees I selected, however, it doesn't add any of the other information on
the rest of the form such as the class info.

Am I going about this the wrong way? Or am I missing a link?

Thanks for any advice.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
apending data to table from unbound form when form field blank =?Utf-8?B?QXJub2xkIEtsYXBoZWNr?= Microsoft Access VBA Modules 2 16th Aug 2006 09:31 PM
How to Bullk update a table without apending the Trans. Log Patrick B. \(pbutlerm\) Microsoft ADO .NET 0 4th May 2005 03:49 AM
Updating/Apending between two Access DBs =?Utf-8?B?SnVzdGluIEtpbmc=?= Microsoft Access External Data 3 19th Oct 2004 11:29 PM
Apending from a linked table Serene Microsoft Access External Data 2 25th Feb 2004 06:01 AM
Updating Control on Main Form form Child Form Microsoft Dot NET 1 17th Nov 2003 07:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:09 PM.