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 John Tel 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: wyvern621
  • Content: Threads
  • Order by date
  1. wyvern621

    Sorting By Color in Excel (2003)

    Murnin All...[bigcheeks] I was told to come here, so here I am... I have a spreadsheet with a few thousands rows on it and some of the rows are highlighted yellow. Is there a way to sort this spreadsheet by color? Thanks in advance... ChiTownDiva [ponytails]
  2. wyvern621

    Sort Excel (2003) Sheet By Color

    Happy Monday All...[bigcheeks] I have a spreadsheet with a few thousand rows, some of which are highlighted in color--the highlight goes completely across the row. Is there a way to sort a spreadsheet by color? Thanks in advance... ChiTownDiva [ponytails]
  3. wyvern621

    Text Box Updating Wrong Record

    Happy Monday All... I have a database that keeps up with how many customers are being "worked"--we like to call it a Scorecard. There is a main form ("Scorecard") and a subform ("Transaction Subform"). The main from has a drop down box with a list of customers. The subform has 4 fields that...
  4. wyvern621

    Importing A .Txt File Based on Dates

    Happy Friday All!!! I have some code that I've been using: Function Import() With Application.FileSearch .NewSearch .LookIn = "S:\PROJECTS\LINKAGE\OMSGROUP\Military\" .SearchSubFolders = True .filename = "*.txt" .MatchTextExactly = True...
  5. wyvern621

    Good Ole DSUM()

    Hi Everyone...I'm using Access 2003... I have a table called "Transaction": Hours (Number) Qtr (Text) Date (Date/Time) Analyst (Text) Customer (Text) trid (Autonumber) Comments (Memo) Activity (Text) I have a form called "frmTransactions": Analyst (Combo Box) Customer (Combo Box) Activity...
  6. wyvern621

    Dialog Box Error Message

    Afternoon All... I added a module to open a Dialog Box to import some files. Works great unless you hit cancel, then you get a runtime error 2501 "The RunCommand action was cancelled". Here's the code: Function GetPMSL() DoCmd.RunCommand acCmdImport End Function I want to add an...
  7. wyvern621

    Importing Text Data

    Hi All... I have a database that I'm idiot-proofing (if that's possible--it seems a better idiot is born daily)..anyway--got a form, press a command button and an imput form pops up asking for the location path of a file. The path is fed into some code that imports the file using an import...

Part and Inventory Search

Back
Top