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 Chriss Miller 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: Barneye
  • Order by date
  1. Barneye

    New to VB in Excel Need to pause Macro

    Awesome! Thanks!
  2. Barneye

    Combine 6 columns into 1 define the spacing

    Works Great! Only problem is how to I format the cells? After using the formula, I cannot format the Dollar columns as currency and the % column as percent.
  3. Barneye

    Combine 6 columns into 1 define the spacing

    I have an Excel workbook with 6 columns. I need to combine them into one cell but maintain a specific number of characters per column. Example: Name Orders Dollars MTD Ord MTD Doll % of goal Name 1 $1,000 10 $1,000,000 15% Name would need to be 8 characters no matter the...
  4. Barneye

    Looping VB Macro Need a STOP Button

    Great Thanks!
  5. Barneye

    New to VB in Excel Need to pause Macro

    Hello! I have a macro in Excel that I wrote. I need it pause to 10 seconds before it executes the next set of code. I am using Application.Wait Now + TimeValue("00:00:10") This works but seems to freeze the entire application. I have ODBC updates running in the background that need to run...
  6. Barneye

    Looping VB Macro Need a STOP Button

    I wrote a VB Macro to feed data from an Excel sheet to an ActiveX Control that runs an LED sign. This Macro is on a loop. I made a button to start it, can I make one to stop it?
  7. Barneye

    Need to elimate duplcate inventory

    I tried that and it eliminates any duplicates in each column. I need to eliminate duplicates only if the Part, Mfg, and Available all match. The following SQL Query works but I need to display all the columns. SELECT DISTINCT Inventory.Part, Inventory.Available, Inventory.Mfg FROM Inventory;
  8. Barneye

    Need to elimate duplcate inventory

    I get several lists with inventory from my suppliers. I import the excel files into an access database. Multiple suppliers list the same inventory from the same manufacturer. I need a query to eliminate the duplicates. I have 5 columns: Part, MFG, Available, Vendor, Cost, Datecode, Package...
  9. Barneye

    Gridview Change font color in cell depending on value

    Jim, Right on target! If you have time, a short explination of the code would be helpfull so I understand it for the future. Thanks!
  10. Barneye

    Gridview Change font color in cell depending on value

    Hello! I have a gridview with phone call statitics for my sales dept. The 6th column is "TotalCalls". I need to change the font color to red if the number of total calls is less than 40 or to green if it is 40 or higher. I am new to ASP.net, so the simplest explanation will be appreciated...
  11. Barneye

    DTS Excel Import- numeric only rows not importing

    Just a note.... I have actually used DTS to import from Excel to Excel. I needed to automatically combine 2 spreadsheets on a daily basis. It worked great!
  12. Barneye

    DTS Excel Import- numeric only rows not importing

    Sorry if I confused anyone, sometimes I do that! I have an Excel spresdsheet being imported into SQL using DTS. One column has part numbers. These part numbers are alpha numeric, but some are numeric only 6- 10 digits. During the import the numeric only part numbers are not imported and left as...
  13. Barneye

    DTS Excel Import- numeric only rows not importing

    Well having SQL output the Excel file as a csv file did not work. This is very frustrating. I guess I will have to convert the file to CSV by hand from excel and try again. If anybody has a better idea, please speak up!
  14. Barneye

    DTS Excel Import- numeric only rows not importing

    I have it set for nvarchar(255). I found some info that this is designed behavior for SQL. Microsoft suggests saving the file as a text file and then do the import. I guess I will add a step to the DTS to do the conversion to text and then do the import.
  15. Barneye

    DTS Excel Import- numeric only rows not importing

    I have tried many different "Data Types" with no luck. This is crazy! I hate Microsoft sometime! Ugh!
  16. Barneye

    DTS Excel Import- numeric only rows not importing

    Hello! I have a spreadsheet that imports via DTS. It has a part number column that may contain both numbers and letters. If the part number is numeric only and over 6-8 digits long the field is left blank. I know this has something to do with the way Microsoft "predicts" the data type by what...
  17. Barneye

    DTS import, Add 2 columns Date and Source

    Sorry I took so long getting back! I used the ActiveX script and it worked great! Thanks!
  18. Barneye

    DTS import, Add 2 columns Date and Source

    I have a inventory I import daily from a Pick system via ODBC. I need to add 2 columns, Date and Source. Date being the date the import occured. Source will always be a fixed value. Can I do this with a DTS package? I am running SQL 2000 SP4. I am new to SQL so the simpler the better! Thanks!
  19. Barneye

    Exchange default stationary

    Why would I want to spend more money on software if Exchange and Outlook can do what I need?
  20. Barneye

    Exchange default stationary

    We are using stationary to display a banner in the email, for informational purposes, new products, current specials and User information. Now I have to load the stationary on every machine each time we change it. I have over 50 users and it is quite a task. I saw the GPO ability to specify a...

Part and Inventory Search

Back
Top