Unable to Add Food or Meals to Daily Food Log - Building a Fitness Database in Microsoft Access, Part 47


	Back to Fitness 47 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Unable to Add Food or Meals to Daily Food Log

Michael Carter

6 months ago

This issue began a few versions back. Thinking it was something I had done incorrectly I downloaded #44 then as advised by Richard downloaded the latest #48. Issue is still there.

When I select a food or meal in FoodCombo no Calorie/Protein/Fat/Carb etc info appears. Then when the + is clicked all disappears, nothing added to the log. I'll add a screen snip.

	Michael Carter OP @Reply 6 months ago

	Michael Carter OP @Reply 6 months ago
I've checked FoodLogT and the items are being added when the + is clicked, but they are not showing in the FoodLog Form ???

	Darrin Harris @Reply 6 months ago
G'Day Michael This might help? FoodLogF Private Sub UpdateFilter() Filter = "FoodDateTime >= #" & Format(LogDate, "yyyy/mm/dd") & "# AND " & _ "FoodDateTime < #" & Format(LogDate + 1, "yyyy/mm/dd") & "#" FilterOn = True End Sub

	Darrin Harris @Reply 6 months ago
Update: Richard recommends this code instead. FoodLogF Private Sub UpdateFilter() Dim D As Date D = Me.LogDate Me.Filter = "FoodDateTime >= #" & Format$(D, "yyyy-mm-dd") & " 00:00:00# AND " & _ "FoodDateTime < #" & Format$(DateAdd("d", 1, D), "yyyy-mm-dd") & " 00:00:00#" Me.FilterOn = True End Sub Hope It helps

	Richard Rost @Reply 6 months ago
Both of those should work because they're both doing the same thing: getting rid of the problem of non-month/day dates.

	Michael Carter OP @Reply 6 months ago
Thanks Darrin and Richard, this worked. Much appreciated Mike

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

Next Unseen

New Feature: Comment Live View