Search results for query: *

nevermind. I fixed it. I grouped all the OR statements with parentheses and it worked. Nothing like talking to yourself and figuring out something on a forum.

I just changed the statement where there is a series of OR statements and then a final AND statement but it still did not work. So if you have if A=B OR A=C OR A=D AND XYZ = 1, how do you get this to work to use any or all the OR statements PLUS the AND statement?

I am using VB 6 in querying a table in an Access DB. I have the following query I cannot get to give me the desired results: "SELECT * FROM SLPT WHERE AP = 'x' AND CONCEPT = 'Phonics - Alphabet Recognition' OR CONCEPT = 'Phonics - Print Awareness' OR CONCEPT = 'Phonics - Letter Sound" What...

Thank you. That did the trick.

I have a VB6 app that is using Microsoft Access 2000. I opened the database in exclusive mode and set a password. In the VB app I am trying to open the database. I am using the following syntax: Dim ADOConn As New ADODB.Connection ADOConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data...

Never mind. I figure it out. In the sql string of: strSQL = "SELECT * FROM SLPT WHERE DESCRIPTION LIKE '" & "%" & searchword & "%" & "'" DAO apparently does not like %. I substituted asterisks "*" instead and it worked.

This is on my development computer. There seems to be some subtleties between ADO and DAO and what you get from SQL statements such as using the LIKE command. I cannot get the LIKE operator working with DAO.

I have a program where I initially used an ADO data control with a grid. When I used a SQL LIKE operator it works and displays the expected data in the grid. Because of the end user (i.e., '98, ME, etc.) I cannot use the ADO data controls because info does not show up on the grid. So, when I...

thank you hpetia, that fixed it. Also, thank you strongm for your code.

Tried that but did not work. Need a VB.Net "start in" [folder] parameter for VB 6.

Shell "C:\ASSESS\KIDSWAY.EXE ASSESS.LAP", vbNormalFocus. The problem is that when kidsway.exe starts it apparently calls another program in that folder called slrun32 or something like that, which in turns apparently loads information from assess.lap. When I tried it in VB.NET it...

I have an application that I am using the Shell command to run. My application is in another folder. However, the application I am trying to run will not run even when passed an argument which it needs. The problem is that somehow my VB program needs to be in the application's folder in order...

Does anyone know of any routines to dock controls in VB 6? Some of our users still use 640 x 480, however some will have much higher resolution. For example, buttons on the bottom of the screen need to stay there, regardless of the resolution. Or fields and grids in the middle of the screen...

forgot to add: ADORs.Open sql, ADOConn

it is still not working for me. let me summarize and provide some code. I have true db grid which is associated with a data control (Adodc1). When the recordset of Adodc1 changes, the grid redisplays new data. I am trying to set Adoc1.recordset to ADORs and some property so that the...

I did set it to: Set Adodc1.Recordset = ADORs and i ran a query but nothing shows up in the grid, which is set to the data control Adoc1.

that does not quite work because adors does not have the recordset property. Any other ideas? set Adodc1.Recordset = adors.?

I have a situation where programmatially I have established a recordset object (Dim ADORs As New ADODB.Recordset). I am using true db grid which depends on a data control. I want to set the recordset of the data control to the recordset of ADORS. For example: data1.recordset =...

thank you nicsin and TLowder. I have it up and running. I really appreiate your help. It is amazing that I can go into a VB 6 book that I own and NOT find this simple approach but yet go to a Forum like this and get the needed help within minutes.

Thank you very much for your post too. One more question. With the query set to: SQL = "SELECT * FROM TeacherID WHERE TID =" & "Text3.Text" I get an error back that says "No value given for one or more required parameters." Can anyone tell me why I might be...