Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Run-time error 3011

Discussion in 'Information Technology' started by LJG, Jul 28, 2006.

Tags:
  1. LJG

    LJG
    Expand Collapse
    Guest

    Hi Guys,

    Am having a problem with some code, I have included this path in the code:

    strSS = "C:\database\appointments\appointment_" _
    & "*" & rst.Fields("User Name") & ".xls" 'the name of the
    field

    And fails here:
    DoCmd.TransferSpreadsheet acImport, 8, "tempAppointments",
    _
    strTransfer, True, ""

    Yet when I run this code I get an error message stating that it is looking
    for a file path of C:\reliable

    if I run in the code in the immediate the response's are:

    ?strSS
    C:\database\appointments\appointment_*Les.xls

    ?strTransfer
    Appointment_173_Les.xls

    So it finds the file in the correct folder then when it loops to look for
    more it appears to be looking elsewhere. I do have a folder C:\reliable but
    have no mention of it within my code??

    Any suggestions would be appreciated.

    TIA
    Les
     
  2. Loading...


  3. Michael J. Strickland

    Michael J. Strickland
    Expand Collapse
    Guest

    "LJG" <lj_girvan@no_spam_hotmail.com> wrote in message
    news:%23ZTUhRVhGHA.1520@TK2MSFTNGP03.phx.gbl...
    > Hi Guys,
    >
    > Am having a problem with some code, I have included this path in the code:
    >
    > strSS = "C:\database\appointments\appointment_" _
    > & "*" & rst.Fields("User Name") & ".xls" 'the name of the
    > field
    >
    > And fails here:
    > DoCmd.TransferSpreadsheet acImport, 8, "tempAppointments",
    > _
    > strTransfer, True, ""
    >
    > Yet when I run this code I get an error message stating that it is looking
    > for a file path of C:\reliable
    >
    > if I run in the code in the immediate the response's are:
    >
    > ?strSS
    > C:\database\appointments\appointment_*Les.xls
    >
    > ?strTransfer
    > Appointment_173_Les.xls
    >
    > So it finds the file in the correct folder then when it loops to look for
    > more it appears to be looking elsewhere. I do have a folder C:\reliable
    > but have no mention of it within my code??
    >
    > Any suggestions would be appreciated.
    >
    > TIA
    > Les
    >


    I don't see any reference to strSS in your "DoCmd.TransferSpreadsheet"
    statement.

    One thing I did notice is that you have included an asterisk ("*") in your
    filename. This is not allowed since the asterisk is used as a wildcard in
    filename references, not a literal character.


    --
    ---------------------------------------------------------------
    Michael J. Strickland
    Quality Services qualityser@att.net
    703-560-7380
    ---------------------------------------------------------------
     

Share This Page