If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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 also tried using the "=" in the code...doesn't help.

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" but still I get the error. I even tried messing with adOpenStatic, adLockPessimistic, adLockReadOnly stuff but nothing works. I tried to eliminated 3 of the text boxes I wanted filled but I still get the error.

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 .jpg file of the screen shot so you can see the boxes.

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 (80040e14)' (same as before) It stops at the line rs.Open strSQL, Database, adOpenStatic, adLockPessimistic

Re: ListBox

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 up the error. The error occurs at the text in RED. Images show the errors in order I get the first message box (don't know why) click OKAY and the second error box appears. The images with the line of text highlightd should be listeste in the box above with the book, verse, chapter.