CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Probie887

Search: Search took 0.01 seconds.

  1. Replies
    31
    Views
    25,636

    Re: ListBox

    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 & "%'"...
  2. Replies
    31
    Views
    25,636

    Re: ListBox

    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 :...
  3. Replies
    31
    Views
    25,636

    Re: ListBox

    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.
  4. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  5. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  6. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  7. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  8. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  9. Replies
    31
    Views
    25,636

    Re: ListBox

    The word viper is just a word entered to search for in the database.
  10. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  11. Replies
    31
    Views
    25,636

    Re: ListBox

    I get a syntax error on this line:


    rs.Open strSQL Database, adOpenStatic, adLockPessimistic
  12. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  13. Replies
    31
    Views
    25,636

    Re: ListBox

    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"...
  14. Replies
    31
    Views
    25,636

    Re: ListBox

    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...
  15. Replies
    31
    Views
    25,636

    Re: ListBox

    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
  16. Replies
    31
    Views
    25,636

    Re: ListBox

    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
    ...
  17. Replies
    31
    Views
    25,636

    [RESOLVED] ListBox

    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:
    ...
Results 1 to 17 of 17





Click Here to Expand Forum to Full Width

Featured