Search:
Type: Posts; User: Probie887
Search:
Search took 0.01 seconds.
-
August 27th, 2013, 07:40 AM
Good morning jggtz....I got it now the rest of it is okay...I will mark this resolved and thank you so much. Thanks
strSQL = "SELECT * FROM BibleTable WHERE [TextData] LIKE '" & txtName & "%'"...
-
August 26th, 2013, 03:46 PM
I don't understand the debug program. It makes nor sense to me what I am suppose to do.
Watch : : strSQL = "SELECT * FROM BibleTable WHERE [TextData] LIKE '*" & txtName & "*'" : False :...
-
August 26th, 2013, 12:31 PM
I do not know what you are asking.
You said:
So I moved the **** thing.
the msg strSQL contains the same message as post12
Here is the code for the click event.
-
August 26th, 2013, 12:08 PM
When I place it above like the code below nothing moves from the list box to the textbox when it is click and I do not get the error message. But it skips past the following code.
If Not rs.BOF...
-
August 26th, 2013, 11:20 AM
I did it twice first with WATCH
Watch : : Replace(txtName, "'", "''") : "They hatch cockatrice'''' eggs, and weave the spider''''s web: he that eateth of their eggs dieth, and that which is...
-
August 26th, 2013, 10:53 AM
Yes we are going ahead...sorry.
I put the REPLACE thing in the code and ran it. I received the Run-time error '-2147217900 (80040e14)': as in post one. It breaks on the sql entry marked in bold...
-
August 26th, 2013, 09:27 AM
Hello jggtz, this is frustrating I know...so here we go again. First I made a copy of my program so as not to mess with your fixes. In my copy I put code back the way it was if you see in the image I...
-
August 25th, 2013, 06:25 PM
I tried to upload a zip file of my program but the site says its too big, I imagine that is because of the bible.db I still do not know how to fix this thing. The sql was a good idea but still brings...
-
August 25th, 2013, 05:00 PM
The word viper is just a word entered to search for in the database.
-
August 25th, 2013, 04:05 PM
I put a " , " after strSQL and the syntax error went away. I ran the program and end up with other stuff as in image below. After I clicked on the OKAY I received the Run-time error '-2147217900...
-
August 25th, 2013, 03:34 PM
I get a syntax error on this line:
rs.Open strSQL Database, adOpenStatic, adLockPessimistic
-
August 25th, 2013, 08:32 AM
Okay....making progress. In my code I got rid of the error by adding the stuff in BOLD, the one in DARK BLUE loads okay, the three in RED do not load. Now what do I do....any ideas???? I attached a...
-
August 25th, 2013, 06:46 AM
I hope this helps...I highlighted where the error occurs in red, and the load list box event is in blue. As you can see I changed the wildcard * but still nothing I tried "=" in the place of "LIKE"...
-
August 24th, 2013, 07:23 PM
Yes I changed the wildcards and yes it is the same error. Once the list box is full, I click on one of the lines in the listbox to have it open in a textbox on the same page and I get the error. I...
-
August 24th, 2013, 07:15 PM
Thanks for your reply.
Sorry...still get the same error, driving me crazy. Here is the code:
End With
'On Error Resume Next
Set rs = New ADODB.Recordset 'set the recordset
-
August 24th, 2013, 07:03 PM
Thanks for your reply.
Sorry...still get the same error, driving me crazy. Here is the code:
End With
'On Error Resume Next
Set rs = New ADODB.Recordset 'set the recordset
...
-
August 24th, 2013, 06:38 PM
Hi, I am new to coding so I am having a problem. I have a list box with bible verses loaded from a database. When I click on one of the verses to load it to a text window I get and error saying:
...
|
Click Here to Expand Forum to Full Width
|