Newbie Questions

Re: Insert Multiple Records with Field Value

Arthur77 — Mon, 28 Mar 2011 13:48:33 GMT

In the past when creating forms in MS Access, I was able to just write a macro with an append query that would append the values of the TaskID's into the Metrics table every time it was executed. The macro would also execute an update pulling in a value from the form in use to get the current value of the DemographicID and update those values in the DemographicID field if the field was null.

Re: Insert Multiple Records with Field Value

Arthur77 — Tue, 22 Mar 2011 20:00:25 GMT

Hilary,

yes, I am creating a form from an Access database with a schema:

shape
{select [DemographicsID],[Rating],[Paygrade],[FirstName],[LastName],[EmailAddress],[LastFourSSN],[DateOfBirth],[Gender],[TimeInGrade],[TimeInRating],[Location],[DutyType],[WorkSetting],[NEC],[Department] from [Demographics] as [Demographics]} as [Demographics]
append
({select [MetricID],[DemographicsID],[TaskID],[Validation],[Difficulty],[Importance],[Frequency] from [Metrics]}
relate [DemographicsID] TO [DemographicsID]) as [Metrics]

The form will collect demographic information from survey participants and populate a row within the Demographics table. There will be a button at the bottom that will "Submit" the data and "Open" another form that allows participants to review 200 tasks from table TaskList with primary key TaskID...but that is another part of the project. What I need for the time being is to insert 200 blank records with the DemographicID field in the Metrics table equal to the DemographicID from the Demographics table or textbox bound to this field. In other words, perform this operation when the user selects the button at the bottom or something along those lines.

Many thanks,

Arthur

Re: Insert Multiple Records with Field Value

Hilary Stoupa — Tue, 22 Mar 2011 17:16:31 GMT

Hi:

I think we need more info on what you are trying to do to be able to help you. Are you creating a form off a database? Or do you mean you want the form to load with these items?

Insert Multiple Records with Field Value

Arthur77 — Fri, 18 Mar 2011 21:01:11 GMT

Is it possible to add 200 new records to a child table and populate a field in that table with a value from the parent table?