Buddy008,
If you thought there was no way to tell the difference if the user pressed Cancel or OK on an InputBox, you're wrong.
You see, if the user presses cancel, vbNullString is returned. However if they press OK, the empty string ("") is sent back.
But in Visual Basic...
The reason why the record count = -1 is that we need to specify the cursor location. In case ADO is being used, you can specify the cursor location as
ConnectionObject.CursorLocation = CursorLocationEnum.adUseClient
By default, the cursor location is CursorLocationEnum.adUseServer
And once...
Hi rushtome
There is one abnormality I noticed in your code.
'Param2' has variable lengths (1 and 3) when ComboAdHocIT.Text = "No" and ComboAdHocIT.Text = "Yes"
I guess the correct code should read like,
If ComboAdHocIT.Text = "No" Then
.Parameters.Append...
A better way to limit users to enter only numbers would be to use Microsoft Masked Edit control instead of the text box.
Include this control in your project and pull up CUSTOM properties for this control.
Set the mask to ##(this would limit the users from entering only 2 digit numbers)...
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.