Need help with Microsoft Access 07 & Reports
- by Moe
I'm finding it difficult to get MS reporting working to what I'd like to show.
What I'm trying to do is:
a) In my database store a URL file (HTTP external file), that is a .jpeg. I'd like to use that URL to call the image on the report sheet. I have tried to use 'Control source' on the data panel, but with no success. Any way I can get Dynamic Images to show up on each database.
Also, I have a couple of Relational Databases.
One Defines Values:
For Example:
DefinePets('petID','Name of Pet')
The other one links the Main DB with the 'DefinePets' database.
Eg:
connect('petID','mainID','extraFeild')
I'd like my report to Go into the "connect" Table, where the the currently viewed Record Value = mainID, then find petID and return Name of Pet.
There is a many to many link between definePets and the main Table. (Therefore connect is joining them up)
Or is that too much to ask from a simple package like Access?