Search results

Thanks, I will search for ranking type operations. JDB

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...

Spike, I read it, but it did not register. Actually, I probably read it 5 times but it did not register. Thanks for pointing this out. JDB

Q- Do you have the Column Heads property of the list box set to yes. Ans - I surely do and that is surely the reason. I changed the Column Heads property to "No", and now there is a listcount of 11 instead of 12. Thanks very much JDB

Thanks very much for your sage advice. I have spent a good deal of time already on that help page. it is repeated below: The question remains; my query has 11 rows, my listcount is 12 my query has 2 rows, my listcount is 3 and so forth. JDB from a microsoft site "You can use the...

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...

Found the solution by using listbox.rowsource = Something ------------- Dim _ ctlSource As Control Set ctlSource = Forms.frm_select_UPC_LoinGrade!lstBox_ColdStorage ctlSource.RowSource = "" ctlSource.RowSourceType =...

Ans to the question; in one listbox (A)I have a list of distinct UPC of a product(SingleSelection) that requires a certain tonnage of ingredients. When I select(Hi-lite) that UPC a query is run that shows a list of ingredients by source that can be used in that product in Listbox B. There may...

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...

This was more of an XML question. The Import XML does not work on the XML file I receive so just had to write some VBA code to load into a table. Simple enough using objects on the msxml6 dll. Just trying to figure out all of the methods and properties. Seems to be 3 or 4 ways to do things...

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

Thanks - Did some reading and did some and this seems to work Sub Something On Error Resume Next ...code to read XML and call an Update subroutine ..... End sub

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...