STRPATH - Save export to excel on the form within the same database

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

Right now, I use "strpath" and the database save all files in H:\ FOLDER. I don't want that.

I want the excel files save where the ms access database in L:\Projects\report\ where the access database resides in L:\Projects\

Thanks
 
Hi,

Right now, I use "strpath" and the database save all files in H:\ FOLDER. I don't want that.

I want the excel files save where the ms access database in L:\Projects\report\ where the access database resides in L:\Projects\

Thanks
Click to expand...

Well... you can tell much better than we can what the local, programmed,
non-Access-builtin variable strpath contains.

It's a variable. It's apparently set (somewhere) to "H:\FOLDER". If you'ld
rather it be set to "L:\Projects" just do so.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:

http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also http://www.utteraccess.com
 
Back
Top