var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with, Modifying Output Directory/ Path in Access
I am new to vb and just trying to build a database for work. The db works ok however I am trying to modify the output location since its on a network.
The current db report output locations is...
"C:\Documents and Settings\a124567z\Desktop\ContactInfo.rtf"
with "a124567z" being the user's login or network ID.
Is there a way I can use vb to make the db report output location to automatically change according to the login id without doing it manually on all the computers?
For example if user "b444555y"
tries to export the data, the location shoyuld now be...
"C:\Documents and Settings\b444555y\Desktop\ContactInfo.rtf".
I hope I explained myself well.
Thank you in advance
I see no one has replied yet.
In case this helps, can you do an API call for the user name and then incorporate it in making the path name? Code for the API call should be easily found.
This is virtually trivial in VBA - I'm familiar with Excel for VBA. I'm reading this VB section to learn a little, but I've never done any VB so can't help any more.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert