OH!!! That made me feel really smart! :)
So now I have a command button that will update document to "my organized folder of folders"! You mentioned earlier that I could write a code that will print the contents of a folder? Please elaborate...my smarts are showing once again!
OK! I have edited to only update a single document...it works!!!
Private Sub Command3_Click()
FileCopy "S:\Terminal Operations\Sterlinton JSAsNew Folder\EQUIP - GENERAL MAINTENANCE\JSA 107 SPRAY WEEDS.xls", "S:\Jessica's Database\Linked Files\Job Plan-YARD\JSA 107 SPRAY WEEDS.xls"
End...
I figured out that I had "Sub" too many times. Now I'm getting a Complie Error: Expected End Sub, and it highlights the Private Sub Command2_Click()...here's the code I'm using...
Private Sub Command2_Click()
Sub Copy_Files()
FileCopy "S:\2008 MSDS (Updated)\0010 - Ammonia, Anhydrous.pdf"...
I created a sample command button with the code you provided and tweeked it with my document paths. I am getting an "Ambiguous Name Dectected: Copy_Files" error?!?!?!?!?
It's crazy...they have 3 different internet based drives (I guess is what you call them) and the shared drive for the facility that I actually work in. All of these drives contain documents that I need. I've been telling them that one is good...not 4 different storage drives. They can't...
Our problem is that for every job plan (almost 200 job plans) there is at least 10 sets of print outs and they are stored in multiple locations. As of now it takes great effort to locate the correct documentation and ensure all are printed. My boss's computer skills aren't great and he wanted to...
Fneily...Thanks so much for helping. I created a report with the hyperlink fields and created a command button to open report and print...I get a copy of the report when utilizing the button. I need the actual web pages and word document to print...and no I don't know much about putting code...
I am not familiar with coding but it's time I become...I have a list of hyperlinks (an orientation package, that consists of web pages and MS documents located on a share drive) and would like a button on my form (Access 2003) that will not display these links but just print them out. I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.