Recent content by demax182

Oh, for sure no.

I'm but a novice, but I'll try to answer your questions to the best of my ability. I am using UNION ALL because one of the columns is Long Text. If I did UNION, it would truncate the field if it's longer than a certain number of characters. I probably don't have the relevant indexes on the...

Sorry, haven't responded to this. The laptop I'm running this on has SSD.

Ok, this is going to be long... So with the SQL from the report's record source, I made a select query. Then I put a bunch of breakpoints in the "QueryFieldSeparatedAsString" and ran the query. What I found out was that it was going through the function endlessly, which meant that it was...

That was a really good suggestion that I should have tried earlier. In any case, the report crashes before it reaches any of the breakpoints...

I did, but the report still caused Access to crash.

So I took the SQL from the query I showed you and used it to create a separate select query. I was able to open the query without crashing Access...

Thank you. I'll give it a try. I have a query that also uses "QueryFieldAsSeparatedString". Could I implement this in a query as well?

Here is the code: EDITED BY THE_DOC_MAN: ADDED CODE TAGS (ONLY), NO OTHER CHANGES. Public Function QueryFieldAsSeparatedString(ByVal fieldName As String, _ ByVal tableOrQueryName As String, _ Optional...

So does this mean the crashing is not due to report corruption? If so, I'm suspecting this is all happening because of bad report design... So the record source is a query of the following design: quni_combined_assessments is a Union Query. I would say I have less than 50 controls in each...

Understood, but Access restarts on its own shortly after the green bar of death and prompts me to choose a location to save a backup...

Ok, so I'm manually recreating the report. Decided to call it the day and close out everything. Prompt comes up asking me if I want to save the report before closing it out. I select "Yes" and Access crashes on me again... I checked the Event Logger. Looks like a bit more info is provided...

Still crashes when trying to open report in design view via vba.

Ok, so I had somebody from IT do a repair of the Access installation (this was done remotely as I do not have admin rights to install/uninstall/repair programs). The problem still persists. I've also tried importing the problem report to a clean database, but it causes Access to crash as well...

I have 4 Available References checked, but none show "Missing" or "Broken" as part of the line. I don't think I created the database on a 32 bit system. The database was created on this company laptop, which is running on a 64 bit system. If IT were to change a 32 bit system to a 64 bit...