Private Sub cmdCreateDefaultHours_Click() Dim cmd As New ADODB.Command Dim rst As New ADODB.Recordset cmd.ActiveConnection = Conn cmd.CommandType = adCmdStoredProc cmd.CommandText = "HoursTrackingLoadDefaultHours" cmd.Parameters("@hoursTrackingID") = Me.txtHTID Set rst = cmd.Execute() MsgBox rst!msg 'This next line fails Me.cmdCreateDefaultHours.Enabled = False End Sub
|Change AD password via MS Access DB||2||17|
|how to link subforms ms/access VBA||6||27|
|word is recognized as adobe and adobe as IE files||14||17|
|How to use vba code to toggle a text box in access between plain text and rich text or make the output view look like the plain text view where the data is not all lumped together?||3||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!