Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: elmorro
  • Content: Threads
  • Order by date
  1. elmorro

    I need help formating the Time from a smalldatetime field.

    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 :-)
  2. elmorro

    SQL Connection generates error.

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

    I need help with this Date stored procedure.

    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 =...
  4. elmorro

    Need help displaying Tooltip in Listview.

    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 :-)
  5. elmorro

    I need help with Time arithmatic in VB6

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

    Need help with a ListView issue.

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

    Troubles with Excel in VB6.

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

    I have a Bootup Script Question.

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

    I need help deleting a file from within VB6.

    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 :-)
  10. elmorro

    MsgBox Question.

    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 ;-)
  11. elmorro

    USB Questions

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

    I need help with a Stored Procedure.

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

    What is the procedure to restore from a backup.

    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 :-)
  14. elmorro

    Problems login in to Outlook.

    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 :-)
  15. elmorro

    Need help with a query.

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

    Error when using XP_SENDMAIL

    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 :-)
  17. elmorro

    Need help opening a .ai Mac file on a PC

    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 :-)
  18. elmorro

    I need assistance resending emails

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

    I need assistance with the Toolbar control.

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

    Help! I need assistance with an administrative VBscript.

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

Part and Inventory Search

Back
Top