Search results for query: *

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.

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

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

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

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

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

Would someone please point me to the code that would allow one to select an entry in a combobox but would not allow one to edit the actual text? The combobox is filled with a query. I have limit to list set to yes.

I have a subform that is a continous form. Plan number from mainform & employee number on subform & company number on subform is a unique combination. Employees can work for more that one company. I have a query set up in rowsource of combo that lets user select which company goes with employee...

switchboard button loads a form from another DB how do you refer to db and form in the conditional column of the macro design template?

Ok, this one is driving me super nuts. I have 2 pop ups. One pop is all plans. Other pop up is plans with a certain company. User selects plan from one pop up hits a command button and the plan shows up on the other pop up under the company name. I've done this before and not had any problems...

Can someone lead me to some example code that will let me open a form in one database with a command button from another database?

I'm pulling data from another database into a form on the current database. I want to see a list of records on this form. I can succesfully get a message box to give me the records one by one, but I want a list. Any help for me? Thanks in advance. Public Sub plan_companycall() Dim dbb...

Forms![person f].Form.Command20.SetFocus Me![person address Q subform].Form.Command14.Enabled = False I keep getting an error saying that this command has focus and I cannot disable it. Can you see what is wrong with me redirecting my focus.

I'm using the info from a field on one subform in other subforms. When I scroll to a record on the mainform that doesn't have a record on the subform. I get a "you have entered an expression that has no value" error. NZ and Trim$ don't get rid of this error. Any suggestions? I'll get the error...

I'm having an issue with disabling buttons that still have focus. Is there an opposite of setfocus?

I have a delete command button on the parent form. Nothing special just regular old delete made with the wizard. I have a subform that links to the parent form, nothing special once again built with the wizard. The subform is based on a query. When the user deletes a record cascading deletions...

Something tells me their might be a way to write this snippet of code better. 'closes all forms that can be opened from this one Private Sub Command57_Click() On Error GoTo Err_Command57_Click Dim stDocName As String Dim stdocname2 As String Dim stdocname3 As String Dim...

I have a pop up that relates to a parent form and changes as user scrolls through parent form. I'm getting "Runtime error 13 type mismatch" when I scroll to an empty record on the parent form. Debug takes me to either the highlighted line or the code on a subform that points to this sub. Public...

Scrolling through a parent form updates info on a pop up form. My guess is to put something like the following in the form_current of the parent form. (rstable is my recordset) (company mailout f is my pop up form) Forms![company mailout f].rstable.Refresh That don't work Forms![company...

2 textboxes on a pop up form control other things on the form. These textboxes get their values from the form they pop up from. When the user scrolls through records on the main form with the pop up open I want the pop up to update as well. This is my code for the pop up in form_current...