Search results for query: *

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...

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 =...

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...

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 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...

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...

I have a dataset that I need to randomly select x number of rows of that dataset, but I want some of the rows to have a greater probability of getting selected than others based on a calculated weight value, although I still want the chance of a row that has a low weight to get selected. Hope...

Hi list! I am trying to figure out the best way to set the location of a database at run time in my vb 6 (sp5) application. I don't think my users will need to set database location often but I want to put an option to be able to if shares or drive letters change. Anyway since I am using a...

Hi list, hopefully this will be easy. I am trying to add a common dialog control to an access 2002 form, but I keep getting an error that says "The OLE server isn't registered. To register the OLE server, reinstall it.". What does this mean? If I try to add the common dialog control...

Hi List. I am having a proplem with one of my forms! I have a combo box that is set to "limit to list" = true and "auto expand" = true in the properties control but when a user starts typing in the combo box nothing happens (i.e. it doesn't auto expand, but it will give you...

Hi list. I am trying to generate a matrix of text boxes based on a users input (i.e. the user selects 6 on my frmCreateMatrix form and the form frmMatrix pops up with a matrix of 6 x 6 text boxes). I'm not so worried about the looping code to do this but I have no idea how to create a text box...

Hello list, hope this is easy. My problem is I have a text field(txtDescription) on a form that may contain reserved characters in SQL, mainly '. When I try to pass the text that contains a ' in txtDescription to an SQL statement in my VBA Code (I'm using ADO) I get a "Syntax error...

Has anyone had problems using the UPPER operator in a WHERE clause in a SQL statement in access? I keep getting an error that say "Undefined function 'UPPER' in expression". Here is my query (note I've tried it via ADO and in access query builder): SELECT...

Hi List! I am having a problem with using the DISTINCT operator in and aggregate function like COUNT in Access 2002. I found some information on the Microsoft knowledge base acknowledging that there is a know problem with some of the ANSI-92 SQL standards in Access 2002 specifically using...

Here is my problem. I want my users to be able to enter a new student without dealing with all the other students in the table, so I have an unbound form that will be used for input of new student information into the stud_info table. I have no problems with the code to put the data from text...