Recent content by bjallen2880

Has anyone been sucessful in doing this?

Where would one put that specific code? I'm trying to do a similar thing, but for the page tab name on a form. I have tried the code under form_onconnect and that doesn't work. Thanks!

Is there a way for this to work with continuous forms (multiple records displayed at a time) and display each picture? I took the DB here and converted the form from a single form to a continuous form and both records displayed the same picture (but each record was linked to a different pic)...

My problem is I'm displaying multiple records at one time. But the way the code is, whichever record has focus, that picture is displayed on all records (screenshot attached). Is it possible to load pictures for each record all at once, and have them display correctly? I copied the code from...

I made some more changes. Of course now the relationships work! It works a lot better when there is little or no data in there! :) Attached is a new screenshot of the relationships.

I tried deleting and re-creating the relationship between tbl_Market and tbl_RetailStore for the fld_Market but it would not create any form of relationship. It kept coming up indeterminate (perhaps because of the data in there?). I may try again with it but create a dummy field (minus data...

I just realized that this is totally dumb and redundant. Here's what it looks like.

I just thought of something. This way will not work (or maybe it will, let me know). I need to be able to sort everything by the Retail Store's Market (each Market is comprised of around 10-15 stores). So the end resulting report can be something like - Market Philadelphia North is supported...

Thanks again for everyone's suggestions. I have implemented them and now this is how it looks.

Before I attempt to make changes based on all of your awesome suggestions, I just wanted to say thanks for your help! These suggestions will really get this DB going! To answer some questions though - a "Market" in this database is a division of the retail stores into a group, say Central PA...

I did some digging on google, and came across making a "middle man" to help with the many to many data. Attached is a new screen shot of the new relationships. But now I can't make one-to-many in between tbl_ITA and tbl_RetailStore. It find the relationship as indeterminate. The way the...

Here's a screenshot of my current layout of relationships. I appreciate any help! Thanks!

Greetings all, I've been ripping out my hair trying to figure out the best way to house this data in Access yet still be able to display it afterwards in a sensible fashion. Here's the scenario: Making a database to show the IT Guy, the Locations he Supports (which are sub-divided into...