Welcome to SPN

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

Sign Up Now!

Retrieve Server Time In A form

Discussion in 'Information Technology' started by attie, Nov 16, 2005.

  1. attie

    attie
    Expand Collapse
    Guest

    Hi

    I would like to find out if there is a way to retrieve either the time of
    the system a database with linked tables is saved on or just the time of a
    server with an ip address i.e. 10.0.0.1 on an access form, if there is, How ?

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    USA Obama: U.S. Will Help New Governments Retrieve Assets Breaking News May 19, 2011
    Sikh News New Orleans: Sikh holy book retrieved (Rediff.com) Breaking News Sep 11, 2005
    Sikh News Sikh holy book retrieved from under water (Hindustan Times) Breaking News Sep 10, 2005
    Sikh News N.J. student banned in torching of kid's turban (The Charlotte Observer) Breaking News May 14, 2008
    Sikh News India: Time to Deliver Justice for Atrocities in Punjab (UN Observer) Breaking News Oct 19, 2007

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    As long as you're using NT or better, see whether
    http://www.mvps.org/access/api/api0039.htm at "The Access Web" helps. It
    won't work with an IP, mind you, but you should be able to retrieve the
    server name using the code Randy Birch has at
    http://vbnet.mvps.org/code/network/hostnamefromip.htm

    (Obligatory warning: Randy's site is aimed at VB programmers. Because of the
    differences between the controls available for forms in VB vs. Access, some
    of his examples cannot simply be copied in Access. A brief look at this
    example, though, looks as though it shouldn't cause any problems)

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


    "attie" <attie@discussions.microsoft.com> wrote in message
    news:ECDD1A8F-8F68-44A8-AB09-A83B1A9F17C2@microsoft.com...
    > Hi
    >
    > I would like to find out if there is a way to retrieve either the time of
    > the system a database with linked tables is saved on or just the time of a
    > server with an ip address i.e. 10.0.0.1 on an access form, if there is,

    How ?
    >
    > Thanks
     
  4. attie

    attie
    Expand Collapse
    Guest

    I did look at that article prior to posting here, i have used the code, duno
    if i'm being stupid, but I cannot get any response from it, i.e. displaying
    the time in a textbox.

    "Douglas J Steele" wrote:

    > As long as you're using NT or better, see whether
    > http://www.mvps.org/access/api/api0039.htm at "The Access Web" helps. It
    > won't work with an IP, mind you, but you should be able to retrieve the
    > server name using the code Randy Birch has at
    > http://vbnet.mvps.org/code/network/hostnamefromip.htm
    >
    > (Obligatory warning: Randy's site is aimed at VB programmers. Because of the
    > differences between the controls available for forms in VB vs. Access, some
    > of his examples cannot simply be copied in Access. A brief look at this
    > example, though, looks as though it shouldn't cause any problems)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "attie" <attie@discussions.microsoft.com> wrote in message
    > news:ECDD1A8F-8F68-44A8-AB09-A83B1A9F17C2@microsoft.com...
    > > Hi
    > >
    > > I would like to find out if there is a way to retrieve either the time of
    > > the system a database with linked tables is saved on or just the time of a
    > > server with an ip address i.e. 10.0.0.1 on an access form, if there is,

    > How ?
    > >
    > > Thanks

    >
    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    How are you trying to use the code?

    I just ran it in the Immediate window with no problems (WinXP, SP1, Access
    97):

    ?fGetServerTime("\\wynoas31")
    11/15/2005 03:17:27 PM


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


    "attie" <attie@discussions.microsoft.com> wrote in message
    news:A2BD651A-B64F-4F85-AC3D-19976721B6A6@microsoft.com...
    > I did look at that article prior to posting here, i have used the code,

    duno
    > if i'm being stupid, but I cannot get any response from it, i.e.

    displaying
    > the time in a textbox.
    >
    > "Douglas J Steele" wrote:
    >
    > > As long as you're using NT or better, see whether
    > > http://www.mvps.org/access/api/api0039.htm at "The Access Web" helps. It
    > > won't work with an IP, mind you, but you should be able to retrieve the
    > > server name using the code Randy Birch has at
    > > http://vbnet.mvps.org/code/network/hostnamefromip.htm
    > >
    > > (Obligatory warning: Randy's site is aimed at VB programmers. Because of

    the
    > > differences between the controls available for forms in VB vs. Access,

    some
    > > of his examples cannot simply be copied in Access. A brief look at this
    > > example, though, looks as though it shouldn't cause any problems)
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "attie" <attie@discussions.microsoft.com> wrote in message
    > > news:ECDD1A8F-8F68-44A8-AB09-A83B1A9F17C2@microsoft.com...
    > > > Hi
    > > >
    > > > I would like to find out if there is a way to retrieve either the time

    of
    > > > the system a database with linked tables is saved on or just the time

    of a
    > > > server with an ip address i.e. 10.0.0.1 on an access form, if there

    is,
    > > How ?
    > > >
    > > > Thanks

    > >
    > >
    > >
     

Share This Page