Search results

Since I can't reliably replicate the problem, it does not make sense to pay to talk to Microsoft. I have reported errors to them in the past, and after hours on the phone, they more or less ignore the damage a bug have on the Access users around the world. Just to show you that Unload does see...

I can obviously also run BeforeUpdate, but there are certain events in the networked system that can only happen after the form has closed, hence the final processing when the form is closing. I don't understand why running the Unload then works, and have worked for years, thousands of times a...

This is just a small part of the Unload event, but sine it fails on the first step that references the form, that is all I figured was needed to show.

So why does it work 99% of the time, and have for years?

I occasionally get customers reporting the error "The expression you entered has a field, control, or property name that ... can't find" on line 2568. This is the Unload event for the form "Workorders", where I confirm if the record exist, before it continues down the event code or exits the...

I gave it try, and broke my code. It does not handle errors well, which made it stop halfway through updating a script, leaving it inoperable. FMS's tool deals better with this situation.

It sure is. I also have it add error handling, adding this to the end of every sub or function (with a few exceptions): ExitHere: 1120 Exit Sub ' Error handling block added by VBA Code Commenter and Error Handler Add-In. HandleErr: 1121 ReportError "Error " & Err.Number & "@" &...

Total Visual CodeTools is actually very good. This is the first time I've had any issue with it, and I have used it for at least a decade. I mainly use it to manage line numbers so that I can get helpful error messages, telling me exactly what line in my code that failed.

I wish I could, but there are too many things in there I would have to remove fist. This front end is about 55Mb with a few hundred thousand lines of VBA code.

Well, I seem to have found a big clew. I just rebooted and the problem went away. Then tried a few different things, not able to reproduce the problem. But then I used the Total Visual CodeTools, version 14.00.0037, "Code Cleanup", and the problem came back. To reconfirm this I did a repair...

My database seem to be completely closed, with the .laccdb file gone as well. Access remains open. If I click to close access, it closes, but reopens immediately. Something is telling access that has to reopen, but what? Only a repair of reboot seem to temporarily cure the problem. I...

For some time now Access will refuse to close when I close my database. The only way to close MSACCESS.EXE is from the task manager. If I run a repair of Access it will allow me to close it for a while, but the problem returns shortly after. After an build update the problem also goes away...

Perhaps the best solution is just to keep Access 2010 on my system so that I can build new installations, but thanks anyway. I will look at it.

No, because not all my users use Outlook, so I must allow them to chose default email program. I also do have a built in SMTP solution based on CDO, but since office365.com require TLS that CDO does not support, that is not an option for them either. The funny thing is that both these two...

Does an Access 2016 Package Solution Wizard exit or will it ever exist?

I have recently noticed that sending an email, using DoCmd.SendObject, from Access 2010 runtime to Outlook 2016, causes Access 2010 runtime (and full version as well) to hang after the message is sent. It looks like control is never handed back after the message window closes. I have seen this...

Hi, I'm Morten, a Norwegian living in Houston. I have been using Access since its inception, but full time since 2001. I have a product called ServiceMax that helps small to medium sized service providers in the UK run their business, You can find it at 1-2-access web site From time to time...