Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with sql update using vb6
Oh and.. To prevent running into an error in case of null values, I use another sub to delete tabledefs without records. All other records should have the the layerfield having at least 1 "_". Thanks all.- Tekenbeet
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with sql update using vb6
Wow, Thanks TheIceMan1, Here's syntax I use now. Il'l do some more testing, but it seems to do the trick. 'OLD only works from within ACCESS 'sql = "UPDATE " & t & " SET " & t & ".SORT = IIf(InStr([LAYER]," & Chr(34) & "_" & Chr(34) & ")>1 And InStrRev([LAYER]," & Chr(34) & "_" & Chr(34) &...- Tekenbeet
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with sql update using vb6
Hi All, I have a python script that generates an access mdb with tables. These tables need some serious reformatting. I used to import a module by hand and run some macro's to do the job. Now I try to migrate this module to the software(Esri ArcGIS) from where the python script is run. Now I'm...- Tekenbeet
- Thread
- Replies: 11
- Forum: Microsoft: Access Queries and JET SQL
