Added Food Not Showing on the Form - Building a Fitness Database in Microsoft Access, Part 31


	Back to Fitness 31 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Added Food Not Showing on the Form

Edwin Sulsters

7 months ago

Sometimes, when I add food it's not showing up on the Daily Food Log, but when I check the FoodLogT it is added with the correct date.

I've added 2 food items on the 12th of september and in the FoodLodT the FoodDate is filled with the correct date, but the records are shown on another date (9th of september) in the Daily Food Log.
But when I previousely added items on the 8th of september, those items are visible in the Daily Food Log on that date.

I don't know why that is happening.

	Edwin Sulsters OP @Reply 7 months ago

	Edwin Sulsters OP @Reply 7 months ago

	Edwin Sulsters OP @Reply 7 months ago

	Darrin Harris @Reply 7 months ago
Hello Edwin Have you tried ISO dates, https://599cd.com/blog/display-article.asp?ID=2203&X

	Edwin Sulsters OP @Reply 7 months ago
I cannot change the default date settings on my computer. But still, it's strange that all food items I added on 8th of September are shown in the table and form, but not the food items of today.

	Richard Rost @Reply 7 months ago
Yeah, this is a similar issue that we discovered in the database when trying to edit food items from a different date. I'll address it in the next video.

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

Next Unseen

New Feature: Comment Live View