Search results for query: *

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...

Try the ListField Property.

Is this function resides in DB(Stored Procedure) or just a function in your program?

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...

Yep that's correct, but in dealing with Date I prefer adding &quot;#&quot; around the variables [JobDate] < #&quot; & MaxDateReport & &quot;#&quot;