Recent content by Hrithika

repsql5 = Replace(repsql5, "o'", "o''") was the problem. Now the data is updating. However, Now I have a little different problem. The changesmade field in the table is memo field but only getting updated with 255 character. Is there a way I can capture the 'changes' in its entirety?

Changed those two still the same error message.

I have a function that creates the audit trail of any changes made on a form. It doesn't work well if there is an apostrophe. So I applied 5 find and replace rules to cover most common apostrophe occurrences. The code fails at db.Execute repsql5, dbFailOnError . I run the result of...

The query is fine. It is fetching the results without truncation. I was doing something dump. I copied and pasted the results in excel. Here is the fix. Do paste special and select csv..

I did read allenbrowne's article on truncation, but my problem is none of the factors he mentioned are in the query. Do you see something that I am missing? Factors causing truncation Aggregation Uniqueness Format property UNION query Concatenated fields Row Source

Thanks. It worked. Sorry for the late reply. Isn't this forum just awesome? Thanks to all the great folks like you who are willing to help.

I have a query that is truncating a memo field to 255 characters. There is no distinct, group by, format, union or concatenate in the query which are the common cause for truncation. Not sure what is happening. Please advise. Given below is the query. The truncated memo field is comments...

Thank you. It works perfect. Just the way I wanted. I see you have gone back to the old delete statement as it was and added me.form.requery twice. Me.Form.Requery Me.Form.Requery and added Case 3020 Exit Sub in the select case statement on actioncode_change_err: Am I missing something...

Yes. I did download the version you attached. Perhaps the version attached does not contain all the fixes you made. I re-downloaded the version once again to be sure. Attached is the zip with screenshots captured using windows problem step recorder. You will have to scroll down a little to...

Thank you JHB. I did figure this out yesterday evening but forgot to update the post. Just one change from the solution you suggested. The if statement had to be If Me.ACTIONCODE.Value <> "CS90" Or IsNull(Me.ACTIONCODE.Value) = True Then to accommodate null values in the apply action...

Initially it gave me runtime error 2046. Once I commented out the select case in the actioncode_change_err: it worked. However, there is a difference in the way it is working now. Earlier as soon as the action code was applied the record would get deleted. Currently, for the record to...

@JHB, I am ready to try anything and everything. What do you suggest?

I commented out the goto error section, which was a work in progress anyways, to see where it leads. There is no error coming up in the ACTIONCODE_Change() event which runs when I apply the action code. In the code I have me.form.requery which kicks of the form's beforeupdate event. I do need...

I made the change you suggested and commented out the on error goto statement to see where it takes. It generated run-time error 2046. The command or action deleterecord isn't available now. The existing delete statement works as intended. Moreover, I do plan to disable the record selector...

I do have this relational scenario you mentioned. I have one to many relation established. For uploading the database, I imported the data into this from a split database. The relationship didn't carry over. After reading your suggestion I re-established referential integrity and retried...