Search results

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

Thanks for responding. There is VBA associated, but nothing terribly complex. They're if/then statements that determine the value of unbound check boxes. There is an unbound control that does call a function in a module. I don't know, but maybe that could be the problem. I have to admit...

So, I'm in the process of creating a database and have put a lot of focus on developing the reports. There is one particular report that causes MS Access to crash every time I attempt to open it. I can't open it in any of the views, including Design. I did research and attempted to decompile...

How's everybody doing! I'm by no means an expert in Access, but do have some experience. Can do a minimal amount of VBA, but only through what I've learned from Googling. As it relates to queries, I have pretty basic knowledge of SQL. I usually learn from building the query in design view...