Post reply

Managing Hours and Minutes

  • January 26, 2008 at 2:36 pm

    #186062

    Hi

    I have Access front end database on a SQL server back end.

    I have come up with a problem, that i just cannot resolve despite the help pages or searching.

    i wish to log the time of day of an event on a record, in 24 hour format (00:00), simple as that.

    Then to link the table thru to the front end database and then be able to edit / update the time in the front end on a form.

    currently i have the record in sql server table as a smalldatetime datatype and short time format. all is well.

    when i go to access and link the table to the front end, no matter what i do the record shows as 01/01/1900 23:59:00 format rendering it uneditable.

    Would somebody be so kind as to point in the right direction or advise me where i am going wrong.

    Many Thanks

    Russ

  • January 27, 2008 at 2:38 am

    #772175

    Cross post. Replies to the following thread please - Managing Hours and minutes (MS Access)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply