Recent content by breezett93

The change to the data type was made on Monday. Prior to that, this button has always worked and never had a problem. That's why I'm confident it's related to the data type change. This code has been untouched. Is it possible to just decompile and recompile the one form?

For the button being pressed? Private Sub AddOnCharges_Click() DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE DISTINCTROW IvcDetTbl INNER JOIN OrdDetTbl ON (IvcDetTbl.OrdItm = OrdDetTbl.OrdItm) AND (IvcDetTbl.OrdId = OrdDetTbl.OrdId) SET OrdDetTbl.Cmplt = Yes WHERE...

So the purpose of this button is to apply values/charges from OrdDetTbl to IvcDetTbl. So, all the fields on the left side except for OrdId would be null, and the fields on the right side have the values/charges that will be applied to IvcDetTbl.

I just completed the refresh and still get the error.

I recently had to convert a field in all of my tables because we hit the maximum limit. I rebuilt the relationships exactly to how they were before the change. So, the user clicks a button that starts the code below. Somewhere, Access is remembering what the old data type was and not allowing...

Wow! Thank you so much for putting so much effort into this. I look forward to testing it out!

No, only the Spec Order Info had the problem. I disabled Can Grow, and this worked as a temporary solution.

My understanding is that there should only be one instance of the word in the cell. That's coming from the users actively using the data. So maybe we start there since numbers are harder to track.

Thank you for that info! I will try.

Link to data: https://docs.google.com/spreadsheets/d/1Eqdfh3wPtQ-UBD54PHt2f7ogOLMQJezB/edit?usp=sharing&ouid=113154681399471447599&rtpof=true&sd=true

11/16 49 97 11/16 49 97 -> 11/16 49 97 11/16 61 97 11/16 61 97 -> 11/16 61 97 1 Duraflake 49 97 Durafl -> 1 Duraflake 49 97 I will pm you link to the table as links aren't allowed in post.

A. Table name = ItemTbl Field Name in question = Desc B. There's over 2200 records in this table, potentially hundreds need correction. I can export the entire Desc column if you really want that. I hand-picked several examples to give an idea of how the data currently looks.

I've got a table where some of the cells in one column have nearly identical information entered twice. Here are some examples: I need a query to go through the whole table, catalog what data is in the cell, and delete duplicate text. So in my examples, the extra 11/16 49 97, 11/16 61 97...

The gap appears only when the Application sub-report has more than record to display.

Sorry for the delay. Here is what the report looks like in Design View. So, to answer some of the questions: @CJ Both Special Order Info and Application are subreports. Can Grow is enabled for both of them. @Pat In Design View, there is no gap. There is just a change from OrdId Header to...