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 January 16th, 2006, 01:15 PM
Registered User
 
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Insert multiple records from form

Hello,

I have a form where I would like the user to be able to click on a command button to insert multiple records based on criteria they have selected in a few list boxes and text boxes. I have the form set up, but am not sure how to code the VBA for the insert. It would work like this: insert one record onto a table for each item they have selected in one of the list boxes (a multi-select list box). If they select 5 items, VBA will insert 5 rows onto the table. Also will use the other data they have entered as well from the text boxes.

Can anyone help me write this code, or at least point me in the direction on how to find out how to insert multiple rows via VBA?

Thanks in advance,
lori
 
Old January 16th, 2006, 05:07 PM
Registered User
 
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have figured it out and got the code working...thanks anyway...
 
Old April 9th, 2007, 03:08 PM
Authorized User
 
Join Date: Apr 2007
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi.

Can i see what you did?

I cat figure it out!!


Quote:
quote:Originally posted by lorirobn
 I have figured it out and got the code working...thanks anyway...





Similar Threads
Thread Thread Starter Forum Replies Last Post
insert multiple records into a table from values Deepak Chauhan Oracle 3 May 12th, 2006 10:35 PM
Insert multiple records mateenmohd Access 13 November 2nd, 2004 09:15 AM
insert multiple records mateenmohd Classic ASP Basics 19 October 18th, 2004 01:22 AM
Insert multiple records in a Inner Join Table rylemer Access VBA 0 July 19th, 2004 03:54 PM
Best way to insert multiple records koo9 ADO.NET 2 June 28th, 2003 08:37 PM





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