Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Private Sub cmd_PrintOnlApps_Click() On Error GoTo Err_cmd_PrintOnlApps_Click 'Open r_Apps_ONL report using criteria from an unbound Form field 'The User is to enter a date in the unbound form field txt_AppDate Dim stRptName As String 'Report to open Dim dtRptField As Date 'The Report's date field Dim dtFrmDate As Date 'The Form's field containing the user's input date stRptName = "r_Apps-ONL" dtRptField = "Reports!" & stRptName & "!date" dtFrmDate = CDate(Forms!f_PrintAppsFromDate!txt_AppDate) DoCmd.OpenReport stRptName, acViewPreview, , dtRptField & " >= " & dtFrmDate Exit_cmd_PrintOnlApps_Click: Exit Sub Err_cmd_PrintOnlApps_Click: MsgBox Err.Description Resume Exit_cmd_PrintOnlApps_Click End Sub
|unable to create table-based data macro in MS ACCESS 2013||11||24|
|Need help constructing a conditional update query||16||43|
|Problem copying record details to a new record||5||8|
|Opening forms with an input box||5||19|