Make an attachment field (image) display in a report depending on another condition
I have a MS Access query that goes like this:
SELECT PREZENTA_ANGAJATI.NUME, DELEGATI.SEMNATURA.FileData,
PREZENTA_ANGAJATI.PREZENT
FROM DELEGATI
INNER JOIN PREZENTA_ANGAJATI ON DELEGATI.NUME = PREZENTA_ANGAJATI.NUME
DELEGATI.SEMNATURA.FileData is attachment field (contains saved signature scan) and PREZENTA_ANGAJATI.PREZENT is boolean (Y/N).
In the report based on this query, I want the signature image (DELEGATI.SEMNATURA.FileData) to be displayed only if PREZENT is True.
I haven't been able to:
1) put an IIF condition in the control source of the attachment field. It either displays the selected query field, or nothing else.
2) put some VBA code to toggle the .visible property of said attachment field. I keep getting errors.
Any help is appreciated, thanks in advance!
ms-access if-statement conditional report attachment-field
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
add a comment |
I have a MS Access query that goes like this:
SELECT PREZENTA_ANGAJATI.NUME, DELEGATI.SEMNATURA.FileData,
PREZENTA_ANGAJATI.PREZENT
FROM DELEGATI
INNER JOIN PREZENTA_ANGAJATI ON DELEGATI.NUME = PREZENTA_ANGAJATI.NUME
DELEGATI.SEMNATURA.FileData is attachment field (contains saved signature scan) and PREZENTA_ANGAJATI.PREZENT is boolean (Y/N).
In the report based on this query, I want the signature image (DELEGATI.SEMNATURA.FileData) to be displayed only if PREZENT is True.
I haven't been able to:
1) put an IIF condition in the control source of the attachment field. It either displays the selected query field, or nothing else.
2) put some VBA code to toggle the .visible property of said attachment field. I keep getting errors.
Any help is appreciated, thanks in advance!
ms-access if-statement conditional report attachment-field
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
What are the errors? Why even bother with code to set Visible property - if there is nothing retrieved per the IIf expression, then nothing shows anyway. However, I don't think a conditional expression in Image ControlSource property will work with an Attachment field. The image would have to be an external file. So, eliminate the IIf() and use code in Format event for setting Visible property. Be aware Format event only triggers for PrintPreview or direct to printer, not ReportView. Edit question to post code.
– June7
Nov 17 '18 at 22:08
add a comment |
I have a MS Access query that goes like this:
SELECT PREZENTA_ANGAJATI.NUME, DELEGATI.SEMNATURA.FileData,
PREZENTA_ANGAJATI.PREZENT
FROM DELEGATI
INNER JOIN PREZENTA_ANGAJATI ON DELEGATI.NUME = PREZENTA_ANGAJATI.NUME
DELEGATI.SEMNATURA.FileData is attachment field (contains saved signature scan) and PREZENTA_ANGAJATI.PREZENT is boolean (Y/N).
In the report based on this query, I want the signature image (DELEGATI.SEMNATURA.FileData) to be displayed only if PREZENT is True.
I haven't been able to:
1) put an IIF condition in the control source of the attachment field. It either displays the selected query field, or nothing else.
2) put some VBA code to toggle the .visible property of said attachment field. I keep getting errors.
Any help is appreciated, thanks in advance!
ms-access if-statement conditional report attachment-field
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
I have a MS Access query that goes like this:
SELECT PREZENTA_ANGAJATI.NUME, DELEGATI.SEMNATURA.FileData,
PREZENTA_ANGAJATI.PREZENT
FROM DELEGATI
INNER JOIN PREZENTA_ANGAJATI ON DELEGATI.NUME = PREZENTA_ANGAJATI.NUME
DELEGATI.SEMNATURA.FileData is attachment field (contains saved signature scan) and PREZENTA_ANGAJATI.PREZENT is boolean (Y/N).
In the report based on this query, I want the signature image (DELEGATI.SEMNATURA.FileData) to be displayed only if PREZENT is True.
I haven't been able to:
1) put an IIF condition in the control source of the attachment field. It either displays the selected query field, or nothing else.
2) put some VBA code to toggle the .visible property of said attachment field. I keep getting errors.
Any help is appreciated, thanks in advance!
ms-access if-statement conditional report attachment-field
ms-access if-statement conditional report attachment-field
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
edited Nov 17 '18 at 20:15
Barbaros Özhan
12.7k71532
12.7k71532
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
asked Nov 17 '18 at 20:13
Vlad PopescuVlad Popescu
62
62
What are the errors? Why even bother with code to set Visible property - if there is nothing retrieved per the IIf expression, then nothing shows anyway. However, I don't think a conditional expression in Image ControlSource property will work with an Attachment field. The image would have to be an external file. So, eliminate the IIf() and use code in Format event for setting Visible property. Be aware Format event only triggers for PrintPreview or direct to printer, not ReportView. Edit question to post code.
– June7
Nov 17 '18 at 22:08
add a comment |
What are the errors? Why even bother with code to set Visible property - if there is nothing retrieved per the IIf expression, then nothing shows anyway. However, I don't think a conditional expression in Image ControlSource property will work with an Attachment field. The image would have to be an external file. So, eliminate the IIf() and use code in Format event for setting Visible property. Be aware Format event only triggers for PrintPreview or direct to printer, not ReportView. Edit question to post code.
– June7
Nov 17 '18 at 22:08
What are the errors? Why even bother with code to set Visible property - if there is nothing retrieved per the IIf expression, then nothing shows anyway. However, I don't think a conditional expression in Image ControlSource property will work with an Attachment field. The image would have to be an external file. So, eliminate the IIf() and use code in Format event for setting Visible property. Be aware Format event only triggers for PrintPreview or direct to printer, not ReportView. Edit question to post code.
– June7
Nov 17 '18 at 22:08
What are the errors? Why even bother with code to set Visible property - if there is nothing retrieved per the IIf expression, then nothing shows anyway. However, I don't think a conditional expression in Image ControlSource property will work with an Attachment field. The image would have to be an external file. So, eliminate the IIf() and use code in Format event for setting Visible property. Be aware Format event only triggers for PrintPreview or direct to printer, not ReportView. Edit question to post code.
– June7
Nov 17 '18 at 22:08
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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',
autoActivateHeartbeat: false,
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%2fstackoverflow.com%2fquestions%2f53355148%2fmake-an-attachment-field-image-display-in-a-report-depending-on-another-condit%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53355148%2fmake-an-attachment-field-image-display-in-a-report-depending-on-another-condit%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
What are the errors? Why even bother with code to set Visible property - if there is nothing retrieved per the IIf expression, then nothing shows anyway. However, I don't think a conditional expression in Image ControlSource property will work with an Attachment field. The image would have to be an external file. So, eliminate the IIf() and use code in Format event for setting Visible property. Be aware Format event only triggers for PrintPreview or direct to printer, not ReportView. Edit question to post code.
– June7
Nov 17 '18 at 22:08