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. Advertisements

  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. Advertisements

  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. Advertisements

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. Betsy

    RTFBOX98.CHM

    Betsy, Dec 4, 2003, in forum: Access General
    Replies:
    2
    Views:
    243
    Betsy
    Dec 5, 2003
  2. JIM.H.

    call chm help file

    JIM.H., Sep 9, 2004, in forum: Access General
    Replies:
    1
    Views:
    112
    Douglas J. Steele
    Sep 9, 2004
  3. Tony

    Access & Help Files (.chm)

    Tony, Sep 30, 2004, in forum: Access General
    Replies:
    0
    Views:
    131
  4. Max Moor

    Why can't I open my .chm help from my toolbar?

    Max Moor, May 27, 2005, in forum: Access General
    Replies:
    0
    Views:
    96
    Max Moor
    May 27, 2005
  5. R the D

    cmctl198.chm

    R the D, Jan 25, 2006, in forum: Access General
    Replies:
    0
    Views:
    347
    R the D
    Jan 25, 2006
  6. Freegrue

    Help me!! About .CHM

    Freegrue, Mar 11, 2006, in forum: Access General
    Replies:
    1
    Views:
    107
    Arvin Meyer [MVP]
    Mar 12, 2006
  7. Mark

    Access XP and CHM Help Files

    Mark, Jun 30, 2007, in forum: Access General
    Replies:
    2
    Views:
    140
  8. Gordon Jones

    chm Help File on Acc2002 under Vista

    Gordon Jones, Mar 23, 2009, in forum: Access General
    Replies:
    2
    Views:
    111
    Gordon Jones
    Mar 23, 2009
Loading...