How do I get Dynamic Images to show up on each Microsoft Access 2007 database for reporting?
up vote
1
down vote
favorite
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?
microsoft-access
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
add a comment |
up vote
1
down vote
favorite
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?
microsoft-access
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
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?
microsoft-access
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
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?
microsoft-access
microsoft-access
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
edited Dec 2 '14 at 5:55
fixer1234
17.7k144581
17.7k144581
asked May 21 '10 at 14:06
user37900
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You need to do it with an unbound picture control with no Picture property defined (to create it you have to point it at a picture, but you can delete the filename after you insert it). Stephen Lebans provides code to load a picture file into an unbound picture control on his website.
Here are the steps to do it:
in the detail of your report, add a hidden control with the ControlSource of the field that stores your filename.
add the unbound picture control and delete the picture you pointed it out to to create it.
set the unbound picture control's properties appropriately for sizing (zoom is the usual setting, but if your pictures are all the same size, you can set it to Clip).
in the OnFormat event of the detail, you'd use the Lebans code to load the picture. I mocked up a test for this, and the line of code looks like this:
fLoadPicture Me!imgPicture, Me!PicturePath, False
"fLoadPicture" is the Lebans function, "imgPicture" is the unbound picture control, and "PicturePath" is the name of the field storing the file name of the picture to display. It should also be the name of the hidden textbox bound to that field.
answered May 21 '10 at 19:41
David W. Fenton
98446
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f143729%2fhow-do-i-get-dynamic-images-to-show-up-on-each-microsoft-access-2007-database-fo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You need to do it with an unbound picture control with no Picture property defined (to create it you have to point it at a picture, but you can delete the filename after you insert it). Stephen Lebans provides code to load a picture file into an unbound picture control on his website.
Here are the steps to do it:
in the detail of your report, add a hidden control with the ControlSource of the field that stores your filename.
add the unbound picture control and delete the picture you pointed it out to to create it.
set the unbound picture control's properties appropriately for sizing (zoom is the usual setting, but if your pictures are all the same size, you can set it to Clip).
in the OnFormat event of the detail, you'd use the Lebans code to load the picture. I mocked up a test for this, and the line of code looks like this:
fLoadPicture Me!imgPicture, Me!PicturePath, False
"fLoadPicture" is the Lebans function, "imgPicture" is the unbound picture control, and "PicturePath" is the name of the field storing the file name of the picture to display. It should also be the name of the hidden textbox bound to that field.
answered May 21 '10 at 19:41
David W. Fenton
98446
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
add a comment |
up vote
0
down vote
You need to do it with an unbound picture control with no Picture property defined (to create it you have to point it at a picture, but you can delete the filename after you insert it). Stephen Lebans provides code to load a picture file into an unbound picture control on his website.
Here are the steps to do it:
in the detail of your report, add a hidden control with the ControlSource of the field that stores your filename.
add the unbound picture control and delete the picture you pointed it out to to create it.
set the unbound picture control's properties appropriately for sizing (zoom is the usual setting, but if your pictures are all the same size, you can set it to Clip).
in the OnFormat event of the detail, you'd use the Lebans code to load the picture. I mocked up a test for this, and the line of code looks like this:
fLoadPicture Me!imgPicture, Me!PicturePath, False
"fLoadPicture" is the Lebans function, "imgPicture" is the unbound picture control, and "PicturePath" is the name of the field storing the file name of the picture to display. It should also be the name of the hidden textbox bound to that field.
answered May 21 '10 at 19:41
David W. Fenton
98446
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
add a comment |
up vote
0
down vote
up vote
0
down vote
You need to do it with an unbound picture control with no Picture property defined (to create it you have to point it at a picture, but you can delete the filename after you insert it). Stephen Lebans provides code to load a picture file into an unbound picture control on his website.
Here are the steps to do it:
in the detail of your report, add a hidden control with the ControlSource of the field that stores your filename.
add the unbound picture control and delete the picture you pointed it out to to create it.
set the unbound picture control's properties appropriately for sizing (zoom is the usual setting, but if your pictures are all the same size, you can set it to Clip).
in the OnFormat event of the detail, you'd use the Lebans code to load the picture. I mocked up a test for this, and the line of code looks like this:
fLoadPicture Me!imgPicture, Me!PicturePath, False
"fLoadPicture" is the Lebans function, "imgPicture" is the unbound picture control, and "PicturePath" is the name of the field storing the file name of the picture to display. It should also be the name of the hidden textbox bound to that field.
answered May 21 '10 at 19:41
David W. Fenton
98446
You need to do it with an unbound picture control with no Picture property defined (to create it you have to point it at a picture, but you can delete the filename after you insert it). Stephen Lebans provides code to load a picture file into an unbound picture control on his website.
Here are the steps to do it:
in the detail of your report, add a hidden control with the ControlSource of the field that stores your filename.
add the unbound picture control and delete the picture you pointed it out to to create it.
set the unbound picture control's properties appropriately for sizing (zoom is the usual setting, but if your pictures are all the same size, you can set it to Clip).
in the OnFormat event of the detail, you'd use the Lebans code to load the picture. I mocked up a test for this, and the line of code looks like this:
fLoadPicture Me!imgPicture, Me!PicturePath, False
"fLoadPicture" is the Lebans function, "imgPicture" is the unbound picture control, and "PicturePath" is the name of the field storing the file name of the picture to display. It should also be the name of the hidden textbox bound to that field.
answered May 21 '10 at 19:41
David W. Fenton
98446
edited May 22 '10 at 16:59
answered May 21 '10 at 19:41
David W. Fenton
98446
answered May 21 '10 at 19:41
David W. Fenton
98446
answered May 21 '10 at 19:41
David W. Fenton
98446
98446
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
add a comment |
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
OnFormate Event? I can't find anything like that in the Property sheet.
– user37900
May 22 '10 at 0:31
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Typo -- it's the OnFormat event of the Detail. Given that there's only 3 events on the Detail, that should have been fairly easy to figure out!
– David W. Fenton
May 22 '10 at 16:59
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
Also no onFormat. Online OnClick, OnDoubleClick, onMouseOver, onMouseOut.
– user37900
May 23 '10 at 5:03
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
When I view the EVENTS tab of the Detail of a report, I see three events, On Format, On Print and On Retreat. How are you looking at the events of the detail of your report?
– David W. Fenton
May 23 '10 at 21:15
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f143729%2fhow-do-i-get-dynamic-images-to-show-up-on-each-microsoft-access-2007-database-fo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
