Search results

Laura, Also for the code: Me.Section(acDetail).Controls Change the Me. part to the Option Boards form name. By default it will be frm.

You probably won't need to put in the text field names, if Name, SSN and Date are the only text boxes in the detail section.

Please change: For Each ctl In Me.Section(acHeader).Controls to: For Each ctl In Me.Section(acDetail).Controls

Place a timer code into the FormLoad() event, make it start as soon as the form loads, then use Me.Requery inconjuction with the timer code to continually refresh and update the form. You need to provide more information. e.g. what forms do you have? what codes are there? David,

If you choose to place the code in the Afterupdate() event it should look like this: Private Sub obFuture_AfterUpdate() 'Place your code here or testPastFuture Private Sub obPast_AfterUpdate() 'Place your code here or testPastFuture Another alternative is to create a module and place the...

Place your code into the Afterupdate() event. David,

Add this code into the "View All" and "View Schedule" buttons: If me.Dirty then me.Dirty = False End if Place this code into the "View All" button Me.Filter = "(False)" Me.FilterOn = True

Hi Meli, Are are the time ranges separated into different fields, e.g. Field 1 contains 9:43, Field 2 contains 9:50 etc.? Also change the data type to text. David,

Hi Laura, Assuming you have a close command button on the form, try placing this code in the close button, this code should blank out the text boxes, and return to the Option Board: 'Purpose: Clear all the search boxes in the Form Footer, and show all records again from the details form. Dim...

Hi ALui, Try putting this code into your "View All": DoCmd.ShowAllRecords 'Purpose: Clear all the search boxes in the Form Footer, and show all records again from the details form. Dim ctl As Control 'Clear all the controls in the Form Footer section, replace (acFooter) with the section...