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 July 20th, 2007, 03:59 PM
Registered User
 
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Issue Opening Form in Access 2007

:( I have a db which at startup loads a screen allowing the user to select either of two buttons. One button brings up a data entry form, the other brings up a search form. We just switched today to Office 2007 (the db was created in Access 2002) and now the button to open the data entry form will not work?!? I get an error message stating that it's Runtime error 3011, that the object "1" can't be found and to check to be sure that the name and path are spelled correctly. When you click debug to view where the VB is puking, the offensive line is my DoCmd.OpenForm line to open the data entry form - a line which functioned perfectly fine until the switch to 2007. The actual line reads - DoCmd.OpenForm "Warranty_Info_Entry_Form", acViewNormal, acEdit

Here's the weird thing - the other button to open the search form works perfectly fine and all other forms that are launched after that (an info display form, and an edit info form) will open fine. Also, if I switch the form name in the bad line to the name of the search form, it will open fine, but no other form will work. It also just so happens that the search form is the first one in the list alphabetically - not that that should make a difference.

Has anyone else experienced anything like this with Access 2007??? I'm at my wits end!

Thanks!!!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Error opening Excel 2007 files in Express Edition Exsharaen Visual Basic 2008 Essentials 2 April 25th, 2008 01:47 AM
Access 2007 JohnBoy VB.NET 2002/2003 Basics 1 March 16th, 2008 09:33 PM
Access 2007 Ribbons? bgnetman Access VBA 2 October 30th, 2007 11:03 AM
Access 2007 - wtf? mmcdonal Access 7 December 19th, 2006 08:45 AM
A Access Form issue goels Access VBA 6 October 7th, 2004 06:58 AM





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