Some episodes have the data available at mackenziemackenzie.com/downloads - you can check by date for the episode you're watching. I don't think I have this video's data but am trying to put more up to work with!
Good question! Update MyTable Set MyField = Replace(MyField, "T", "CH"); Or, create new query, select Update query on Ribbon, put MyTable in query, double click on field to add it to grid, in "Update to:" put in Replace(MyField, "T", "CH") Good luck!
Just beware, that will update every "T" in the table, in every record! If you just want rows starting with "T", then add a where clause, ie. Where Left(MyField, 1) = "T"
You bet. You can use a data macro for this: ruclips.net/video/WIWrMvks1Wo/видео.html Also watch the DM intro: ruclips.net/video/wuyImulb_u4/видео.html An alternate way is to use a query after a form is updated: ruclips.net/video/stQhrFY4k8E/видео.html
Dear Sir, Thank you for the prompt response. After sending the update to you, I was still working on this to find out the issue and I managed to crack down the problem. Though the table was showing indexed when you verify, actually the actual index was on a different field. I offloaded the table to an excel file and reimported and found this. After changing the index from excel file, the program started working fine. But the problem is that I cannot change the index. So currently I am taking a longer way which is taking the input file from a query. Please let me know if you have better ways.
Nice work, you found the problem. You could create a new table with the first field as MyID with type Autonumber. Then, all of the fields of your source table. Append your table into this new table (using Append query). Use the new table for your update as it does not have the old indexes that caused the failure. You can use the procedure method which is much faster.
Exactly what I was looking for.
Awesome! Glad to hear
so usefulllllll,thank u.keep going
Thank you, I will!
Is there a way to download your sample data to follow along with you?
Some episodes have the data available at mackenziemackenzie.com/downloads - you can check by date for the episode you're watching. I don't think I have this video's data but am trying to put more up to work with!
I want to change 1 character in the table table . For example, like "T001" to "CH001", how should the query part be done? Thank you!
Good question!
Update MyTable Set MyField = Replace(MyField, "T", "CH");
Or, create new query, select Update query on Ribbon, put MyTable in query, double click on field to add it to grid, in "Update to:" put in Replace(MyField, "T", "CH")
Good luck!
Just beware, that will update every "T" in the table, in every record! If you just want rows starting with "T", then add a where clause, ie. Where Left(MyField, 1) = "T"
I have 2 tables ..by updating table1 table 2 get updated is it possible
You bet. You can use a data macro for this: ruclips.net/video/WIWrMvks1Wo/видео.html
Also watch the DM intro: ruclips.net/video/wuyImulb_u4/видео.html
An alternate way is to use a query after a form is updated: ruclips.net/video/stQhrFY4k8E/видео.html
Dear Sir, Thank you for the prompt response. After sending the update to you, I was still working on this to find out the issue and I managed to crack down the problem. Though the table was showing indexed when you verify, actually the actual index was on a different field. I offloaded the table to an excel file and reimported and found this. After changing the index from excel file, the program started working fine. But the problem is that I cannot change the index. So currently I am taking a longer way which is taking the input file from a query. Please let me know if you have better ways.
Nice work, you found the problem. You could create a new table with the first field as MyID with type Autonumber. Then, all of the fields of your source table. Append your table into this new table (using Append query). Use the new table for your update as it does not have the old indexes that caused the failure. You can use the procedure method which is much faster.