replace text in a string with a command button

[Deleted member 8621]

I want to create a command button that when clicked it brings up a network browser window where the user can select a share (folder) and then when a report is generated they are prompted to save to the location they selected.

To do this will I need to create a table with the user selected share or can I use code to assign the value without pulling from a table? If a table is the only way what type of field should I call it??? Text?? Can I save the file in a .doc format and how??

I have no existing code to post.

thanks
matthew

 

[dcx693]

Your post is very confusing. In fact, it doesn't sound like the title of your post has anything to do with the contents. What are you trying to accomplish here? Is it simply that you want the user to be able to pick out a folder from a list of folders and to retain that selection somewhere in a database? From the sounds of your post, it wasn't even clear that you needed to use Access.

 

[a.sinatra]

I have totally no idea either...


"replace text in a string with a command button"

This is what i THINK you want,

A button that opens up a network explorer window->
(user browses for path and selects)

Click a save button that would save the location to a table->

Everytime you would like to save a report you want that path to show up->

User changes file name to whatever and then saves ->


________
List Of Yamaha Motorcycles

 

[Deleted member 8621]

Kinda

That is the only way that I can think of to do it. I was hoping that there was another way but figured there wasn't. Thought I would ask just to make sure.