Search results

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...

Thanks for quick reply arnelgp. This may be a stupid question but I'll ask it anyway - 'add the ID to your form' - where do I add the ID to the form? Not to overkill this, but the code that populates this textbox, named txtMatchedVerses is Private Sub Form_Load() Me.txtSearchCriteria =...

Textbox1 displays records from Table1 in a large textbox on a form, separated by vbnewline for clarity. The textbox of course has a vertical scrollbar, but I want to be able to use a button click to move to each record in the textbox. Textbox1 only displays the text of the record, not the...

...I finally got it to work. The code opened up Access and stopped at that point because this path, ac.OpenCurrentDatabase "C:\Users\Charles\Desktop\PDOX DB.accdb" pointed to a desktop icon, not the correct location of the file, which is located in C:\Users\Charles\Documents\PDOX DB.accdb...

Opening a MS 2010 Access form from an Excel : This code had no problem executing correctly in MS Office 2010. This code is not opening the form in Excel 2013. Here's the code: [/code] Sub ACCESSOPENFORM() Dim ac As Object Dim str As String On Error Resume Next Set ac = GetObject(...

How would I open an Access form from Excel... using vba? This opens up an Access window but dosen't open the form: Private Sub openaccessform_Click() Dim ac As Object Dim str As String On Error Resume Next Set ac = GetObject(, "Access.Application") If ac Is Nothing Then Set ac = GetObject(""...