Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 18th, 2014, 11:57 AM
Registered User
Join Date: Jun 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Is it possible to use a single form to add multiple records to a table

I have read through numerous threads of using loops and Dmax values to be able to achieve such goals

Unfortunately I am having difficulty in reproducing valuable results when I try to mould it to my situation.

Please forgive me my ignorance

I have a table "Processing Bins JK" which is in a many to one relationship with a table "Ripening Rooms JK" aswell as connected to a table "SCALE ID" via lookup

I would like to create a form to add units (processing bins) to table processing bins.

The snag comes in the fact that there are a few fields that would stay the same in the table and only the unique number assigned to each bin would change.

Thus the entering of 1000 bins a day becomes tedious.

Is it possible to create a form that would allow you to select a number of records to add with all the data except the unique number assigned(automatically)?

I will attach the database for clarity because I am sure my explanation lacks quite a bit.

From the data in the table "Processing Bins JK" it should be a little bit clearer what shape the data can takehttp://www.filedropper.com/database1_1

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i add multiple forms in the single setup type applications UmeshA Visual Studio 2005 3 March 12th, 2009 08:13 AM
Multiple views of single table jatatman ASP.NET 3.5 Basics 1 June 2nd, 2008 01:34 AM
Concatenate multiple records from table to single Ron Howerton SQL Language 6 August 23rd, 2004 08:49 AM
Add multiple records with one form submission quinn Classic ASP Basics 3 December 13th, 2003 09:27 AM
Update or add multiple table records rosenzl VB.NET 3 June 12th, 2003 01:59 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.