473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Yes/No checkbox to control an Image on report/form

Base:
Output of qryTest
Expand|Select|Wrap|Line Numbers
  1. Name   order# Food Drink Dessert
  2. Chuks   12    Yes   No     No
  3. Charm   13    No    Yes    Yes
On report, I want to display an image for all yes
Apr 5 '17 #1

✓ answered by NeoPa

That's a little awkward. You don't have an image, nor the address of an image, in your output data so you can't do it directly from your data.

Your easiest solution may be to have the address of the relevant picture(s) in you query output. That way you could have simple code in the OnFormat or OnPrint event that sets the image address to the value of your field. Otherwise your code would have to check the values of the [Food], [Drink] and [Dessert] fields and set the address accordingly.

4 1000
NeoPa
32,556 Expert Mod 16PB
There is no image in your data output so how do you plan to do that?

There are multiple columns that include Yes / No. Which are you referring to?
Apr 5 '17 #2
I have unbound images on the report.
I want to display the image of a dish when Food is "yes", glass for drink when its "yes"
Apr 5 '17 #3
NeoPa: Thank you for your response. I really appreciate it.

Addition: All images on report are invisible.
I basically want to display a corresponding image of food, drink, and dessert with a yes
Apr 5 '17 #4
NeoPa
32,556 Expert Mod 16PB
That's a little awkward. You don't have an image, nor the address of an image, in your output data so you can't do it directly from your data.

Your easiest solution may be to have the address of the relevant picture(s) in you query output. That way you could have simple code in the OnFormat or OnPrint event that sets the image address to the value of your field. Otherwise your code would have to check the values of the [Food], [Drink] and [Dessert] fields and set the address accordingly.
Apr 6 '17 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Francois | last post by:
Hi, I am trying to implement a custom control that extends the standard System.Web.UI.WebControls.CheckBox control. In the .Net class library reference it is said that CheckBox Implements...
10
by: Jennyfer J Barco | last post by:
Hello, I have a datagrid that brings some information from a query. I need to have a checkbox in each row so the user can select the rows he wants to reprint. Is it possible to have a checkbox...
1
by: vikram | last post by:
i am setting enable property of check box control using javascript, but when form is posted back , it does not reflect correct enable value.i.e. if i have set checkbox control enabled to false in...
1
by: JP | last post by:
I have images within a datalist control. Below is a checkbox control that contains the SQL ID of the image blob. When the page is post back I want to iterate though checkbox collection to get...
7
by: schaefty | last post by:
I recently posted this on the incorrect forum, and so I would like to ask the question here. I did get some good ideas on the other group, but I have not yet come up with a solution for me. I am...
2
by: Nhoung Ar | last post by:
Can anyone outhere advise me about a best practice of embedded the image into form or report. I have several forms and report which embedded images (logo) to the header. I observed that the...
2
by: Coll | last post by:
I have a form and a query. I would like to have some control on the form (check box probably), that when selected will limit the criteria for a field in a query. Here are the details.... When...
4
by: julietbrown | last post by:
In the detail section of a report I want to hide a checkbox control and it's label if the value of the control is false. I sort of expected the following to work. Private Sub...
41
bre1603
by: bre1603 | last post by:
I have a continuous form in Access 2007 called “Leadership Contact List.” It has a checkbox control for each record (bound to a field in the underlying table) that is used to email or create mailing...
19
by: antjonz | last post by:
Hello everyone!! I'm a newbie here so please no big words. :-) This is my first time building a database, but I feel like I am learning and making progress. Here is my problem: The database I'm...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.