If anyone is interested, I solved my problem by replacing the commas with semi-colons in a new field and then parsed out the text. This worked just fine.
-Andi
Some background: I work for a local government and our land management software has building drawings in it. These building drawings are in a special format with both a picture and a command line, however the format they are currently in can't not be brought directly into ESRI GIS software...
You may very well be right, but the problem is that I am not writing the string, I am just taking it out of a memo field in Access. There are some two or three thousand records in the Access table which have commas in the string. How can I recognize the comma in the original string to know...
I am working on a script that writes the contents of a field in Access to a text file and then parses the text and translates it from the drawing command line instructions it was in into AutoCAD command line. However, I have run into a problem. In the command line it is in, the directions are...
Thanks. No the form is not attached to a query perse, the code I wrote is the where clause on the open form. I forgot about the whole different types of join thing. That would help out tons... Thanks for solving my all my problems.
I have a form which searches certain fields in my database for the information entered and displays the results. I am having trouble understanding why only certain records are returned even though more records match the query. I think it has something to do with the fact that the form searches...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.