Search results for query: *

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

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 :-)

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

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 :-)

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 :-)

Hi all, Is there a way to create a Message Box in VB6 that does not have any buttons and disappears after a specified time (i.e. 30 seconds) without any user interferance? Thanks in advance for your help. elmorro ;-)

Hi all, I did not know would best fit the following question, so I decided to post it here. I have an Ipod which I plug into a USB port in my home computer. I can't get it to read from theses ports. My ipod reads fine when I plug into a USB port at my work computer or in my laptop. I have...

Hi all, I have written the following Stored Procedure: DECLARE @ERRORCODE int EXECUTE @ERRORCODE = ProcessTimeLog '12/1/2006', '12/10/2006' I would like to modify this Stored Procedure so that the second date parameter always equals today's date. I made the following changes but I keep getting...

Hi all, I need assistance restoring from a backup. I am using Veritas Backup Exec 9.0. I don't know the procedure, can anyone help? Thanks in advance, elmorro :-)

Hi all, I get the following error message when trying to log-in to Outlook: Unable to open your default e-mail folders. The information store could not be opened. How can I fix this and log-in to my Outlook? Thanks in advance, elmorro :-)

Hi all, I have a field in an ACCESS table that allows the user to provide an address. The Street,City and State are all placed in the field and seperated with a comma. I would now like to break-up this field into three separate fields. Is there a query I could write or a function I could use...

Hi all, I get the following message when I use xp_sendmail: Server: Msg 18030, Level 16, State 1, Line 0 xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. How can I fix this problem? Thanks in advance, elmorro :-)

I am a silk screener and all of my art work is done in a Mac. Most of my customers however create their artwork using the Windows version of Illustrator. How can I open artwork created on a PC on my Mac and vice versa? Thanks in advance, Elmorro :-)

Our Blackberry server was down last night and most of this morning and our users did not get their emails forwarded to their Blackberrys. I rebooted the server and they are receiving their emails now. I need to resend them any emails that did not get forwarded while the server was down. How can...

Hi all, I have added a toolbar with a couple of buttons to my VB application. One of the buttons has a button menu. Right now the button menu only gets displayed when I click on the button menu itself. I want the menu to also display when I click on the button, but I can't get it to work...

I have written a script that iterates through all the computers in my domain and returns their processor information. I do this using a FOR LOOP and the computers IP address. For example: Dim strComputer, intX FOR intX = 1 to 256 strComputer = "10.170.80." & intX set wmiLocator =...