Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
re-add to an array from listbox
Hi all, I've been able to get an array populated with a listbox in a form. But what I want to do is to keep adding to this array once the user has added more items to the listbox and clicked the "Add to Array" button again. I can't figure out how to store/remember the 1st set of items so that...- tchristo
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
select countries appearing in at least 3 of 5 tables
Hi folks, I would like to select countries that appear in at least 3 of 5 tables. These tables show the bottom 25 countries for different statistics (e.g. %poverty,%malnourished, etc.). The purpose is to find "the worst of the worst" countries. I can easily make a query that shows only those...- tchristo
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
inner join query problem
Hello all, I've been trying to get hectares (ha) used in a calculation but first it has to be created from a square meters(shape_area) field. I've tried two options: 1.create ha calculation in initial select statement 2.create ha calculation within an inner join Neither options work. The first...- tchristo
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
slow connection speed on FIRST try
Hello all, I've been reading all the info on the site about increasing the speed for displaying query results. Testing speeds AFTER the first time accessing a DB for all 3 connection types (listed below) seem about the same for speed. Also, the recordset.open versus recordset.execute seem about...- tchristo
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
for each rec: replace val in 1 field w/ val from other field
Hi, I have a field with the same string value.... (a hyperlink actually, with this as the string: "<a href= ../asp/query_cover.asp?WSD_size=6&WSD_code=020503 target=_blank><b>Run Query/View Chart</b></a>") ....copied to each record. For each record, I need to replace the part...- tchristo
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
