Recent content by ChazRab

Perfect! Thank you so very much Both scroll independently as they should. I noticed changes to the verse citations which is OK if needed. to make this work. Typically, at then end of each verse in any Bible software app, is the Book, chapter, verse and translation - i.e., Matthew 23:15...

Hi arnelgp. I now know how to unblock the file - thanks. Question: is this the latest update? - here is an update https://1drv.ms/u/s!ArMbLCnMkq_Fk3wgA9S3g1uinOI4?e=4xtoZI I downloaded this file once more and the Next button causes Textbox2 to scroll also. In previous post I mentioned...

Hi arnelgp - thanks very much for staying with me on this. Unless i missed something, I didn't see any changes. The next button stll moves the cursor of txtMatchedVerses AND Textbox2 both down 1 record. As mentioned, I went in and tried to change some things myself in the getverse code, but...

Sir - you are making an incorrect assumption. I HAVE studied the code. As I previously mentioned - I am new to Access VBA - and I take nothing for granted - why would you even make a remark like' 'when you get everything handed to you on a plate. No time is taken to study and understand the...

..I admit its a clumsy title. I was helped with this Next button by another more experienced member. The code will advance the cursor position down 1 record as it shout but in two textboxes. These are independent search results. BUTTON CODE: Private Sub NextVerse_Click() Dim i As Integer...

I noticed that when the Next button is clicked, both txtMatchedVerses AND Textbox2 move to the next record simultaneously. These are separate search results. Each has to have its own Next and Prev buttons. "ll try to see if I can fix this on my own without having to keep coming back to you...

Hi arnelgp. You had the getverses code to move down 10 verses, not 1 to the next verse. I just changed the 10 to a 1 and it works great. See in your code below. Clicking the Next button moves it down exactly to the next verse. My thinking is to copy this code to a Prev button to go back...

Hi Gasman - thanks. At this point, I have no idea of how to 'have left them as records in a subform' and how to do this. I've not worked with subforms - yet. A Maketable query on the main source sheet that the criteria being searched produces a new table from tha query - which to me is just...

Hi Pat - thanks for replying - I'm unsure about displaying a report in an Access form - all I'm trying to do is develop a Next button - easy in Excel VBA - easier said than done in Access VBA - due to me being in an infancy stage with learning Access This code block arnelgp sent earlier seems...

...forgot to ask, what did you mean by the bookmark feature ? - are you saying there is a way to return to the same verse when the focus is removed from the textbox that the cursor was on in that verse ? - that would fix a major problem. I just moved from one textbox to the other when I went...

Sorry for the confusion. All this form does, is allow for two searches to be done using two textboxes at the top right next to the Go buttons, clicking the Go buttons and the two larges textboxes are populated with the results respectively. The verse+ button allows entering any verse in the...

......If you click on the SEARCHF form at the bottom of the Forms section, you'll see the form I've developed so far. This is the main form a user sees when the app is opened. I deigned it to fit my entire laptop screen - it should for 'any users machine : (0,0) setting in Form Load. The image...

Link copied below. Hopefully, i did this right. Please let me know. cr https://www.dropbox.com/scl/fi/fgdsx2m7pn1hw3yemriox/BEST-BIBLE-APP.2.28.24.accdb?rlkey=0umdoa0wj4gccuot8i672f15f&dl=0

I saved the file to the desktop and attached it below. After thinking about your first reply, I went back and looked at the table structure. There was only 1 field. So I added an ID field thinking about the logic behind your first reply. (Access has to have a way to identify each record...