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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tanenterp

  1. tanenterp

    Hyperlink in Excel to a Chart?

    Hi, I tried that (It created a new worksheet called "Chart1", but unfortunately, I can't use a hyperlink to reference that sheet.
  2. tanenterp

    Hyperlink in Excel to a Chart?

    Hello, I am trying to create a Hyperlink within Excel (XP/2002)to a Chart. I am unable to do so. I can not refer to the chart object. Even when I use the Function Builder, it will not let me select the chart. The closest I can do is to imbed a chart on a worksheet, and create a Hyperlink to...
  3. tanenterp

    Cutting and Pasting from Access XP to Excel XP

    I finally found this issue addressed by Microsoft Knowledge Base: http://support.microsoft.com/default.aspx?scid=kb;en-us;328933 They say that they hope to fix it in the next service pack, but they can provide a non-guaranteed workaround in the meantime. I think I'll wait for the next service...
  4. tanenterp

    Cutting and Pasting from Access XP to Excel XP

    One other related question; is there a way to change the default "Paste Special" option, so that it does not default to "Micosoft Excel 8.0 format"? I would prefer to not have to remember to pick "Paste Special" each time, but have the "regular" pasting...
  5. tanenterp

    Cutting and Pasting from Access XP to Excel XP

    Thanks LNBruno! It's very strange, when I do "paste special", the default is "Microsoft Excel 8.0 format". This format pastes the values as text. If I try ANY of the other special formats (Biff5, HTML, Unicode Text, Text, or CSV), it pastes the values correctly. Has anyone...
  6. tanenterp

    Cutting and Pasting from Access XP to Excel XP

    Hello, When I cut and paste query or table results from Access XP (2002 SP2) into Excel 2002, my values are being copied over as text. This is even when the values are clearly number or currency fields in Access. I did not have this problem is any previous version of Access or Excel. I know...
  7. tanenterp

    page break subreport

    Hello, I just wanted to thank CosmoKramer for the response. I had exactly the same issue, and Cosmo had the perfect answer! Thanks again!!!

Part and Inventory Search

Back
Top