Relative path in database query connection string
Posted on 2009-12-18
I would really appreciate your help on this.
I have created a spreadsheet that works out all of our quotations. There are many different lines of items that could be included in each job. However, only a few are needed for each different quotation. I have created a sumaary page where all the data is chanelled and then on the same sheet used a Microsoft Query table on the elliminating the blank quanitity lines. What I understand is that it pulls the data from the query using a connection string. It all works like a dream. However, each time I need to do a new quotation, I save as the blank master to the new job name, but the query still pulls from the original file. After some googling, I figured out that it may be to do with Relative and absolute paths. Can someone show me how to let me 'save as' and change the connection string automatically to pull the data from the new file.