Search results

I have a subform that when launched on its own displays the proper datasheet items against a query. The items listed (lapsed memberships) relate to many of the contacts that managed on the mainform. When I open the subform as a tabbed page on the main form, the datasheet items are automatically...

I have multiple copies of a subA on a form. Each one has a unique name subAA, subAB, .... I am trying to populate text fields on each form based on the contents of a class. I can find the subforms in the controls collection but I can't figure out how to reference the text boxes on each form...

I have a subform in a tab on my main form. The filter works properly...I see all the records I expect. But the OrderBy on the date field does not work, the rows are shown in ascending primary key sequence. The code follows .. Any suggestions? Private Sub Form_Load() If Me.Recordset.BOF...

I'm getting aa strange issue with a clas module. A function (see below) creates some error that is not passed to the error handler. Instead, it falls thru from the exit to the error handler & goes into an endless loop of blank dialog followed by a "Resume without error" dialog. It even happens...

I have a single record recordset that is loaded form a table and set as the forms recordset. All fields that are bound to controls update properly. I have 2 fields whose value change when 2 unbound combobox values change. 1. The value shows as updated in the recordset 2. The call to...

I have a modal data entry form that is launched from a Readonly subform on a tab. Everything displays properly on the form except I cannot chage any field values. The form params are set to True (Allow Deletions, Allow Edits and Data Entry). The form is launched with: If isFinancial...

Thanks for creating this forum. Been C# for quite awhile. Got a request to upgrade an Access system. Having a blast getting back into VB code (been 15 years). So far the site has been invaluable in getting into the patterns that work in Access.