Search results for query: *

Thank you! I uninstalled the one that came with the machine. Now it's running as fast as the 32 bit was.

I checked the Access Forever page for bugs causing slow-ness. I didn't really find anything. I copied the database from the network folder and pasted to my desktop. Tried running it from there. No noticeable speed difference. I also am still getting the same error when trying to compact and...

I decompiled with no errors. I recompiled with no errors After clicking compact and repair, it hangs for 30 seconds, then I get an error saying "Could not use 'database.accdb', file already in use" This is not possible because this db is a copy of a different db that no one else in is using...

Yes, there is a version checker that runs immediately and triggers an auto update if the version numbers don't match. Yes, I have a default printer on my machine. Why would those things cause a 64 bit version of the db to run poorly compared to the 32 bit version?

Yes, the application is split. I made a copy of the front end. I have gone through and either corrected all errors, or commented out code with errors that were on forms no longer used. The database is still taking approximately the same amount of time to load.

No. There are several modules that are very, very old, built long before I started. I have avoided correcting errors to the old sections because the program has usually run well. In the past, when I have tried correcting old code, it tends to break the rest of the program. For example, the...

Currently I have users that are using Microsoft Office versions 2013 - 2021. All are 32 bit because our ancient access database requires 32 bit. Now, I am migrating all users to Microsoft Business 365; so I need to convert the database to 64 bit. I updated all the Declare statements to include...

I'll give that a shot. Everything appears to be running normally again; so I still have no idea what the original cause was. Thank you.

Other databases appear to be working fine. I'm having reports from users saying the errors they were encountering have gone away. But I haven't changed anything.

These are the two updates that took place. When I went to the uninstall updates section, the two that occurred were not in the list to be uninstalled.

I tried compact and repair on my copy. Some issues went away, but I'm still having lock error messages all over. There are multiple users in the database every day. I have my own dev/test version that I use. The problem is happening on both my version and the live version. I even went to...

I have not made an update to my database since 7/24. However, I do see that there was a Windows Update between Friday and today. Forms that have been working fine for years are suddenly breaking at random places. Often it happens when a field has a drop down with a selection that resides in...

Thank you! The results were in the immediate window. Now I'll try to replicate in the original database.

Okay, I made a new module in a new database and copied both functions to it. Then I made a new button on one of the forms calling the Test function. After clicking the button, I got no errors, but I got no message either showing the results of the list of controls.

I do not have this code in a module. For testing, I have the code in the VBA of the form (QuoteFrm01). When I have tried compiling in the past, the database usually locks up. Likely this is due to its age and size.

I did download the zip file. It has a .bas file which I've never imported into Access before. I know the .bas file is in the downloads folder, but when I try to import it, the folder is empty.

I tried your suggestion. Same error in the same place. For Each ctl In ControlsInTabOrder(Forms(FormName).Detail, True, True) It seems like something is wrong with the ControlsInTabOrder function as info is passed to it. Public Function ControlsInTabOrder(FormSection As...

When I click the button, the test function is called: Private Sub btnControlsInTabOrder_Click() TestControlsInTabOrder (Me.Name) End Sub I pretty much copy/pasted both functions making no changes. Then I added one button to trigger everything.

Yes, the form I am testing does have a Detail section with ~20 controls.

I tried both of your solutions, and they take me to the same spot. I now have a run-time error 2465 "Application-defined or object-defined error" on this line in the TestControlsInTabOrder Function. For Each ctl In ControlsInTabOrder(Forms(FormName).Detail, True, True) Here's the whole...