Recent content by etoucan

Thnaks, PHV, that worked very well. I'd managed to bumble my own way to an answer using 4 separate queries and then using those in a fifth, but your method is much more elegant. Just shows there is more than one way to skin a cat. Thanks again.

I hope someone can help me with this. I have the following fields in a Project Management table: fldMilestoneID (Primary key) fldProjectID (foreign key to Projects table) fldForecastCompletionDate (Date/time) fldRAGStatusID (Red/Amber/Green/Completed/Not started - Foreign key to RAGStatus...

Thanks, ThatRickGuy, that link looks useful, and it's nice of you to lead me so gently in the right direction. So, the general principle is to connect to the URL, stream the data, parse it, use it?

OK, that's more than I knew 10 minutes ago but where to start? I'm looking for functionality similar to Excel's where I could connect to a URL from within my app and grab data for use in the app.

Does anyone know if it is possible to perform web queries from a VB.Net application and, if so, how?

Thanks, this looks useful. Let me clarify further. The prime objective here is for a user to be able to select the best team at the start of a season based on last season's form. That's why I originally thought that the easy way to go was simply to find the best theoretical teams and let the...

I don't yet know that SQLServer can't handle it by eliminating a large number of unrequired rows using the criteria I stipulated earlier. Do you know the maximum number of rows it can output?

The query does work to a point because the included views filter for position and same name in a position. Here are the numbers: Managers 22, Goalkeepers 45, Defenders 148, Midfield 158, Forwards 102. I guess the possible number of teams is 22 x 45 x 148 x 147 x 146 x 145 x 158 x 157 x 156 x 102...

Intro: I am writing an application that will help in the choice of players in a fantasy football league [those who hate footie, please keep reading 8¬) ]. Background: I have a db containing 3 tables - tblClubs with fldClubID & fldClubName (22 rows), tblPositions with fldPositionID & fldPosition...

Great! That worked just fine. Thanks also for the tip about DoEvents.

I have a loop going which adds records to a db table. I would like to be able to get out of the loop by hitting the ECS key. Can anybody tell me how to do this?

Genimuse's solution worked perfectly once I'd managed to sort out the correct database write permissions in various places. So, many thanks - I now have it working the way it should.

Ignore the undercore in the strSQLView variable.

Thanks for that Genimuse. I think this is the way to go and I can follow the logic. However, when I execute the following code <% 'Create the database connection Dim objConn, strSQLView Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open MM_Limestone2_STRING 'Create the SQL for...

Lothario - Many thanks for that. It looks interesting and I downloaded the example to test. But, the numbskulls prevailed and I couldn't get it to work. However, from what I could gather it appears to be code to get the popularity of links from a db. I need some simple code to add a record...