Hello, I am fairly novice with Access in general ... but do have a decent amount of ability with VBA (mostly through Excel, though).
I'm working on a project that is producing a product catalog through an Access Report, and here is what I am stuck on:
There are advertising banners that they would like to display beneath the main group headers for each product category. We plan on storing these image banners into their own table, and connect to the correct one for the category through there.
The thing is, though, that not all categories will have a banner to display.
I'm assuming a simple check to see if an image exists for the current category would take care of whether the image shows or not ... and adjust the group header's height based on that also.
But which event should I put this code in for it to function correctly?
Wouldn't you want to put it on the Form_Open event?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks