Yes you can purchase a DVD of the Memoirs volumes 1-42 the first 100 years of the Association for £45 for non members and £25 for members. Volumes 44 and 45 do not appear to be available at this time.
You can get the Haley’s Comet Memoir on the publication page if you go to the journal archive it’s between journal volume 101 issue 5 and 6