Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to get table value in a VBA variable ?

Discussion in 'Information Technology' started by Nikko, Jul 28, 2006.

  1. Nikko

    Nikko
    Expand Collapse
    Guest

    hello,

    i have a table VAR with a variable POS containing a numeric value
    (representing a cursor used to print forms beyond this value).

    How can i get the POS variable value in a VBA variant variable.
    what method do i have to use ?

    thank's
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Use DLookup()

    If you are not sure how to supply the arguments, see:
    Getting a value from a table: DLookup()
    at:
    http://allenbrowne.com/casu-07.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Nikko" <hum@free.fra> wrote in message
    news:4460461c$0$12444$626a54ce@news.free.fr...
    >
    > i have a table VAR with a variable POS containing a numeric value
    > (representing a cursor used to print forms beyond this value).
    >
    > How can i get the POS variable value in a VBA variant variable.
    > what method do i have to use ?
     
  4. Nikko

    Nikko
    Expand Collapse
    Guest

    Allen Browne a écrit :
    > Use DLookup()
    >
    > If you are not sure how to supply the arguments, see:
    > Getting a value from a table: DLookup()
    > at:
    > http://allenbrowne.com/casu-07.html
    >


    thank you Allen you're the Boss !

    Could you have a look at my question on m.p.access.
    if you could solve that case you would be a world Boss !
     

Share This Page