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

  1. watercooler

    Extracting substrings of varying size

    I have inherited an abundance of Excel files that had some sloppy data input. Here is an example: BBR 689.5 - 690.5 683.0 - 684.0 673.0 - 678.0 LUF1 653.0 - 654.5 LUF2 632.5 - 636.0 MUF1 621.5 - 623.0 MUF2 591.5 - 593.0 589.0 - 590.0 Column A contains the zone name and...
  2. watercooler

    Iff statement in a query

    I have a query that has a text field (Component) and a boolean field (bDozer). I want the query to filter according to a text box(txtType) on a seperate form (frmWork). So, within the query I put the following criteria under the bDozer column...
  3. watercooler

    Linking parent form to several children forms

    I was hoping to have my main parent form with a few command buttons on it. Each command button would open up a differnt child form linked to the main form via common unique ID. I am okay up to this point but now I want to be able to jump to the next record on my parent form and all of the...
  4. watercooler

    Y-axis value in a chart

    I have a simple query that I need to graph. The query looks like this: relMonth CountOfIssues RunTot2 Aug '03 12 12 Oct '03 1 13 Nov '03 7 19 Dec '03 2 21 Jan '04 2 23 Feb '04 11 34 Mar '04 5 39 Apr '04 31 70 May '04 3 73 Jun '04...
  5. watercooler

    Report hyperlinks to records

    I can't seem to do what I want and I kinda think that it is out of the scope of Access. However, it would be great if it could do it. So can an Access report contain a hyperlink to a certain record? I have a form which collects a lot of different engineering information and thus creates a...
  6. watercooler

    Disableing the mouse wheel

    Is there a way to disable the mouse wheel on forms. The users of my database are complaining because they keeping using the wheel to scroll down the form but instead it skips to the next or previous record.
  7. watercooler

    Setting memo size

    Is it possible to set a memo size? I am concerned that people will enter information into the memo field (typically less than 500 characters) and then go back and add a lot more at a later date. I have been warned that this can cause a lot of problems with the extra size overwritting the next...

Part and Inventory Search

Back
Top