Browse by Tags

Easy: How can I clear the contents of a ListBox in Access VBA?

This is kind of crude code, but what I am doing should be a no brainer. It is a no brainer in vb 6.0, but I can't do this in VBA for Access? The math is simple .ListCount - 1, but it doesn't work. All I need to do is clear the items in a list box. My application has an unbbound List Box control...

Posted to Access (Forum) by microsoft on 05-22-2010
Return listbox row index based on search criteria

Hi All, I can't seem to find a simple solution to this one. I have a list box with 5 columns that displays a small amount of customer information. Behind the form contiaining the listbox I have some code that returns a customer number (from other things the user can do not related to the listbox...

Posted to Access (Forum) by microsoft on 05-16-2010
Populate Listbox based on Wild card search

I have a combo box that lists a bunch of descriptions of products. Limit to list is set to No. So they can either pick something from the drop down or type something in. If they type something in (and it's not in the list), then I want to do the following: Make visible a listbox (that's hidden...

Posted to Access (Forum) by microsoft on 05-10-2010
Create Excel Macro (VBA) to select item from ListBox & assign to variable.

I am somewhat embarassed to be asking this question because it seems so simple, but here it goes. I am attempting to ad more enhancements to an Excel 2000 spreadsheet I have been using for several years to keep track of my monthly budget. Upon execution, I want the VBA macro to display a list of values...

Posted to Miscellaneous (Forum) by microsoft on 04-24-2010
VBA - Passing Array of dates to Combobox / Listbox

Hi there, I have a list of dates in a range on a worksheet that I use to populate a combobox. I have formatted the dates as "dd-mmm-yy". When it gets passed to the control, it loses the formatting I prefer and instead formats as "dd/mm/yyyy". I hope I am being stupid and there is...

Posted to Visual Interdev (Forum) by microsoft on 04-12-2010
How to sort a listbox whose "Row Source Type" is "Field List"

Hello Experts, I have a list box in my Form. The "Row Source Type" of this listbox is set to "Field List" and during run time the list box shows the headers/fields of a query. The query has many fields and hence I would like the values appearing in the listbox to appear in sorted...

Posted to Access (Forum) by microsoft on 03-30-2010
Change Color of Listbox row w/ VBA

I don't think this is possible: Can I change the color of a single row in a listbox or maybe even the text of a single column in a single row based on the value of a particular field?

Posted to Access (Forum) by microsoft on 03-21-2010
want to move items up and down in a listbox using vba

i am trying to use a list box in vba and i do not see the list property for the listbox. i want to move items up and down in the listbox and all the examples i see use the list property. i have a listbox called LISTBOX2 and when i try to use LISTBOX2.LIST i can't

Posted to Access (Forum) by microsoft on 03-07-2010
Deselect Entire Listbox

How do I deselect and entire listbox in VBA?

Posted to Access (Forum) by microsoft on 02-25-2010
Conditional Formatting in a ListBox (Access :: VBA)

Hello Experts, I am building a search form that will search for inactive/active records. What I am trying to do is have the inactive records appear in grey and the active records to appear blue. For each record, there is an attribute called blnActive that returns true/false values. I am capable of determining...

Posted to Access (Forum) by microsoft on 02-14-2010

Page 1 of 3 (30 items) 1 2 3 Next >