My question is: How can I bring a red flag image up visible on the form if the data entered from date to date if less than 6 weeks?
Unless you are dealing with large quantities of large images, I wouldn't advise storing the images separate from the database, just insert the image to the form and then in VBA you can reference it just with a name.
So instead of
Me.Image13.Picture = "c:\images\1.jpg"
you can just use
Me.Image13.Picture = "1"
without having to worry about your directory structure