Home > Unexpected Error > Unexpected Error 40230 Vba

Unexpected Error 40230 Vba

Just says Unexpected error (40230) when I try to look at the newly renamed, hacked, saved and reopened code file. If that works, you can do the next step.Before you close the new db, make sure you compile your code. But once I did that it worked. Close it, then open it and compact and repair. http://fullflash.net/unexpected-error/unexpected-error-40230.html

By joining you are opting in to receive e-mail. ReplyDeleteAdd commentLoad more... Time to copy everything into a new, blank DB. Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access VBA Discuss using VBA for Access programming.

Happy Christmas to both, while I am at it. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.

Anyone have any suggestions?? Thumbs UP bro. Are you aComputer / IT professional?Join Tek-Tips Forums! Tuesday, April 24, 2012 9:58 PM Reply | Quote 0 Sign in to vote Hi Daniel, Yes I decompiled as part of the process before I send out the new .accde.

Scooter September 17, 2016 at 8:17 pm I was able to unlock the VBA password (and entered a new one), and I now have access to all of the original VBA First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Step 3: Open Your Workbook in the Hex Editor Fire up the Hex Editor you downloaded and then (within the editor) select and open your workbook. http://www.mrexcel.com/forum/excel-questions/294296-visual-basic-unexpected-error-40230-a.html I could suggest that you use this trick only for good and righteous purposes, but you won't listen anyway.

Step 1: Download a Hex Editor You'll need a Hex Editor. Dave Lucre January 30, 2016 at 3:41 am This also works with VBA protected Macros in Microsoft Access. Suggested Solutions Title # Comments Views Activity Advanced finding in Excel 9 28 10d Excel 2010 Sparklines - horizontal bar 2 32 11d Search Box 13 32 10d Tricky lookup and Why this one?

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Anyone know how you could remove the password on a Visio VBA module? Thanks! Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

I'm not really into Hex Editors, so I couldn't tell you if it's good or bad. weblink I tried decompiling, which is how I found out the project is corrupt. Not the answer you're looking for? The steps I take are; Make a copy Change the Name Change the linked Tables Decompile Compile Compact & Repair Disable shift key Compile Compact & Repair Make .accde Close Compact

When I do that I import one object type at a time and compact. waqar April 11, 2016 at 2:32 pm I trying to do this with MS Access, every thing went fine but I was not able to view any VBA code, on opening All rights reserved. navigate here It will pop-up error as "Unexpected error (40230)" The way to fix it is right click at any macro file in VBA window select "VBAProject Properties..." go to "protection" tab check

However, though I can see all of the Microsoft Excel Objects (the sheet-specific modules), when I open any of them, they're completely blank (no code!). Chris Ward Edited by KCDW Tuesday, April 24, 2012 4:10 PM add ps. Brendan Murphy May 13, 2016 at 6:23 pm These steps don't seem to work with Visio.

Cheers, all the same.

Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. It allows me to import tables, queries from the same DB the form is in, but wont let me select the form, it is disabled. It's actually a documented answer for a different error, however i've found that it works well with different unexlicable corruptions. Kevin Hennessy September 22, 2016 at 2:54 pm Could someone that had this work with Access explain more?

Did you find any solution to this? #3 (permalink) February 27th, 2006, 08:09 PM boogi Registered User Join Date: Feb 2006 Location: , , . AB, right again. Because it's the one my mysterious friend showed me. his comment is here Close this window and log in.

All contents Copyright 1998-2016 by MrExcel Consulting. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Open the VBE (view code) from the menu select Debug>> Compile...What happens if anything. Already a member?

Honestly, long time I do not use hexa and ASCII decode and binary 0 1 - machine language. Unlock Macro/VBA Source Code Even the VBA window can be displayed with ALT+F11, you can't really go to see the existing code in each macro. have to be imported into a new mdb and then everything works ok. « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Download the XVI32 Hex Editor and have it ready to go. .

Thanks Usman Ton3_CAD June 3, 2016 at 11:25 pm It's not finding DPB but there's definitely a password on the VBA. Brendan Murphy May 13, 2016 at 6:59 pm So after playing around a little bit I discovered the tag in Visio is "APB".