Search results

  1. K

    Multiple Controls on one sub

    I have 10 check boxes. I want all of them to run a function after update. Is there a way to put all 10 on one sub, instead of having to have a sub for each box? Instead of Sub Chk1_AfterUpdate() Function End Sub Sub Chk2_AfterUpdate() Function End Sub etc... Could I have something like...
  2. K

    Reset created item counter on form

    So lets say I create 80 text boxes. They'd be auto named Text1 through Text 80. Then I delete the last 40 of them. So now I have Text1 through Text 40. If I create a new one, it becomes Text81. Is there a way to make it start with the next available (Text41) instead? Also if I create a...
  3. K

    Using Variables in controls

    How can I make this work correctly? I have 10 text boxes and I want to use the loop to make them not visible. For i = 1 to 10 Me.Texti.Visible = False Next Tried different punctuation and even putting parts of it into a variable but still failed.
  4. K

    Split word into letters

    Can I use split like this? myVar = Split(whatever)(0) myVar1 = Split(whatever)(1) myVar2 = Split(whatever)(2) myVar3 = Split(whatever)(3) resulting in myVar = w, myVar1 = h, myVar2 = a, myVar3 =t, etc...
  5. K

    For Next loop logic

    My code: Dim rfoct As Integer For i = 1 To 5 rfoct = Int((999 - 100 + 1) * Rnd + 100) Form_MyForm.MyField = rfoct Next i I want to see each number, then have it overwritten by the next number. Slow enough to see the number. Right now the loop either goes so fast or I only get the last loop...
Back
Top Bottom