jasriel
06-20-2008, 09:03 AM
Okay, basically the title says what I am wanting to try and do. I have 4 pictures, these will change on a daily basis, and I want to have them somehow integrated into a report for printing. The problem is I don't know how to link these pictures into a database.
Let me clarify a little. I know how to simply embed the pictures into the database, but that is not what I need. The pictures as I said will change daily and I do not want to have to go in and change the pictures manually all the time.
So any ideas?
ajetrumpet
06-20-2008, 11:20 PM
you don't have to change them manually. Just put image controls on your objects, size them appropriately, and then use Date functions within access to change the source path of the image you want to display in those controls, based on the day (if you are doing it that way, of course).
All you would probably have to do would be something like this:on form open
select case weekday(date())
case is = 1
me.imageControl.picture = "C:\SomePicturePath"
case is = 2
me.imageControl.picture = "C:\AnotherPicture"
etc...
end select
me.requeryThat's all you need to do to change an image on an object based on a date, if that is indeed what you're looking for.
jasriel
06-22-2008, 03:22 AM
Actually I don't need this to be updated by "date", what I need is for this to update every time the form is opened is all.
ajetrumpet
06-22-2008, 09:19 AM
well...then you'll have to store the paths somewhere I guess, won't you? how about an array? stick them in there, use a counter as a variable, and everytime the form is open, change the counter number. when the counter reaches the maximum, loop it back to the first number in the sequence that represents the appropriate picture path.