jeterr40.chm

Discussion in 'Access General' started by news, Jan 22, 2004.

  1. news

    news Guest

    Hi I want to open a database via visual basic 5
    and SELECT DISTINCT field 'surname, FROM 'table' ORDER by 'surname'
    and then close this database and put the results in a text file for further
    manipulation
    In plain language -- via vb, I want to extract from a table in ms access all
    surnames sorted in alphabettical order with no repeats
    I know I have to go to project /references or components and tick ole db but
    I can`t find this
    Error is cannot find file jeterr40.chm
    help please and thanks in advance




    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
     
    news, Jan 22, 2004
    #1
    1. Advertising

  2. I can't help you with the specific error you're having, but let's work on
    your SQL statement.

    The word field isn't required in the statement, and you don't want the
    quotes around the names.

    SELECT DISTINCT surname FROM table ORDER BY surname

    If your field or table names have embedded blanks (seldom a good idea!), you
    need to surround the name with []:

    SELECT DISTINCT surname, [telephone number] FROM [customer table] ORDER BY
    surname


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (No private e-mails, please)



    "news" <> wrote in message
    news:sLEPb.18184$9.net...
    > Hi I want to open a database via visual basic 5
    > and SELECT DISTINCT field 'surname, FROM 'table' ORDER by 'surname'
    > and then close this database and put the results in a text file for

    further
    > manipulation
    > In plain language -- via vb, I want to extract from a table in ms access

    all
    > surnames sorted in alphabettical order with no repeats
    > I know I have to go to project /references or components and tick ole db

    but
    > I can`t find this
    > Error is cannot find file jeterr40.chm
    > help please and thanks in advance
    >
    >
    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
    >
    >
     
    Douglas J. Steele, Jan 22, 2004
    #2
    1. Advertising

  3. news

    Alex Ivanov Guest

    It is a not very helpful help file with error descriptions. It should be on
    your Office CD.
    Why do you need it at first place?
    If you are talking about an MDB database, you may set references to either
    ADO or DAO libraries and use Object Browser and IntelliSense to discover
    their properties and methods. If you run into a problem, you may post here a
    piece of code that does not work
    and somebody will gladly help you fix the problem.

    Alex.

    "news" <> wrote in message
    news:sLEPb.18184$9.net...
    > Hi I want to open a database via visual basic 5
    > and SELECT DISTINCT field 'surname, FROM 'table' ORDER by 'surname'
    > and then close this database and put the results in a text file for

    further
    > manipulation
    > In plain language -- via vb, I want to extract from a table in ms access

    all
    > surnames sorted in alphabettical order with no repeats
    > I know I have to go to project /references or components and tick ole db

    but
    > I can`t find this
    > Error is cannot find file jeterr40.chm
    > help please and thanks in advance
    >
    >
    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
    >
    >
     
    Alex Ivanov, Feb 20, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. msnews.microsoft.com

    Calling a .chm file when a button is clicked - (Urgent)

    msnews.microsoft.com, May 28, 2004, in forum: Visio Archive
    Replies:
    3
    Views:
    123
    msnews.microsoft.com
    May 31, 2004
  2. abc
    Replies:
    1
    Views:
    67
    JackD
    Jul 5, 2005
  3. dennist685

    Wasn't there a free book in the form of chm?

    dennist685, Jan 2, 2005, in forum: Onenote Newsgroup
    Replies:
    4
    Views:
    75
  4. Betsy

    RTFBOX98.CHM

    Betsy, Dec 4, 2003, in forum: Access General
    Replies:
    2
    Views:
    144
    Betsy
    Dec 5, 2003
  5. David Liebtag

    Can't find either msowcvba.chm or owcvba10.chm

    David Liebtag, Jan 18, 2008, in forum: Developer Web Components
    Replies:
    3
    Views:
    106
    David Liebtag
    Feb 5, 2008
Loading...

Share This Page