Star Trek: First Contact
The following weapons were used in the film Star Trek: First Contact:
When Captain Jean-Luc Picard (Patrick Stewart) and Lt. Commander Data (Brent Spiner) are inspecting the Phoenix spaceship after the Borg attack on the launch site, they come under fire by Lily Sloane (Alfre Woodard) who is wielding a Calico M951 submachine gun fitted with a weaponlight and EOTech red dot sight. When he confronts Lily, Data is greeted with a full auto burst, but is unharmed by the barrage.
While being pursued by the Borg aboard the Enterprise, Picard and Lily duck into a holodeck running a 1930's-era mystery simulation. Picard promptly confronts several gangsters in the simulation and commandeers an M1928 Thompson from a violin case, using it to mow down the Borg drones chasing them, continuing to fire until he empties the weapon's 50-round drum magazine and then goes to beat them with the butt of the weapon but is stopped by Lily. When Lily asks how a supposedly holographic gun was able to kill living creatures, Picard explains that he had deactivated the holodeck safeguards.