Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   How to eliminate invalid bracketing of name (http://www.go4expert.com/forums/eliminate-invalid-bracketing-t4116/)

bhaskara123 2May2007 18:55

How to eliminate invalid bracketing of name
 
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.


All times are GMT +5.5. The time now is 18:54.