i know solved but have one last question in this regard
could the query you made, be altered also to look at dates missing based on today's date
as I'm a bit behind in work and haven't been updating it on time, but still says missing only up to 21/6/20 but today's the 3/7/20 and i haven't...
so have a front end which is just used to find and open a PDF file, bit quicker and better looking then searching through file upon file.
but have come upon a question that I'm sure can be answered by you smart lot, have searched here but didn't find anything on the subject.
but what i would...
but one last thing, if i put in the coverimage part of the table "NoImage", which is the name of the image in the gallery for when i have no image yet, for the rest of my records
all it shows is the NoImage even if i had an image, why ??
trying to get a picture to display, pictures will be held in the DB in a gallery. If no image present then just want it to display the text like shown in attached image and also one with no image
but when i do try search for one with no image, get the ol' invalid use of null error...
this is code to check for the score which has a null check
'---check for value of result
If Not IsNull(DLookup("Answers", "tblQuestionChoices", "Answers = Team1Guess1.value ")) Then
Team1Score.Value = DLookup("Score", "tblQuestionChoices", "Answers = Team1Guess1.value ")