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 biv343 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. Duffymk

    Identifying chart object sheets in Excel VBA

    Thank you - that worked perfectly! MD
  2. Duffymk

    Identifying chart object sheets in Excel VBA

    Hello - I am trying to write some code which moves through sheets and colours certain cells on each sheet. However, if the workbook contains a sheet which is only a graph, an error occurs. I would like a way to identify a sheet as being a chart object, so that then I can skip over it. Is...
  3. Duffymk

    Change Msgbox when field is required

    Hello - I have a field called 'Date' which has been set to Required in the table settings. I also have a data-entry form used to populate this table. If the user tries to move to the next record while leaving 'Date' null, the usual message box pops up telling them they must enter a value...
  4. Duffymk

    Macros Running Automatically

    Thank you for the suggestion - Problem was actually that I was adding lines/changing text to the cells that served as the combo box's list source. Not very smart of me!
  5. Duffymk

    Macros Running Automatically

    I have a macro attached to an combo box on an Excel worksheet. The macro calls two other macros which hide/unhide rows and update a graph: Private Sub ComboBox1_Change() Application.ScreenUpdating = False CompareGraph GraphColors Application.ScreenUpdating = True...
  6. Duffymk

    List of all objects in a database

    Is there a way to create a list of all tables, forms, queries, etc. in a database that could be easily imported into a Word or Excel table? Have tried Access Help to no avail. thanks!!

Part and Inventory Search

Back
Top