Food Log Time Filter - Building a Fitness Database in Microsoft Access, Part 48


	Back to Fitness 48 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Food Log Time Filter

Len Jolly

7 months ago

Every time I open FoodLogF the time order has started changing again (Something I've Done). I know Richard showed how to fix this way back, but I can't remember or find which lesson and have not been able to figure it myself so am asking for a little help please.

	Richard Rost @Reply 7 months ago
Did you implement the latest fixes with the seconds (time) increment?

	Len Jolly OP @Reply 7 months ago
Yes I have completed everything up to the end of 48. All working correctly. The filter time changing started a while back. I have been trying to sort it myself, but failed. Just to be clear the FoodDateTimeLabel swaps colour Red/Blue every time the form is opened. Loving this series!

	Darrin Harris @Reply 7 months ago
Hi Len is this what your looking for? Fitness 10 EXTENDED CUT MEMBERS ONLY Fix Food Sort Order, Add IsActive & Filter to Food List Private Sub Form_Load() Add these two lines... OrderBy = "" Filter = "" LogDate = Date UpdateFilter UpdateFoodComboRowSource TimerInterval = 100 End Sub

	Len Jolly OP @Reply 7 months ago
Hi Darrin, Yes that's exactly what I was looking for. Thanks for that, don't know who deleted that from my code, it couldn't possibly have been ME! Gremlins again!

	Richard Rost @Reply 7 months ago
Yeah, that was an addition after the fact. You gotta pay close attention because sometimes I come up with a bug fix from a previous lesson, and it's just a quick mention. So gotta watch, gotta follow closely. I'm sneaky sometimes. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Fitness 48.

Next Unseen

New Feature: Comment Live View