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

  1. JH0401

    Query - Get Latest Revision from Several Tables

    Thanks again.
  2. JH0401

    Query - Get Latest Revision from Several Tables

    ...so we only need to specify the aliases to match the column name for the first subselect and as long as each subsequent subselect has the same number of columns it will use the same alias?
  3. JH0401

    Query - Get Latest Revision from Several Tables

    How does this work: "select t.ProjectID , t.RevisionDescription , t.RevisionDate" when untion contains fields named something else in some tables? ex: from ( select ProjectID , RevisionDescription , RevisionDate from Table1 union...
  4. JH0401

    Query - Get Latest Revision from Several Tables

    Thank you... I'll give it a go and apply credit later!
  5. JH0401

    Query - Get Latest Revision from Several Tables

    What if the column names are slightly different in the tables? Table1 (ProjectID, RevisionName, RevDate) Table2 (ProjectID, RevisionName, RevDate) Table3 (ProjectID, RevisionDesc, RevisionDate) Table4 (ProjectID, RevisionDesc, RevisionDate) Table5 (ProjectID, RevisionDesc, RevisionDate)...
  6. JH0401

    Query - Get Latest Revision from Several Tables

    I only want to return the last revision across all tables...
  7. JH0401

    Query - Get Latest Revision from Several Tables

    EX: 6 tables (Table1, Table2 ... Table6) All tables have the following columns: ProjectID [String] RevisionDescription [String] RevisionDate [DateTime] I want to use the RevisionDate column to determine the last revision and the ProjectID column to determine the project relationship. Need...
  8. JH0401

    SolidWorks & VB - Automating Drawings - Dreaded Dimensions!!!

    Hello... Has anyone had any luck automating drawings in Solidworks? --- NOTE: I'm using VB6 & Solidworks 2005 --- I've automated some dwgs but had to go back to template drawings because most of the parts we use have such a huge range in size - the dimensions get really out of place...
  9. JH0401

    Raid Arry Not Recognized - WIN2K - RAIDCOREx4

    Hi, I have a system with a RAIDCORE controller & (4) Hitachi 400GB sata drives setup in a RAID5 array with (1) hot spare. I can see the array in the BIOS but when when booted the operating system - WINDOWS 2000 SP4 does not recognize the array. I've looked in disk management but nothing is...
  10. JH0401

    Solidworks & VB

    I have two questions: 1) How can I edit custom properties in SW2004 through a VB APP? 2) How can I open a new part, create a sketch & then extrude a sheet metal flange through VB? Just a small example... say one 5 inch line starting at origin 0,0,0 & ending at 0,0,5 & then a flange extruded...
  11. JH0401

    How do shell a program & keep that program active until terminated?

    CajunCenturion & LazyMe, Thank you for your helpful replies. If I need to create a batch file to open a process, how can I get the handle for the new window opened by the batch? Should this be a new thread? Thanks, Josh
  12. JH0401

    How do shell a program & keep that program active until terminated?

    Hi, I need to shell a program & then keep that program as the active program until it is terminated by the user. Any help appreciated. Thanks, Josh
  13. JH0401

    WINDOWS API - SUGGESTIONS ON A BOOK

    I WOULD LIKE TO LEARN MORE ABOUT THE WINDOWS API. COULD I GET SOME SUGGESTIONS FOR A GOOD BOOK/LEARNING TOOL. THANKS, JOSH
  14. JH0401

    MAPI Control (Can you edit text style - color,height,etc.)?

    petermeachem What is the third part control you use to accomplish this?
  15. JH0401

    MAPI Control (Can you edit text style - color,height,etc.)?

    Hi everyone, I have a question regarding the MAPI control in VB. Can you edit the text style - color, height, etc. in the emails you send? Any input or examples will be greatly appreciated. Thanks in advance, Josh

Part and Inventory Search

Back
Top