How to eliminate invalid bracketing of name

Discussion in 'MS Access' started by bhaskara123, May 2, 2007.

  1. bhaskara123

    bhaskara123 New Member

    Joined:
    May 2, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi all,

    I got one error that is

    Run-time error '3126': Invalid bracketing of name '[Forms!Main!FromDate]'.

    Code:

    FileOut = FixName("SRMatrixCreatedByMonthMNS-" & Format(Forms!Main!FromDate.Value, "mmddyy") & "-" & Format(Forms!Main!ToDate.Value, "mmddyy") & ".xls")
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "SRMatrixCreatedByMonthMNS", TempLoc & FileOut, True
    CopyMyFile TempLoc & FileOut, FinalLoc & FileOut
    Kill TempLoc & FileOut

    Could anyone help me. It would be very useful to me

    Thanks,
    Bhaskar.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice