Search results

Good call, I'll just use a global array. Thanks for the input!

Hi, I'm creating a form where forecasts can be entered for the months of various years. I'm only displaying the months one year at a time, and then you can move to the next month by clicking the next button. Twelve text boxes are used to show the forecast values for the months of the current...

sav is just a string variable that i used to store the absolute path. From your code, you're storing the absolute path in strsav so use that in the code at the bottom. Also, use WordApp instead of app: WordApp.ActiveDocument.SaveAs strsav & "RMA_" & rmanumber & "-" & company & ".doc"...

You can use the date function that is part of access and just grab the year out of it with something like: Right(date, 4)

I think the line of code you need to save as is: sav = "absolute path as a string" app.ActiveDocument.SaveAs sav & "RMA_" & WHATEVER IS IN THE RMANUMBER BOX & "-" & WHATEVER IS IN THE COMPANY BOX & ".doc". Hopefully that helps