1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

How to eliminate invalid bracketing of name

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

  1. bhaskara123

    bhaskara123 New Member

    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