Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: NewTexican
  • Order by date
  1. NewTexican

    Handling errors

    awesome thanks
  2. NewTexican

    Handling errors

    Is it possible/good idea to have a private sub in my code that handles errors for multiple subs? Can anybody point me to a place that has a list of the error numbers? I'm looking for what number corresponds with "you can't go to the specified record" Gracias.
  3. NewTexican

    all values of combobox same as one combo box

    nice. I used the first.
  4. NewTexican

    all values of combobox same as one combo box

    I previously got some helpful help with the following code, but I'm having some troubles now that I'm trying to add to it. A matrix of checkboxes and combo boxes in a form are populated when the form is opened. The check boxes are being populated correctly, I'm trying to use the same code to...
  5. NewTexican

    code efficiency updating recordset on form close

    works for me. thanks.
  6. NewTexican

    code efficiency updating recordset on form close

    I need some advice on the following code. The user checks a box and selects an address in a combo box for various mailouts. Closing the form saves user selection to a table. My problem is when user opens form up and edits checkboxes or address, it tries to save a new record and I get a duplicate...
  7. NewTexican

    Refer to combo box in a series that depends on variable.

    too easy, man thanks I was not going about that the right way.
  8. NewTexican

    Refer to combo box in a series that depends on variable.

    Ok, I have a column of comboboxes combo11, comb012, ..., combo16. These boxes are next to text11, text12, ..., text16. Thanks to Roy vidar I have a public sub which contains. mlout = Val(Right(Screen.ActiveControl.Name, 2)) - 10 gives me 1, 2, ..., 6 which I save in a field of a record with an...
  9. NewTexican

    msgbox comes up 3 times, why?

    If I make the code look like that and then put [event procedure] in the on click line of the checkbox form design view, it works well. If I put =checkboxclick into the onclick line from design view I get 3 messageboxes. I guess I'll just stick with your code. thanks.
  10. NewTexican

    msgbox comes up 3 times, why?

    I turned off my oncurrent and onload code. So it's not in this code, or a funny quirk that you know of? surprise surprise.
  11. NewTexican

    msgbox comes up 3 times, why?

    I have =checkboxclick in the onclick for my checkbox. I get the msgbox 3 times???? Public Sub checkboxclick() Dim mloutyn As Boolean mloutyn = Screen.ActiveControl.Value MsgBox mloutyn End Sub
  12. NewTexican

    code efficiency refer to all checkboxes

    Ok, nevermind I know where the mytoggle button goes. But know I've got a wierd one. I'm typing in screen.activecontrol.name when I get to the .name part I'm not given .name as a possible option. I'm also going to want activecontrol.value and I'm not given that option either. Is there a special...
  13. NewTexican

    code efficiency refer to all checkboxes

    Ok that's cool and clever thanks. I responded, but my response didn't show up. So I'm responding again. where whould the =mytoggle go? My guess would be that I should open my form in design view go to the checkboxes and put it in the onclick? I didn't know you could do this, if that's it.
  14. NewTexican

    code efficiency refer to all checkboxes

    Ok, that's pretty cool and clever, thanks. The = mytoggle() where does that go? My guess would be open the form in design view and put it in the On click event.
  15. NewTexican

    code efficiency refer to all checkboxes

    ok I guess this is going to bring me to a whole new level here. what is the , 2 and the - 18?
  16. NewTexican

    code efficiency refer to all checkboxes

    bummer
  17. NewTexican

    displaying navigation buttons by code

    Private Sub Form_Load() Me.NavigationButtons = False End Sub
  18. NewTexican

    refresh not working

    I'm no royvidar but I believe all the highlighted parts should be the same Dim lngrecnum As Long Dim rs As DAO.Recordset lngPK = Me!recnum.Value Me.Requery Set rs = Me.RecordsetClone rs.FindFirst "recnum = " & lngrecnum If Not rs.NoMatch Then Me.Bookmark = rs.Bookmark Set rs = Nothing
  19. NewTexican

    code efficiency refer to all checkboxes

    I'm still getting up to speed on vb and programming in general. I have a bunch of checkboxes. when user checks a box a record is created in a table. Right now I have Private Sub Check19_Click() dim vari as long vari =1 code Private Sub Check20_Click() dim vari as long vari =2 code Private...
  20. NewTexican

    don't edit text in combobox

    Thanks houstonian. I didn't get a chance to try this. This is an unfamiliar concept to me. I went ahead and changed the whole thing I was trying to do around, it was getting way to complicated, but I'll keep this suggestion on the backburner and play with it when I get the chance.

Part and Inventory Search

Back
Top