Results 1 to 10 of 10
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating a Chart Using SetData Method (2003)

    I'd like to use this example to connect to the Northwind sample database and chart the Query "Category Sales for 1995".
    One of the requirements to carry it out is to "copy the remainder of the text in this topic into an HTML page".
    How do you open an(I suppose blank) HTML page in order to do that and how do you launch the code?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating a Chart Using SetData Method (2003)

    Simply open Notepad, paste the code, then save the file with extension .htm (or save it with extension .txt, then change it to .htm in Explorer)

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a Chart Using SetData Method (2003)

    Thank you Hans <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Creating a Chart Using SetData Method (2003)

    Actually saving htm (or html) files from notepad has an extra complication.

    By default Notepad puts Text Document (*.txt) in the Save As Type box in the save dialog. If you leave this there, Notepad adds .txt on the end, even if you put .htm (or .html) in yourself. You then to need to rename the file later.

    It is easier to change the Save As Type box to "All Files", then Notepad will leave the extension you put in as the real extension.
    Regards
    John



  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Creating a Chart Using SetData Method (2003)

    I tried this with my copy of Northwind and initially got an error because it no longer has in it a query Category Sales for 1995

    I needed to change that to 1997, but then it worked.
    Regards
    John



  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a Chart Using SetData Method (2003)

    Hi John, mine worked flawlessly with Access 2003 first time around.

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a Chart Using SetData Method (2003)

    I know next to nothing about HTML but shouldn't any HTML file start with <html> ?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating a Chart Using SetData Method (2003)

    This one only contains script, not regular HTML.

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Creating a Chart Using SetData Method (2003)

    When I tested this I wrapped it with the standard bit of html wrapping:
    <html>
    <head>
    </head>
    <body>

    code goes here

    </body>
    </html>

    and it worked, but then I took all this out and it still worked.

    Sometimes html is very forgiving about leaving things out, but sometimes a tiny error causes catastrophic errors.

    But in neither case did it worked when I looked at it with firefox.
    Regards
    John



  10. #10
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating a Chart Using SetData Method (2003)

    One more reason to stick with I.E. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •