Search results

I have a database with numerous nutrient lab values per food item and zero to 20 tests per food item; some 600 food items I want to select the last 5 tests per food item which should be no problem using the "TOP " type statement. After I have the "TOP 5" record I would like to create another...

I am having some problems using a listbox with multi-select, so I was printing out the listcount with a debug.print function. I notice that the listbox.listcount is always greater by one(1) than the actual number of items (rows) and this has me puzzled. So if I have 11 items or rows in the...

Good evening from San Diego I have a multi select listbox that I rebuild as I index thru some products in another listbox. This listbox then gives me the ingredients I can use. Works well, but the ghost selections in the listbox stay hilighted even after the rebuild. I can select and...

How do I test for an Element name in an XML file so I can reset a loop or do something else. I am very new to XML and want to test for an element name of <sample> I see there are ways to create Elements but I have not ascertained how to test for the element name. Thanks JDB

Good afternoon from sunny Calif Using VBA I am reading data in from multiple XML files, and adding data to an indexed table. If I try to add a duplicate record I get a error like: "The changes you requested to the table were not successful because they would create duplicate values in the...