Recent content by breezett93

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...

I am trying to implement the functions listed here: https://extramiledata.com/get-list-form-controls-sorted-tab-order/ I created a button on my form that calls the first function: Private Sub btnControlsInTabOrder_Click() Dim QuoteFrm01 As String TestControlsInTabOrder (QuoteFrm01) End Sub...

My database is split with one front end and one back end. For this report, the largest table has 120,000 records but is only pulling 47 for the specific ID being searched. The smallest table has less than 10. Below is the relationships for all the tables involved in this report. Yes, it...