The Datetimepicker does the select time ok, but I'm really looking for a time ruler that can display the complete day with the start to end time highlighted similar to appointment scheduler in microsoft outlook.
I have a form with a start time and end time text box. Does anyone know of an activex control I could get that would display the complete range of time selected from start to end such as a time ruler with markers or clock, and that the user could edit the start and end time by clicking on the...
I have a report in Access that has been formatted to display borders around each record so that it appears as a table and that table has got to have a certain number of rows per page. my problem is I need the last page to continue with the table rows to the page footer even if there are not...
Could anyone get me started on writing a sub to check if the following fields are complete.
Something like this:
If Me![Mydate] = Null Or Me![StartTime] = Null Or Me![EndTime] = Null Then
Me.AllowAdditions = False
Else
Me.AllowAdditions = True
End If
I'm probably not even close, could you...
I tried this, I doubt I'm even close.
Private Sub Form_Current()
If Me![Mydate] = Null Or Me![StartTime] = Null Or Me![EndTime] = Null Then
Me.AllowAdditions = False
Else
Me.AllowAdditions = True
End If
End Sub
Could you get me on the right path,Please????????
I have a form which stores data on a date, start time, & end time of an event. I need to save the record without the end time until I can update that field at whatever time the event ends, but I do not want to allow a new record be added until the previous record is complete. Is this Possible...
Thank you for helping me! I Really appreciate it.
Would you also know of anyway I can make the input box display *astericks as you type, similar to a password input mask.
Could anyone help me? I wrote the following vb to require a passcode to validate a yes/no check box.
Private Sub Check41_BeforeUpdate(Cancel As Integer)
Dim strInput As String, strMsg As String
strMsg = "Enter Authorization Code"
strInput = InputBox(Prompt:=strMsg...
I tried this
Private Sub Date_DblClick(Cancel As Integer)
Me!Date = Date
End Sub
but it still isn't working. The () after date keeps disappearing after I move to the next line.
Can someone tell me how I can double_click and get a date control to display the current date using VBA. I used a macro to do this on the Double_click event but I want to use VBA. Please Help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.