Changing background image by date range

[Monterey_Manzer]

Hello All,



I have been taking a few stabs at this but I can't seem to find a clear example of what I'm trying to do. Here is what I want to achieve and my thought process thus far:

I am generating a form that coworkers will use to track information on customers. The urgency of this information, and the protocols necessary, are dependent on a date that is associated with the customer. Now of course I have included a combo box on the form that will display the date but I'm trying to make this process more idiot proof. I am trying to define "seasons" by ranges of dates (e.g. something like Spring = #1/1/2013# - #6/1/2013#). I then want to change the background image on the form depending on the date displayed with each record. Is this ridiculous or something that would be fairly feasible?

Cheers,
Monterey_Manzer

[pbaldy]

It wouldn't work on a continuous or datasheet form, but it single view it shouldn't be too difficult. You'd test the date and set the Picture property of the form in the current event. You could have the date ranges and paths to images in a table, or hard-code it as you see fit.

[Monterey_Manzer]

I can understand the logic behind setting the dates and associating them with the image file, I'm just not certain of how to do it. Could you suggest any tutorials?

[pbaldy]

Can't think of one offhand. If you use a table, you'd open a recordset or use DLookup to find the path appropriate to the date on the record, then use that to set the picture:

Me.Picture = "YourPathHere"

[Monterey_Manzer]

I'll give it a shot and let you know how it comes out.