Search results for query: *

Several years ago I wrote an Access/VBA app for a client. Been working fine since. Was written in Access 2002, clients' IT upgraded to Access 2003, SP3. Of the entire app, there is now a single malfunctioning ComboBox. The box simply lists the 1st/key column of a table for selection. Currently...

Simple need: to fill-in a form-based new record with data from the previously added record. The FAQ's lead to this: Private Function SetDefault() Dim ctl As Control Set ctl = Screen.ActiveControl ctl.DefaultValue = """" & ctl.Value & """" End Function then bind the function to...

I have a form. It's quite complex and has multiple selection criteria. The point being, when the form is open, its recordset constitutes the universe I would like to create a report from. The only way I've been able to succeed in this: 1. Open the form hidden ...Display "WAIT" 2. Assign a...

Situation: Form with subform, linked parent/multiple child with referential integrity enforced. Processing with pretty deep code. On occasions, the subform has no retrieved records(rare, but expected in one specific situation). Subsequent assigning data to field of non-retrieved record fails...

I'm trying to reliably (of course) determine if a DoCmd.openform returns no records. The forms are query based, some of the queries have embedded [enter parameter ?] criteria, and some are driven from form fields. 1. A method I discovered here in this forum recommends using...

I have a form with 2 controls. A combo box that has a row source in a table, nothing fancy, just the only field, all records. A continue button. The on-click event is set to basically no-op. When I open the form programmatically, it opens, and doesn't wait for any events, it just returns...

I'm trying to create a query criterion that does one of two things: 1. If some abitrary field condition elsewhere is true, query on this: Like "*" & [Serial Number?] "*" a 'wildcard' search base on the Serial Number or fragment entered in the parameter box. 2. If the the arbitrary...

I have a text box, which I want to allow changes, but with a strong warning to be sure. Proc tied to BeforeUpdate event: Stolen straight from the Access doc's/examples. Private Sub Text39_BeforeUpdate(Cancel As Integer) Dim strMsg As String strMsg = "Don't Do It !" If...

1. Have an Access form with several controls with custom 'on-event' code. One procedure was tied to the 'Lost Focus' event on a ComboBox. I wasn't happy with the usability of that and tried to link the procedure to a different event on the same control/form. I now receive this message. "The...