Search results for query: *

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

I apologize; I don't know what the "page of pages" means. The data is coming from a main query that pulls from two tables. Then there are several subreports that all have queries pulling from several other tables. I tried exporting just the data that involves this report, but I'm getting...

I'm hoping to find a solution to speeding up this frequently used report. Over the years, it has always been on the slower side, but as more and more gets added to it; the load times are now not acceptable. Is there an easy way for me to upload the report and example data where it takes ~10...

Sorry for the delay in responding. I appreciate you reaching out. >I am curious if you are opening the query before you export it? Does it display .68 in the layout grid before export if so? Yes, I did open up the query before exporting because I was running out of places to check what was...

The program that needs to import as csv is not Access nor Excel, but a different program. Sorry for the confusion. The normal process was to export from Access and import in the other program, bypassing excel entirely. The other program did not like that .6875 was being rounded to .68 when...

Yes, I was able to take everyones' suggestions and combine them into one. Firstly, I am now using TransferSpreadsheet to export as an .xls because xls did not touch my rounding. After the export, I then call this Function ConvertToCSV(src_file As String, dest_file As String) Dim csv_format...