Where is your form? You need to post a form to the page to all this to work:
without a form this can not work. You need a form tag, submit button. Then move your ASP to the top of the page and check of the form collection has a value e.g:
if trim(Request.Form("CompanyID_Merge")) <> "" then
SQL = "SELECT Projects.CompanyID, Projects.ProjectID, Projects.ProjectName, Projects.SeasonYear, Seasons.Season, " & _
"Activities.ActivityName WHERE Projects.CompanyID = " & CheckNumber(CompanyID_Merge) & ";"
SET RS = Conn.Execute(SQL)
response.write "There is nothing in the form collection to process...."