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

  • Users: sprog1977
  • Content: Threads
  • Order by date
  1. sprog1977

    Freeze panes properties

    I am trying to change the colour of the freeze panes option but am now wondering if it is at all possible. My boss has asked me this. I know it seems a weird request, but he has gone format mad!!!! I have checked all the logical places, checked what little I know in VB, to no avail. Can...
  2. sprog1977

    Export to Excel Table and Query names from Access

    I am trying to figure out how to get a list of all the table and query names of a given Access database and export or simply copy them into Excel. I looked at FAQ 700-4310 but I couldn't get it to work, plus I am unsure if this was my desired result. The reason for this thread is that I am...
  3. sprog1977

    Pivot table link to Access

    I have a pivot table in excel that is linked to an access query. The problem I have is when the Access file is renamed and new data is loaded, the pivot table still links to the old access file (as it should do). Is there a way in which I can re-point the pivot table to the new file without...
  4. sprog1977

    Custom Number

    How do I create an entry in the custom number (of format cells) category to turn a #NA to a blank (""). I can easily create this as a formula but I want it as a format. Please help, this is really frustrating me!

Part and Inventory Search

Back
Top