Welcome to SPN

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

Sign Up Now!

Module function in DefaultValue property of table

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

  1. Domac

    Domac
    Expand Collapse
    Guest

    Access 97 doesn't list available modules & functions when I try to build
    DefaultValue expresion.

    Goal is to retreive value returned by String function (GetComputerName API
    function ) and set value every time new row is appended.


    Why I can't set Function name as DefaultValue property (Now() lfunction
    works fine)..


    Thanks a lot!
    Domagoj
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You cannot use user-defined functions for default values in tables. You can,
    however, use them in forms.

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


    "Domac" <dd.cc@cc.cc> wrote in message
    news:e97nzZiiGHA.4776@TK2MSFTNGP05.phx.gbl...
    > Access 97 doesn't list available modules & functions when I try to build
    > DefaultValue expresion.
    >
    > Goal is to retreive value returned by String function (GetComputerName API
    > function ) and set value every time new row is appended.
    >
    >
    > Why I can't set Function name as DefaultValue property (Now() lfunction
    > works fine)..
    >
    >
    > Thanks a lot!
    > Domagoj
    >
    >
     
  4. Domac

    Domac
    Expand Collapse
    Guest

    Thank you!





    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:e4f9LtiiGHA.4204@TK2MSFTNGP02.phx.gbl...
    > You cannot use user-defined functions for default values in tables. You
    > can,
    > however, use them in forms.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Domac" <dd.cc@cc.cc> wrote in message
    > news:e97nzZiiGHA.4776@TK2MSFTNGP05.phx.gbl...
    >> Access 97 doesn't list available modules & functions when I try to build
    >> DefaultValue expresion.
    >>
    >> Goal is to retreive value returned by String function (GetComputerName
    >> API
    >> function ) and set value every time new row is appended.
    >>
    >>
    >> Why I can't set Function name as DefaultValue property (Now() lfunction
    >> works fine)..
    >>
    >>
    >> Thanks a lot!
    >> Domagoj
    >>
    >>

    >
    >
     

Share This Page