Then I tried indexing by sheet# as he suggested... Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! All rights reserved. http://sortoutlookemail.com/vba-error/vba-error-20-resume-without-error.html
jmcwkView Member Profile Jul 12 2007, 05:07 PM Post#7UtterAccess VIPPosts: 12,537Joined: 21-November 02From: Tacoma, WA.Never a Waste of time ! P: 1 Art Altman I have found a workaround to the Excel VBA “ run time error 40036 application-defined or object error”. Guess I'll ask again - Can you post the db (or at least stripped down to the parts in question)? Find More Posts by boblarson
You can then close the original file without saving and the sheet will still be in it. If you can, then look for a special character in the name (do the Code function) 2) If this doesn't work, then use the sheets(index) method of selecting the sheet. This code is the latest to come up and causing problems with error #40036. It will fail.
I renamed it "test" and it worked, so I deleted the problem sheet, renamed the new sheet to "Budget", and dragged it the location I had wanted it on the sheet Access is really going downhill on me because of these stupid errors that occur after they have been there for weeks. Neither does assigning assigning a variable to the room name. http://www.pcreview.co.uk/threads/error-40036-when-activating-a-sheet.966640/ Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] Run time error 40036, similar
Best of luck, 111StepsAhead Register To Reply 06-14-2012,09:41 AM #4 buran View Profile View Forum Posts Visit Homepage Valued Forum Contributor Join Date 06-25-2009 Location Sofia, Bulgaria, EU MS-Off Ver Excel Now, knowing that there is something wrong with the worksheet, not your code, I tried to compile the project and get the error mentioned in my reply. I still get an error message saying: "error '40036': Method 'Item' of object 'Forms' failed"....It has a problem with the way that I am refering the form for some reason that So I'm hoping that I'm just missing something and you wizards can pick it up.
that is right after Option Explicit statement Register To Reply 06-14-2012,10:09 AM #6 jdfjab View Profile View Forum Posts Registered User Join Date 01-12-2012 Location Rockland, WI MS-Off Ver Excel 2007 Similar Threads Selecting/Activating Control Tools Combobox on Sheet steve, Oct 10, 2003, in forum: Microsoft Excel Programming Replies: 5 Views: 293 steve Oct 10, 2003 Problem in activating a sheet Neeleshwar The only thing I could offer is to confirmed in the Exce Project Objects that there is a sheet name that matches your shee exactly. Test it on another screen.
We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. navigate here So, I tried to renumber and re-order the sheets, but that doesn't work It still gives the same error when trying to select that same sheet n matter what the number. Reason: Forgot internal macro Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 27th, 2010,12:01 AM #7 froodley New Member Join Date Feb 2010 Posts 2 Re: It would be nice to be able to actually play with it to see what might work. __________________ Free tools, code and samples here: To view links or images in signatures
End With I tried copy and paste with my other similar app. I can't figure it out! Complimenting the author of a textbook How does ransomware get the permissions to encrypt your disk? Check This Out I was lucky enough to stumble across my mistake last time.
The time now is 04:15 AM. if you move this to normal module or just comment it, it will work just fine. Thanks for any help.
No problem selecting the tab to move and the sheet which has 21 combo boxes functions ok and runs various macros attached to combo boxes. I also made a new DB and transfer everything. With the sheet in a new workbook, see if you can select it there. Server admin sent me a private key to use.
The macros are very simple Sheets("name").Select ActiveWindow.ScrollRow = 1 End Sub Debug points to first line 'Sheets("name").Select. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. It is also worth trying if you have a program you have been working on for a while and has a lot of redone or deleted sections, and is BIG. 1) http://sortoutlookemail.com/vba-error/vba-error-handling.html I checked out the project objects as jpendegraft suggested.
The not defined, as you know, is saying that there is not sheet called that.....from my understanding -- Message posted from http://www.ExcelForum.com jpendegraft, Feb 4, 2004 #2 Advertisements Guest Guest Guest, Feb 11, 2004 #6 pilotter Joined: Jun 26, 2009 Likes Received: 0 I had this problem when converting a program from excel 2003 to excel 2007. Is there some kind of bug in Excel (I'm using the XP edition) that thi error occurs in certain situations? CraigWarmy View Public Profile Find More Posts by CraigWarmy 02-16-2009, 12:39 PM #2 WayneRyan AWF VIP Join Date: Nov 2002 Location: Camarillo, CA Posts: 7,064 Thanks: