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

    Hmmm......

    Saw a funny quote that made me think of MAI. "If you think writing in the proper tense is difficult now, just wait until time travel was possible." ~Unknown Sometimes you gotta leave your zone of safety. You have to manufacture Inspirado. You gotta get out of the apartment. You've got to run...
  2. IknowMe

    Sort list of list by multiple inner list values.

    Hopefully I explained my need well enough in the Thread title. If not I will elaborate further. I have a list of array that I am populating with a list of string. I need to sort the list of array (outer) by two items in the list of string (inner). The real data i'll be using has any number of...
  3. IknowMe

    userform listbox refresh when writing to sheet (I don't want it to)

    I have a listbox that is populated via rows on a worksheet. Currently it's set up to allow multiple selections. Once the user has made their selections I want to loop through the listbox and for each .selected = true I write something on the coresponding row of the worksheet. I have the...
  4. IknowMe

    Blank Rows in Dynamic Range after .delete of row

    Im using this definition to dynamically name my data range. (Credit Skip) =OFFSET ( INDIRECT("Sheet1!$A$1"), 1, 0, CountA(Sheet1!$A:$A)-1, CountA(Sheet1!$1:$1) ) I'm then using the name to populate a listbox via RowSource. The problem I am having is when I use the following code to...
  5. IknowMe

    Listbox RowSource Dynamic from Worksheet

    I have a form with a Listbox that is being populated by a worksheet range. The columns are static at 9 (A-I on the worksheet) but the rows need to adjust based on populated rows that will change. I can get it to work with a fixed range but can't come up with a dynamic solution despite much...
  6. IknowMe

    new mail notification for multiple inboxes, Outlook 2003

    I would like to recieve a desktop notification for new mail in a group inbox (not my default). I'm skeptical about the possability because the only thing my searching turns up are add-ons. Even the advanced E-mail Options dialog box states "Display a new mail desktop alert (default mailbox...
  7. IknowMe

    finding pointer in for each loop

    What I'd like to do but not sure how. for each line in myStringArrayList if instr(line, "Here I am") then 'console.writeline Line index number 'I need the index number of the current 'line in the ArrayList 'can't use the IndexOf function because 'lines...
  8. IknowMe

    Auto contrasting text against a changing background

    I am using the following Sub to add a percentage complete to the center of a progress bar. Private Sub UpdatePBar() Dim x As Single Dim y As Single Dim percentage As String = CType((ProgressBar1.Value / ProgressBar1.Maximum * 100), Integer).ToString & "%"...
  9. IknowMe

    Use my word game.

    The rules are you must form a sentence using the the word given by the previous post as well as providing a word for the next poster to use. We'll call it a vocabulary excersize. Lets start with the word 'crepuscular'. [thumbsup2] Wow, I'm having amnesia and deja vu at the same time...
  10. IknowMe

    Nacho Cheese

    Having an arguement with a co-worker about whether Nacho Cheese is a flavor of it's own or does any cheese used to create nachos. I'm not giving my opinion because I don't want to taint your's. Your thoughts? Okay, I'm admitadly weak and cannot resist. [thumbsup2] Wow, I'm having amnesia...
  11. IknowMe

    a or an

    I was watching a sitcom last night and one of the characters was looking to his brother to help him choose a career path. The brothers advice was to quickly finish the statement "I want to be a ......." revealing his true desire. The brother imeddiatly answers "Cop" and then blames his...
  12. IknowMe

    Jaws friendly textbox

    In our office we have some visually impaired folks and are trying to make our user forms Jaws friendly. Currently to allow a Jaws user to hear the corresponding label for a textbox we need to set it's tabstop property to true. If it is not tabable Jaws does not read it and a visually impaired...
  13. IknowMe

    Jaws friendly textbox

    In our office we have some visually impaired folks and are trying to make our user forms Jaws friendly. Currently to allow a Jaws user to hear the corresponding label for a textbox we need to set it's tabstop property to true. If it is not tabable Jaws does not read it and a visually impaired...
  14. IknowMe

    Design issues

    I am working on form to allow user selections for reports. This is my first attempt and I am strugling with design issues and would like some help from those of you with more experience so I can avoid any pitfalls obvious to you. I'm pretty comfortable with the setup below when my user...
  15. IknowMe

    Populate textbox with sum from query

    I have query pulling from several tables in my DB. I have a form which allows the user to select different criteria to perform a sum based on their selections. ex. say QueryAll returns the following Tool Usage Area SubArea UseDate Awidget 12 UT SLC...
  16. IknowMe

    Unique records to populate combobox

    Ok, Skip got me going on the query a query now I need some more help. Say my Query returns such Name Phone Address What I need to do is populate a combobox with all unique phone numbers in my query. I am using the selection to build another query to provide a report. I currently am...
  17. IknowMe

    Query a Query?

    Say I have a Query based on several tables in my database can I query the Query to generate the report? If I use the following to start a table query "SELECT * from Main ect ect what would the syntax be query a query named "Test" [thumbsup2] Wow, I'm having amnesia and deja vu at the...
  18. IknowMe

    Past, Present and Future

    In STC thread1229-1355981 some discussion has come up about Santa's quote below. What would be the best alteration to change this question to include everyone who has lived, is living or will live? I've tried playing with would, will, did ex. but can't seem to find any word that includes the...
  19. IknowMe

    Grambo

    I'm not even telling you guys how I did. Let's just say I'm trying to improve on my use of the dreaded comma slice. This website seems pretty lighthearted. Does anyone care to comment on the validity of it's teachings? I ask this question because I'd hate to take it to heart if the...
  20. IknowMe

    Introductions Thread

    CC, I'm seeing some new faces here and would like to get to know these folks a little better. I dug around for the "Introductions Please" Thread (or so I thought it was titled) without any luck. Perhaps you could use your Moderation powers to resurect it? [thumbsup2] Wow, I'm having...

Part and Inventory Search

Back
Top