Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using a string as a saved file name (Access 2000)

    ok. Here is part 3 of what I'm working on. I really appreciate all the help and support I have received. Thank You.

    The last thing I need to do is save the table I creating to a shared drive called R:CenterExportLogs. I need the name of the table to be the name of the saved HTML file. I want the strTableName string as my file name. Not sure how to pass that on. This obviously didn't work. Thanks again....

    Dim strTableName As String

    strTableName = "CenterChanges" & Format(Now, "mmddyyyyhh:mm:ss")

    DoCmd.OutputTo acTable, strTableName, "HTML(*.html)", "F:CenterExportLogsstrTableName.html, False, """

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using a string as a saved file name (Access 2000)

    <hr>DoCmd.OutputTo acTable, strTableName, "HTML(*.html)", "F:CenterExportLogsstrTableName.html, False, """<hr>

    Try: DoCmd.OutputTo acTable, strTableName, "HTML(*.html)", "F:CenterExportLogs <font color=red>" & </font color=red> strTableName <font color=red>& "</font color=red>.html <font color=red>"</font color=red> , False, ""
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •