Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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

    > >
    > >
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page