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 TouchToneTommy 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: CrystalStart
  • Content: Threads
  • Order by date
  1. CrystalStart

    SAVED-by-a-Spell check

    I am looking for a job...again. So I was just sending my resume and I had made a mistake by writing 'REUSME' instead of Resume. I was so surprised when spell chack pointed it out for me. Isn't it amazing I was asking to 'Re-use me'... what would they think of me??? :-D
  2. CrystalStart

    Browser reload

    I have ActiveX failure. Was suggested I reload browser. Is it safe? Thanks
  3. CrystalStart

    Browser reload

    I have ActiveX failure. Was suggested I reload browser. Is it safe? Thanks
  4. CrystalStart

    Good To See You Whatsyourname

    ...If you do happen to run into someone whom you previously met and can't remember their name, you have two options: Look delighted to see them, lock eyes and extend a warm "Good to see you again," and then find out their name from a friend or guest list later. " What is this type of...
  5. CrystalStart

    Column Flipping Range changed

    I am using this code to flip data from starting at column 2 to the end of data. It works a treat. But recently I need to start not only at column 2 but also at Range A5 of column 2. Do you see how to alter this code to make it work? lColumnCount = Sheets(i).[B:B].CurrentRegion.Columns.Count...
  6. CrystalStart

    Select all rows with data

    Every time my Macro is running it populated WKbook with different amount of data. Column headers are staying the same - rows this is what I need to count. How do I select all data? Is this even possible? Thanks so much
  7. CrystalStart

    Transpose

    Hi, I need to use following to flip up data: Selection.Copy Range("A6").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True End Sub So key word here is Transpose. Client wants to see data flipped up. So far I have Excel...
  8. CrystalStart

    Syntax again

    Please help me one more time with syntax select * from call_master where call_master.dertis in (SELECT dertis FROM mss_dertis WHERE LTRIM(RTRIM(prodcode)) in ('GFLI') AND LTRIM(RTRIM(compcode)) in ('6180') AND runreport = 'Y') and date = '2005-02-12'...
  9. CrystalStart

    Disturbing

    Something is bothering me about this "syntax" but I can't say what exactly: "I'm living so far beyond my income that we may almost be said to be living apart"
  10. CrystalStart

    Syntax error

    I am getting error "incorrect syntax near 'then' count(*) as Field1, sum(case when (seqstep <> '0001' AND seqstep IS NOT NULL then ani end)) as Field2, --Total calls, Please, help
  11. CrystalStart

    Save SQL Results to Excel

    I am executong statement in SQL and i need to save results to an Excel file with headers as nice looking as possible. How do I do that? Thanks
  12. CrystalStart

    Mascarade

    Ia "Mascara" word sub product of "Mascarade"? "When my eyes not mascaraded I look like 12 years old" - is this is a valid saying?
  13. CrystalStart

    Word Association Game

    I stole an idea but trying to improve it. Idea was SUMMER - HOT - BEACH - TOPLESS etc I am posting word and asking to post your assosiation with it (noun, verb, adj...whatever comes to your mind) The word is SINCERE and every poster should look up previous word and post assosiation with this...
  14. CrystalStart

    Stop in to fill up

    This morning I passed a church on my way to work and I was amazed, tell me if rightfully though, sign said: Running low on faith? Stop in to fill it up! I am still shocked!
  15. CrystalStart

    Adopt Report for another Client

    Hi! I have Report that had been created for one client and now I need to simply plug in different Client's info. Can I do that or suppose to re-create for each client? Thanks
  16. CrystalStart

    Don't know - don't bother

    I've already mentioned finding teachers forum and posting a question about "non-fictional reading for a 5th grader" I was so amazed yesterday to find an answer of this sort: "I am sorry I can not help you because I am teaching older grades" - I found that very funny for few reasons and decided...
  17. CrystalStart

    Convert int into datetime

    Please help asap! Have a field integer that is capturing calls in seconds Need to convert into format hh:mm:ss HOW? Thanks Tried convert(datetime,fieldname) gives: 1900-02-03 00:00:00
  18. CrystalStart

    Excel's Intelligency that drives me nuts

    I type CNA into Excel and it turns it to a CAN. How can I stop it? What is the name of the function?
  19. CrystalStart

    Freeze First Row

    Hi! How to freeze panel so only First row will remain frozen? Thanks
  20. CrystalStart

    Word to use instead of devil's advocate

    Is there a word to use instead of "devil's advocate"?

Part and Inventory Search

Back
Top