Search results for query: *

Thanks gmmastros. That helped alot, but I am still getting the time like this: 06:03:00 Is there any way to drop the trailing zeros and have it look like this: 06:03 elmorro :-)

Hi all, I have written a query that returns the StartTime field, but it returns it with the date attached to it: 1900-01-01 06:30:00.000 How can I format the field so that it only returns the time: 06:03 ? Thanks is advance, elmorro :-)

Hi all, I have a VB application that generates the following error when it connects to the SQL database: Run-time error '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. What does this mean? I have never gotten this before. Thanks in advance for...

Thank you all for your quick response. Gmmastros, your code worked. elmorro :-)

I have written a stored procedure that is suppose to return records from the previous day. I can't get it to work. Can someone please tell me what I am doing wrong? Here is the Stored Procedure: CREATE procedure dbo.GetNPT as DECLARE @ERRORCODE int Declare @EndDate DateTime Set @EndDate =...

I am using a Listview in my VB6 app. The third column of the Listview displays an employee id. Is there a way to display the employee's name in the Tooltip when a user hovers over a cell in the employee id column? Thanks in advance, elmorro :-)

Thanks Adrzejek and TipGiver. The code works great! elmorro :-)

Thanks TipGiver and SkipVought for your quick response. elmorro :-)

Hi all, I have a program that gathers an employees Start and End time spent working on a given order. I need to help finding the duration in minutes. Here is an example of the data gathered. Start Time: 10:30:00 AM End Time: 12:30:00 PM The duration should be 120 minutes. How can I do this...

Hi all, I use a ListView in VB6 to display all of our Sales Orders. The list can be quite long. I would like for users to select an item in the listview and be able to select a column header for sorting. Once the sort is complete I would like the listview to move to the record they had...

ADoozer, Thanks for your feedback. I will try it and see how it goes. elmorro :-)

I have written an ap in VB6 that opens up an Excel spreadsheet as read only, because I don't want anyone to overwrite the file. I also don't want anyone to use the Save As feature to save the file somewhere else. Is there a way to lock the file or just prevent the users from using the Save As...

Hi all, Is there a script that will bootup a computer that is turned off? Thanks in advance, elmorro :-)

Thanks Swi, I will do as you suggested. elmorro :-)

Golom, Thanks for the code. I am also using the following code to save the file: objWorkBook.SaveAs "C:\ExcelFile.xls" But if the file is an existant file it pops the following message: The file already exists, would you like to replace it? Is there anyway to stop this message from appearing...

HughLerwill, I kept getting an access denied error. But I change file path and it works now. Thanks.

I have an excel file that I need to delete when my program is ran. I tried using the following code: Kill "C:\ExcelFile.xls" but it did not work. How can I accomplish this. Thanks in advance, elmorro :-)

Thanks strongm. I will use the textbox with the timeout. elmorro :-)

Wantok52, Thanks for the link. I will definately look it up. I'll let you know if it's what I need. elmorro :-)

Thanks HughLerwill.