Results 1 to 13 of 13
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: back to the folder issue...HELP!!!!!

    Private Sub Command8_Click()
    Dim strFolder
    Dim strFolderName As String
    Dim quote As String
    Dim FolderExists As Boolean

    quote = InputBox("Please enter quote #", "Enter Quote #")
    strFolderName = "x:\Quotes\" & quote & "\"
    strFolder = Dir(strFolderName, vbDirectory)
    If strFolder = "" Then
    FolderExists = False
    Else
    FolderExists = True

    If FolderExists(strFolderName) = False Then
    MkDir (strFolderName)
    End If

    'Since you always want to create the report then move this outside the If-Then
    DoCmd.OutputTo acOutputReport, "quote1", acFormatRTF, strFolderName & quote & ".rtf"

    End Sub

    this tells me "expected array" what is missing....

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    On what line?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    sorry i figured that one out.. wasn't really payin attention and forgot the End If but........

    when outputting a report, what is the best format to use that resembles the access report...with RTF you lose the check boxes...

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by DackJaniels
    sorry i figured that one out.. wasn't really payin attention and forgot the End If but........

    when outputting a report, what is the best format to use that resembles the access report...with RTF you lose the check boxes...
    Dump it into a snapshot or a pdf.

    For the pdf, search this forum for CutePDF Writer ... I've posted before on this one and I know the link is still around here somewhere. Or google for it ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Dec 2004
    Posts
    277
    ok i wasn't able to find anything in the forum on how to use this CutePDF Writer...but i was able to find the program, now how do i call on this when i am trying to use it

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by DackJaniels
    ok i wasn't able to find anything in the forum on how to use this CutePDF Writer...but i was able to find the program, now how do i call on this when i am trying to use it
    It creates a print driver ... So, File->Print->Select CutePDF Writer ... Then it'll popup a save dialog box to name the file as ...
    Back to Access ... ADO is not the way to go for speed ...

  7. #7
    Join Date
    Dec 2004
    Posts
    277
    yea but i need that automated... it has to be a background procedure... after it checks to see the folder exists and/or creates it it must then save the copy into the folder.

    this isn't for printing purposes, but more of a backup image of the report.

  8. #8
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    then use snapshot!
    it's access-native, outputs to .SNP file in one line, and is 1:1 what you see in the report.

    izy
    currently using SS 2008R2

  9. #9
    Join Date
    Dec 2004
    Posts
    277
    ok that worked really well.. now how do I call to print the snapshot?

  10. #10
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    you said it wasn't for printing!

    .SNP print is interactive - open the .SNP
    call shell("x:/wherever/snapview.exe y:/here/there/mysnap.SNP", vbnormalfocus)
    ...and menu:file-print it

    izy
    currently using SS 2008R2

  11. #11
    Join Date
    Dec 2004
    Posts
    277
    well it wasn't goin to be... but then i had an idea of instead of having to call on the access report, i can have it just print the file.

  12. #12
    Join Date
    Dec 2004
    Posts
    277
    so wait, the file is going to have to be open to print it? theres no way of just tellin it to print... please keep in mind that i am trying to keep as much in the background as possible.

  13. #13
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Per your PM, I don't know ... I know you can set the CutePDF Writer to be the default printer and then print the report directly (OpenReport "ReportNameHere", acViewNormal) BUT I don't know if the directory path and file name can be fed so that no interaction would take place ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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