Member Avatar for roby22

I have a couple text boxes A,B, C
A is time in
B is time out
And C calculates the difference. Those 3 boxes are datetime boxes
This form has a report binding navigator that manages the interaction to the database.

The problem is that the values entered and calculated in those boxes don’t save to the access database.
I have a couple other textboxes on the form…. But they safe normally.
What am I missing?

thanks

  • 2 Contributors
  • 2 Replies
  • 92 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by roby22
Member Avatar for jbisono

Can you show the insert statement specially the way you are passing those values.

Regards

Member Avatar for roby22

I cutomized the datetimepicker
TIMEINTextBox.Format = DateTimePickerFormat.Custom
TIMEINTextBox.CustomFormat = "HH:mm"

And now when i put values into the field, it wont save to the database.


To write to the database I have the generic

Me.Validate()
Me.REPORTBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.REPORT)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.