Wrox Programmer Forums
|
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 November 14th, 2005, 01:12 PM
ana ana is offline
Registered User
 
Join Date: Nov 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple records using VBA

When setting the "Enter key behavior" for a textbox in MS Access to "New record in field" the textbox accepts multiple lines, but does not save each line in a separate record (assuming the textbox is already linked to a table).

I need a code that creates a new record each time I press the "Enter" key in the textbox.

Any thoughts?



 
Old November 14th, 2005, 02:04 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

If you don't mind my asking...

What kind of data are you working with, and why would you like it setup this way? I would think that a combo box or other control may give you more flexibility, depending on what your desired outcome is.



Mike
EchoVue.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Records with VBA rohit_ghosh Access VBA 7 June 22nd, 2007 05:05 AM
Add records with VBA rohit_ghosh Access VBA 2 June 22nd, 2007 04:13 AM
Update Multiple Records cancer10 Classic ASP Databases 0 October 25th, 2006 01:01 AM
Multiple records!!!! vmclear04 Classic ASP Databases 1 August 24th, 2004 04:53 AM
Multiple records on same page mossimo Classic ASP Databases 10 December 4th, 2003 05:51 PM





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