Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
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 December 2nd, 2004, 10:51 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default Can't find record, causes Access to crash

Hi,

   I have a form that I have been using for a long time. The back end is on uor network. Lately when I use a look up on the form and the item is not in the list, Access crashes and wants to create a back_up file.

   Any thoughts on what might be causing this and how to fix?

Thanks,


mmcdonal
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old December 2nd, 2004, 04:36 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

I have had this happen to me before, so I am guessing that it must be a bug or something with Access. Is the combobox meant to allow you to add new data? Either way, you might be able to do something with the NotInList event to trap the error.

Mike
EchoVue.com
 
Old December 3rd, 2004, 02:51 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Thanks, I will pursue this Event.

mmcdonal




Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex(?) Count Query Causing Access to Crash Chris Gilpin Access 1 August 6th, 2007 11:16 AM
Open Word Doc from Access - find, find next save donaldmaloney Access VBA 1 May 25th, 2005 11:09 AM
use SQL to find a record linmu VB.NET 2002/2003 Basics 4 May 6th, 2005 05:03 PM
Function to Find a Record me2357 Access VBA 5 March 10th, 2005 03:22 PM
Cr8 & Stored procedure ..Crash ..Crash swissaKM Crystal Reports 0 January 2nd, 2005 06:02 AM





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