|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 19th, 2005, 04:24 AM
|
|||
|
|||
|
Prompt user to enter file name
Hi!
I wanted to use an OutputTo function to save a file from access to html format. But I want my users to enter their desired file name, but not the path. so for exemple I want the path to be G:\myfolder\ and then the user chooses the file name with a prompt. Here is a bit of code but I need your help for the prompt bit  Code:
DoCmd.OutputTo acReport, "EnvoiCommande", acFormatHTML, this is wher I want the user to enter the file name, but not the path , False, "" Thanx for any help...
|
|
#2
August 19th, 2005, 01:17 PM
|
|||
|
|||
|
Just get the desired filename into a variable using inputbox or a custom dialog, and use the variable as the DoCmd argument.
Code:
strVar = InputBox("Enter the filename")
strVar = strPath & "\" & strVar
DoCmd.OutputTo acReport, "EnvoiCommande", acFormatHTML, strVar, False, ""
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Prompt user to enter file name |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
