ACCESS FEED: Re: [MS_AccessPros] Adding Image to combo dropdown

Kamis, 21 April 2016

Re: [MS_AccessPros] Adding Image to combo dropdown

Bill,

After playing with it for awhile, I am coming to terms that I will probably have to do without. No budget for third-party components. May MS will include something like it in upcoming release of Access.

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: "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, April 20, 2016 3:11 PM
Subject: 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

http://www.viescas.com/

(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

http://www.viescas.com/

(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