Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 November 14th, 2006, 05:39 PM
Registered User
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Populating new table

I have a huge problem with MS Access. I am trying to develop something that uses databases, but isn't data entry. Currently I have a list box that has several columuns/rows populated with dates and locations. I also have a two combo boxes, both filled with peoples names. Both the combo and list boxes are tied to tables that are imported from excel. I need to be able to click on a row in the list box, and click on a person's name from each combo box and then it appear on another data sheet (all of them at the same time, not just show one record). Ideally I would like this to be done with the click of a button. I have tried to make the new datasheet a subform and can't get the information from the list box/combo boxes to the new form. Any ideas?

 
Old November 15th, 2006, 08:20 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What do you want to do with the data once you get it where you want it?

You would not use a subform for this, but could post the data to a text box, or several text boxes. Then if you wanted to process them further, you could then push them where ever you needed them to go.

If you want to use a datasheet for a subform, you will need to create a table to hold the data, then push the data to the table and requery the subform with the button click.

HTH

mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Populating an unbound form from a table Luis Access VBA 8 November 21st, 2008 08:37 AM
populating table from a subform based on a query bjcountry Access 1 April 11th, 2008 06:35 AM
Chapter 4 "Populating the Table" Chudz BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 4 August 24th, 2007 01:31 PM
populating cboBox with remote table data Loralee Access 8 October 31st, 2005 11:24 PM
Generate unique ID when populating a table sroman SQL Server 2000 2 August 5th, 2003 03:38 AM





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