Recent content by merc_slk

The blnFilledIn has to be stored with the local record. I use this value to validate and check the records in the recordset. If one requirement is missing in the records, the person can only save a draft version (temp table) else he can save it on server. Maybe there's an easier method but can't...

In my dbase I need to compare 4 pairs of values. If all pairs comply to my criteria in the update query the value "blnFilledIn" must be true else false. Let's say everything is according criteria, "blnFilledIn" is set true. Meanwhile a value changes and 1 or more pairs do not comply the...

All nice but there is still a difference between changing the bordercolor of an object (textbox,combobox,listbox, etc) @ JPaulo on a form, quite easy :D:D than changing the bordercolor of it's form self. The only thing you can change is me.borderstyle @ DCrake or a global setting for all your...

Hello, Depending on what the user can do I want to change the bordercolor of my form. RED - New Record YELLOW/ORANGE - Record being edited Green - Record on page completed, ready to save. Many thanks, Jef

Hello, I changed the first idea to calculate the night flight hours. Used a lot of if's and added some more code (maybe too much) It works now. I'll test it out the comming weeks, to get rid of bugs.If any interest, I can post your changed example drake. :-) Many thanks, never had the idea...

Hello, I'm strugling calculating the hours flown between Sunset and Sunrise(day +1), so called nightflight hours per leg. An example says more : StartTime EndTime Sunset Sunrise Total Flight Total NightFlight Legs 15:50......17:45.....18:15...05:23...01:55........00:00...............1...