p2p.wrox.com Forums - Access http://p2p.wrox.com Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. en Sat, 21 Nov 2009 12:08:42 GMT vBulletin 60 http://p2p.wrox.com/images/misc/rss.jpg p2p.wrox.com Forums - Access http://p2p.wrox.com Difference Between Times Past Midnight http://p2p.wrox.com/access/76991-difference-between-times-past-midnight.html Wed, 11 Nov 2009 10:50:19 GMT Hello!

On an Access form I have three controls:

StartTime
EndTime
TimeDuration

They are all 'Short Time' formatted and are bound to fields in the same table. The user inputs manually the StartTime and EndTime using the input mask 00:00;0;_ (all he needs to register is hour and time in 24-hour format. And the TimeDuration should automatically be calculated and populated.

I have successfuly been able to calculate the time difference, but not if the end time goes past midnight.

For example: if the StartTime is 21:00 and the end time is 01:00, then the result should give 04:00, but it gives 20h00. I already understand why it does that (Access assumes they are both times on the same date) - but I can't figure out how to overcome this.

I have tried many options, from a basic formula ([StartTime] - [EndTime]), which gives the result above) and also tried using DateDiff which always gives me 00:00 as the result, regardless. I am certain I am using the function correctly: DateDiff("n", [StartTime],[EndTime]).

Any clues on how I can overcome this using any function or code?

Appreciate any help! Thank you! ]]> Access Odeh Naber http://p2p.wrox.com/access/76991-difference-between-times-past-midnight.html Combo box interior color changes http://p2p.wrox.com/access/76954-combo-box-interior-color-changes.html Sun, 08 Nov 2009 18:11:38 GMT When I open my forms the combo boxes have a white interior and black text, which is the default and the way I'd like them to stay. But when I browse records, the combo box becomes transparent, by which I mean the interior color of the combo box becomes the same as the color of the form. I hate this behavior because this does not happen on the other controls and makes for an odd appearance. Is there a way to prevent this? ]]> Access williamlove http://p2p.wrox.com/access/76954-combo-box-interior-color-changes.html