Star Trek: First Contact

The following weapons were used in the film Star Trek: First Contact:

Calico M900

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 M900 submachine gun fitted with an M951-style foregrip, tactical flashlight, and EOTech red dot sight. When Data confronts Lily, he is greeted with a full auto burst, but is unharmed by the barrage. She then attempts to flee, but is overcome by radiation sickness due to a fuel leak from the damaged Phoenix and collapses, dropping the Calico.

Calico M900 with M951-style foregrip 9x19mm

Lily Sloane wielding her Calico M900

M1928 Thompson

While being persued 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 comandeers an M1928 Thompson from a guitar 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 holodecks' safeguards; making a holographic weapon just as lethal as the real thing.

I think it might be an M1921. The rate of fire seems higher than a 1928, which would mean it's a 1921, but i might be mistaken.

M1928 Thompson .45 ACP with 50-round drum magazine

Captain Picard unloads on a group of Borg drones with an M1928 Thompson