38 items | 2 visits
Tony Hine's List: MS Access
-
-
-
-
-
Allen Browne
-
-
-
-
-
-
-
-
-
You are mistaken -- Access 2000 does not support OpenArgs for DoCmd.OpenReport, only for DoCmd.OpenForm. You'll have to use a workaround of some sort.
-
-
-
-
-
-
OpenArgs The OpenArgs property gives you a way to pass information to a form as it is being opened. The OpenArgs argument of the OpenForm method is used to populate the OpenArgs property of a form at runtime. It works like this: DoCmd.OpenForm "frmPaymentMethods", , , , , acDialog, "GotoNew" This code is found within the frmPayments form of the time and billing application. It opens the frmPaymentMethods form when a new method of payment is added to the cboPaymentMethodID combo box. It sends the frmPaymentMethods form an OpenArg of "GotoNew". The Load event of the frmPaymentMethods form looks like this: Private Sub Form_Load() If Me.OpenArgs = "GotoNew" And Not IsNull(Me![PaymentMethodID]) Then DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70 End If End Sub This code evaluates the OpenArgs property of the form, moving to a new record if the OpenArgs property contains the text string "GoToNew" and the PaymentMethodID of the current record is not Null. The OpenArgs property can be evaluated and used anywhere in the form.
-
What Are the Form Events and When Do You Use Them? Microsoft Access traps for 29 Form events. Each one of these events serves a distinct purpose. Events are also trapped for Form sections and controls. This section covers the events available for forms and when you should use them. Current The Current event of a form is one of the more commonly coded events. It occurs each time focus moves......
-
-
List Comments
(0)
List Info