Search results for query: *

awesome thanks

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.

nice. I used the first.

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

works for me. thanks.

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

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

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

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.

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.

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

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

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.

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.

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

bummer

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

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

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

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.