I'm sure there are easier ways, but... I have a combo box that has 5
possibilities (one of which is "sold"). When the combobox.value= Sold,
I want an image to appear, otherwise to not be visible. So, I thought
I do an If Then Else statement, but it doesn't seem to be working...
I'm not entirely too proficient at access programming (enough to be
dangerous), but I did:
*************** ***
If combobox.value = Sold then
image11.visible = true
else
image11.visible = false
End if
*************** ***
I've placed this OnLoad, OnCurrent, OnChange, AfterUpdate, etc.. But
it just won't work. It shows up on a new form just fine, but when I
change status it disappears and will not come back when status is
changed to sold in the combo box. What am I doing wrong?
Scott 1 1672
<sc*********@ja pan.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . I'm sure there are easier ways, but... I have a combo box that has 5 possibilities (one of which is "sold"). When the combobox.value= Sold, I want an image to appear, otherwise to not be visible. So, I thought I do an If Then Else statement, but it doesn't seem to be working... I'm not entirely too proficient at access programming (enough to be dangerous), but I did:
*************** *** If combobox.value = Sold then image11.visible = true else image11.visible = false End if *************** ***
I've placed this OnLoad, OnCurrent, OnChange, AfterUpdate, etc.. But it just won't work. It shows up on a new form just fine, but when I change status it disappears and will not come back when status is changed to sold in the combo box. What am I doing wrong?
Scott
How many columns are in your combo.
The statement is looking at column 0 ie the first one
That is often a number in which case your sold should be replaced with the
relevant number for sold
HTH
David B This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mark | r |
last post by:
anyone know a useful way of hiding image paths so images on my site cant be
directly linked to?
ive seen sites that use <img src="image.asp?/moo/fred/image01.jpg"> (where
the path starts from www.domain.com/secretfolder/moo/fred/image01.jpg) but
dont know how to set this up
BTW am on a shared host so dont have the use of base level administration if
it makes any difference?
anyone help me?
|
by: Tim Graichen |
last post by:
I currently have a form with several combo boxes. I have the background
properties and boarder properties of all form fields set as transparent.
Therefore, the only part of the controls that are visible, is just the drop
down arrow button on the combo boxes. Is there a way of hiding this button
until the field has focus?
Thank you for your help
Tim G
|
by: Richard |
last post by:
Hi,
I have a form based on a table. When I filter the form I want to run a
report based on the same table with the same filter as the form. No problem
until I want to filter a combo box where the text value is on a different
table. The me.filter is then a text instead of the id-number from the lookup
table. This causes the report to prompt for the parameter.
How do I get by this problem? Do I need to create a temporary table? I
rather...
|
by: Suresh |
last post by:
I have a combo and a datagrid in a page.
Combo box values are loaded on page_Load.
Datagrid is populated based on values selected in the combo (I am using
selectedIndexchange event)
I need to make a default value for the combo(first value available) and
populate the datagrid based on this value on page_Load itself.(Applicable to
many pages in my application)
I tried changing the selectedindex = 1. But the change event is not firing.
|
by: Tomek Toczyski |
last post by:
What is the best way to attach a caption to an image in xhtml?
I can attach a caption to a table by a "<caption>" tag
but I would like to do sth similar to an image.
How to do it in a natural way?
-tt.
| |
by: Coll |
last post by:
I have a field that I would like to display on a report only if the
value of another field matches a certain criteria. If it does match I
need the label & the field value to display (though I'm sure I can
create a text box joining the label & the field). If it does not
match, then I need the label/field (or text box) to be hidden. Any
suggestions? Also, there are multiple values (maybe 5) that would meet
the criteria (they are being...
|
by: banderson |
last post by:
Hello amazing vba writers,
I am trying to make a combo box return a value based on a combo box selection. I have tried a number of the codes posted here and am still having problems. I think it is because I am trying to return a value from a table that only links with the form through an intermediate table. I am hoping to avoid a subform for this one box if at all possible, because of space limitations. Any guidance would be greatly...
|
by: benchpolo |
last post by:
I have a group of 20 images (.jpg) formats that I want to incorporate with my new access database that will dynamically display the image on the form based on the value that I select from the combo-drop down box or list box. I have no problem creating the combo-drop down box or list box, but I need assistance on the image part.
I can create this method in VB 6, but have not tried in MSAccess 2000 or 2003. Thanks.
|
by: troy_lee |
last post by:
How do I suppress the properties box on database startup?
Thanks.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |