1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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