I’m pretty sure 1998s “Almost Hero’s” is getting mixed up in this memory, so maybe it was from around the same time.
All I can remember: The time period was 1700/1800s. A writer (I think) travels somewhere and ends up learning to shoot guns and I believe enters a shooting competition? Does this sound familiar?