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 Chris 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. vincej

    Using buttons to run queries

    I am trying to run a query from a button created within "Forms." I cannot transfer the button from forms to my web page within Access for some reason. I tried creating a button within the web page and am unable to apply a query function to the button. Any idea how I can do this?
  2. vincej

    Specifying Full Column Range

    I'm just trying to single out a column in Excel
  3. vincej

    Specifying Full Column Range

    I am trying to write into vb code the following command but am unable to figure out how to phrase it in code: "Is in Column C" This will be inputted into an "If - Then" statement. Any suggestions will help. Thanks.[noevil]
  4. vincej

    running macro from a frozen pane

    I placed a button which contains a macro at the top of a spreadsheet. I need this butoon to always appear at the top, so the logical thing to do would to place it in a frozen pane. Once I did that, the macro would not run. Is there anyway to have a button stay located at the top of the...
  5. vincej

    macros assigned to toggle switches

    I am creating a worksheet that has over 1,000 toggle switches in it. I created one main macro that contains a specific macro for every single switch. Having such a long macro, one that covers thousands of switches, has caused the spreasheet to take literally 30 minutes to open. I need to find a...
  6. vincej

    Excel 97 Macros

    Here is the macro... Private Sub Tog_C11_Click() If Tog_C11.Value = True Then Range("C7:C11").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Range("C11").Select ActiveCell.FormulaR1C1 = Date Else...
  7. vincej

    Excel 97 Macros

    I created a macro using Excel 97 and am trying to get it to run within Excel 2000. Excel 2000 recognizes part of the macro command, but the other part it cannot load. The part of the macro not functioning properly is a date insert, which is 'Date' in 97. What is the correct command, if there is...

Part and Inventory Search

Back
Top