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

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

    Content Manager - what is a web part and how do I use it.

    Let me start by saying I am pretty computer savvy and consider my self pretty good with software. I am a Quality Engineer with enough IT skill to be dangerous :) I do not have the ability to do much with our SharePoint site but add content. I cannot change CSS (I can change the "theme" but...
  2. shellig

    ODBC Driver & Query error importing passwded Access Data in Excel 2002

    We have Office 2002. Hopefully we will get 2010 this year... I am trying to "Import External Data" into an Excel spreadsheet from a password protected Access database. I know the password and can get into the Access database directly using it. I do not want to go into the database as it is...
  3. shellig

    Junction tables and subforms confusion

    This has probably already been asked many different ways...but I am not sure so: I have the following tables: tblTask tblOwner tblCat tblSubCat with junction tables jnctTaskCat jnctTaskOwner jnctCatSubCat - this one is iffy whether we need to use the same subcategory for different categories...
  4. shellig

    Excel Chart - Data crosses X-axis - possible move labels to bottom?

    I often plot data as distance from target so it can be positive or negative. Is there a way to make the X-axis labels be at the bottom of the graph or another position so the graph is readable? I have done this the awkward way by removing the axis label, adding data labels using the XY Chart...
  5. shellig

    Pivot table - need % of total of a sum of two fields

    We have data in a spreadsheet that comes out: Date Reason Good Bad 9/17/06 Dropped 0 5 9/17/06 12 0 9/18/06 Kicked 0 8 9/18/06 Dropped 0 2 9/19/06 24 0 9/20/06 25 0 Obviously this is a snippet of total data. I use a pivot table to...
  6. shellig

    Excel Charting - series from column without sorting possible?

    OK, long subject but I was just asked to take our regular report and graph it differently without sorting. Our format is: Date Run Batch Value 9/1/2006 1 1 0.62229978 9/3/2006 2 1 0.477822602 9/3/2006 3 2 0.473598063 9/4/2006 4 1 0.82828949 9/5/2006 5 1 0.346625262 9/6/2006 6 2...
  7. shellig

    MS Excel Button to open Word doc inconsistent...

    To open a specific Word document from Excel (Office 2003), I have the following (obviously on a button): Private Sub CommandButton1_Click() On Error Resume Next Err.Clear Set wrd = GetObject(, "Word.Application") If Err.Number = 429 Then Err.Clear Set wrd =...
  8. shellig

    Consolidation and projects have same name!

    I have looked everywhere and tried everything I can think of. I took a project saved it, modified it and saved it with a different name. I changed the File>Properties>Title on the second project to a new name Then I wanted to consolidate the two so I opened a new window with the two in it and...
  9. shellig

    Lots of questions on forms, functionality

    Ok, to be humorous, I will say I made a database for lemonade. I have a table for a pitcher of lemonade, tblPitcher and one for the glasses from the pitcher tblGlasses and a junction table tlnkPitGls. I am using the junction table to ensure that no glasses can be chosen that have not been made...
  10. shellig

    Updating junction table with form/subform input?

    Ok, to be humorous, I will say I made a database for lemonade. I have a table tblPitcher and a one tblGlasses and a junction table tlnkPitGls. I had created a form for the information about creating the pitcher of lemonade (tblPitcher) with a subform to create the records for the junction table...

Part and Inventory Search

Back
Top