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 Shaun E 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: mwca
  • Content: Threads
  • Order by date
  1. mwca

    Error message when closing form (due to chart?)

    Hi all I have a form which has various subforms embedded in it. I also have 3 charts in the form which are based on the data in 3 of the subforms. The problem is that each time I close the form, an error/info message comes up: "The object is locked so any changes you make will be discarded...
  2. mwca

    Excel not recognising formats of imported data

    Occasionally when I export data from some other applications to excel, they will not be recognised as, say, numbers unless I activate each cell. If I try Format/Cells and select Number, this will have no effect - it is almost as if excel does not realise there is anything in the cell. As a...
  3. mwca

    Status Bar indicator while macro running

    I have written a macro in Excel, and have turned off the screen updating. The problem is it takes a long time and ideally I would like to be able to show the progress in the status bar. I have it saying "Please wait..." but I would really like to show the indicator that fills up with...
  4. mwca

    Product Function in Access

    Is it possible to use the PRODUCT function from Excel in a totals query in Access? If I need to write a new function, how do I do this - I know how to write a function, but not if there are a variable number of parameters!

Part and Inventory Search

Back
Top