Search results

  1. C

    Next record code moves to the next record in two sets of records in two textboxes when it should be only be moving down on one

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

    Next record button to move to the next record in a textbox

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

    This code won't execute...

    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(...
  4. C

    opening an Access form from Excel using vba...

    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(""...
  5. C

    I had to reformat my laptop and...

    I did save my Access Database3.accdb and all of its forms. When I reinstalled MS Office 7, the following code did not work properly or at all. This code Private Sub Form_load() Go.Visible = False Nextbtn.Visible = False Fldname.Visible = False SearchVal.Visible = False End Sub Private Sub...
  6. C

    Builiding a custom Zoom Box to display a large amount of data...

    Microsoft's built in zoom box allows viewing a large amount of data in a pop up dialog form. I don't like it's looks at all, so I want to do the same thing except using a slicker custom form, Form1. A single click or a double click on any field on Form1 opens the custom form, Zoom. Database3...
Top Bottom