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!

  • Congratulations Mike Lewis 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: JBell
  • Order by date
  1. JBell

    Mask Edit Box

    I am using a mask edit box to allow the user to enter data into a form. There does not appear to be an alignment property to this control like on a text box. How can I right align the data input.
  2. JBell

    Slow ListView

    I have a listview in VB6 that is loading about 5000 items and it is taking 10-15 seconds. I load it from a SQL stored Proc. When I exec the sp from query analizer it returns almost instantly. Any thought on speed ? sortCMD = "EXEC LB_Inventory_V" Dim db As Connection Set db...
  3. JBell

    Primary key violations when changing Sort order

    thanks a lot this is a huge step. but I have only one other question I have to review over 32 databases with 900 tables each and each table has several indexes. I can write a cursor to read the tables and the index id's but to use this great piece of code you sent I need to retreive the field...
  4. JBell

    Primary key violations when changing Sort order

    We are setting up a new server with DOCI sort order and will be moving the data from a Binary server. The source server is SQL 7 then the destination is SQL 2000. Moving the data is not a major problem using BCP but there is the potential to have duplicate records when the case is ignored (i.e...
  5. JBell

    I have created a Microsoft DTS pack

    I have created a Microsoft DTS package in SQL 2000. Then saved it as a VB bas file as described in the on-line help for SQL server. When I open the VB bas file and try to execute it I am missing a reference but can not find what reference I should be adding to the project. The following is the...
  6. JBell

    Pause while form executes

    thanks
  7. JBell

    Pause while form executes

    I am totally blocked this morning. When executing code in a form I 'SHOW' another form and get user input then when I close the second form I want the orginal form to continue processing the rest of the code. When I "SHOW" the second window the code on the orginal form continues to...

Part and Inventory Search

Back
Top