Rabu, 20 April 2016

Re: [MS_AccessPros] Adding Image to combo dropdown

 

Art


The only thing I don't like about ActiveX controls is that you have to make sure all users have it registered on their computers and it has to be the same version number. That means more maintenance on your part.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :

John,

After digging around some more, what are your feelings on ActiveX controls. I found a ImageCombobox but are the use of  ActiveX worth it?

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, April 19, 2016 7:49 AM
Subject: Re: [MS_AccessPros] Adding Image to combo dropdown

 
Art-

You could consider a continuous subform that appears only when the user clicks a command button.  You would need code to show/hide the control and code to handle updating the underlying field if the combo is bound when the user picks a row.  More trouble than it's worth.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 19, 2016, at 2:36 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

Would there be a way to fake it? Maybe using a combination of controls? OK, I will go back to dreaming... 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."   







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com 
Sent: Tuesday, April 19, 2016 3:26 AM
Subject: Re: [MS_AccessPros] Adding Image to combo dropdown

Art-

You can't.  The columns in a combo box are always Text data type.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 18, 2016, at 11:43 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:




How can I add an image to a combo list.? I have a combo box called cboDocStatus and the items I want the list to contain are 

an image of a flag and the status.

So for instance

Flag Color           Status Text
green flag           Approved
yellow flag          Draft
red flag              Rejected

Any ideas?

Art Lorenzini
Sioux Falls, SD
                











 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar