I have several access forms that are almost identical to paper forms that are stored on our company server network. I would like for the user to open the access form, press a button and it prints the actual paper form located on the server network. They will then go offsite to complete the paper form, return to there desk and fill in the access form. FYI, I'm using a split database.
I've ran macros in excel that open other files by the following code:
Code:
Workbooks.Open ("\\myFilePath")
I was hoping access had the same capabilities, only instead of open, it would simply print.