I've experience a power failure that makes my database a suspect and unusable. So what I did was to detach the suspect database and then reattach it. However, when attaching the said database using sp_attach_db, I've encountered an error like this:
-------------------------------------------...
----------------
The section of code you question is to compare the date the user logon to the system against the user expiration date set in the user table.
----------------
Then this must be the code. This will compare the date the user logon to the system (GETDATE()).
(SELECT @ExpDate =...
Your Code is:
'Add MyStr to MH3DListBox; set item data to Comp_id.
List1.ItemData(i) = MySet.Fields("Comp_id")
List1.List(i) = MyStr
Change it to
'Add MyStr to MH3DListBox; set item data to Comp_id.
List1.List(i) = MyStr
List1.ItemData(i) = MySet.Fields("Comp_id")
You must...
This is my first stored procedure, so the code is not that good, I learned it from Transact-SQl Help just this day.
Here's the code.
create procedure VALIDATEUSER
@@ValidityCode int OUTPUT,
@@RegisterUserIDY int OUTPUT,
@@INUserName varchar(10),
@@INUserPassword varchar(10)
AS
set...
You declared your variables under Form_Load Event
Private Sub Form_Load()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
.....
right? That's not right, because your variables scope will be just in that Procedure/Event. Try to move your variables under the General...
Your MaxDateRepor variable, I think, correct me if I'm wrong is formatted into an "MM/DD/YYYY" date format, so the value would be eg. 11/19/2002, right? But the underlying value of your [JobDate] field would be probably formatted into a "MM/DD/YYYY hh:mm:ss AMPM" so the value...
If you want to move/resize only the active form then this will be the code.
Private Sub MDIForm_Resize()
If Not MDIForm1.ActiveForm Is Nothing Then
MDIForm1.ActiveForm.Move (Me.ScaleWidth - MDIForm1.ActiveForm.Width) / 2, (Me.ScaleHeight - MDIForm1.ActiveForm.Height) / 2
End If...
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.