Search results for query: *

BjornOne, thanks for the snippet of code. I ended up using the csv module like you show. You get a star for your post. kgk

Thanks for the code StoneDeCroze, this really helps me get going. Being a python newbie examples that apply to what I am trying to do are very helpfull. Thanks again. nv_wildfire

StoneDeCroze, Thanks for the reply, here are a few lines of the csv file. 42.23133813, -121.44313522, "maybe1", ff00ff 42.23132888, -121.43319847, "maybe1", ff00ff 42.22792478, -121.43320996, "maybe1", ff00ff 42.22802306, -121.44307129, "maybe1", ff00ff...

I know this is a very simple question, but being a python newbie I need some help (this is my first project trying to use python instead of VB). I have a CSV file that is exported from a program called terrain navigator, I want to read in the data from the CSV file and then write it out as an...

Just a note to others. When passing wildcards in an sql statement while connecting to MS access with ADO use "%" as your wildcard character. When using wildcards in MS access use "*" as your wildcard character. It took the help of others and many frustrated hours to figure...

Thank you onpnt and funka!!!! That was my problem, needed to use a '%' instead of '*'. kgk

Thanks for the input everyone. I'll try using brakets around my field name in the WHERE clause and I'll also add the % instead of *. Shaddow, I am connecting to access with the Jet OLEDB provider. I won't be able to try this until monday when I am back at work. kgk

Hey list, I've got a problem that is just killing me. I am using ASP 3.0 and connecting with an access 2000 database with ADO. The problem is in my SQL statement. I know this because I am not getting any records returned (i.e. objRS.EOF and objRS.BOF). Here is the SQL statement: strSQLS =...

CajunCenturion, Thanks for the input. To add a report object do I assume I have to add the report control to my tool box? I have done so but the icon it adds just say OCX (doesn't have an icon that looks to have any meaning) and gives a .dll error when I try to add it to my form? Any...

Thanks everyone for the quick response. I am now starting to realize what my problem is. I am using VBA instead of VB. I am thinking that textwidth is not available in VBA? Can anyone confirm this? Thanks in advance. kgk

My dilemma is that the software I am using (ArcMap 8.2) does not have word wrap for its text elements. So when I have a user enter a bunch of text on a form and then when I try to place that text on a map as a text element (basically a label) the text will extend out until the end of the string...

Thanks John!!! It seems so obvious now. kgk

Is there anyway to have a set a label on a form to the version of the software. All I want is to automate the version in my about window. I have the VB IDE auto incrementing the version number, how do I recall that information for use in a label. Hope that makes sense. I know I could just...

I figured out whate the problem was, if you try to read in a file name that is longer than 8 characters it will bomb. So what I do now is test for file length and if it is longer than 8 characters it copys the file to a temporary file. The following is the code I finally used, it works great...

I cannot figure out what I am doing wrong and it is getting pretty frustrating. Maybe someone out there can see my error or at least point me in the right direction. The following is the code I am using: strSQL = "SELECT * FROM " & dlgOpenDBF.FileTitle Set fConn = New...

Hello everyone, I think this is an easy question so here it is. I am creating a DBF file with ADO, the following is the code used: Set fConn = New ADODB.Connection fConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & OPath & ";&quot...

Robert, thanks a million that worked perfectly. thank you, kgk

I think I am completely missing the problem here. I have 5 text boxes (txtregime1, txtregime2, txtregime3, etc...) that I want to loop through and put there text into a database, should be no problem? I keep getting a type mismatch error when I set my objtxtbox to a string that is the name of...

CajunCenturion, Thanks again for the information. It really helped. kgk

CajunCenturion, Thanks for the help. I think your idea will work perfectly. My only concern is that the array should be shuffled so that not all numbers with a high probability are together. This may be an invalid concern, I don't know. Again many thanks for your input. Thanks you, kgk