Access Database Always Save DateTime to 12:00 ?

[loyal]

hi

 

I have an app that saves the Exit Time and Return Time

 

that saves these times in Access Database

 

I found that it always saves time with 12:00

 

I Tried with SQL and It works

 

is there any solution for that ?

 

bye

[Volte]

We'll need some code.

[loyal]

Hi

 

I am only catching the Change that happen to dataset

 

Me.BindingContext(Ds1, "TD").EndCurrentEdit()
       Dim DSC As TimeDataBase.DS = New TimeDataBase.DS
       DSC = CType(Ds1.GetChanges, TimeDataBase.DS)
       'Check to see if any changes have been made.
       If (Not (DSC) Is Nothing) Then
           Try
               'There are changes that need to be made, so attempt to update the datasource by
               'calling the update method and passing the dataset and any parameters.
               DA.Update(DSC)
               Ds1.Merge(DSC)
               Ds1.AcceptChanges()
           Catch eUpdate As System.Exception
           End Try
       End If
   End Sub

 

Note: when I made a form from Access Data base it works

 

please see an example here

timedatabase.zip

[loyal]

please somebody help !!!

[loyal]

hello VolteFace please what did you get ?

[jfackler]

Loyal,

Sounds like you're in dire straits. A few questions to start a dialog:

1. What is the Date/Time Format in Access. (Try General Date/Time)

2. I'm afraid I'm at a loss regarding what a TimeDataBase.DS type actually is. I've not seen it on this forum at all in fact.

 

My guess is, your types are mismatched in Access and in your code. The Access is probably truncating the value and leaving you with that 12:00 Am. It is the default time when only a date is provided.

 

Jon

[loyal]

thanks for your replied jfackler

 

I stuck with it a week ago

 

:(