Bhaskara123
Registered User.
- Local time
- Today, 20:57
- Joined
- Mar 26, 2007
- Messages
- 11
Hi all,
i am new to VB. when i wa tested one report. I got one error that is: Run time error '3126': Invalid bracketing of name '[Forms!Main!FromDate]'.
Code:
FileOut = FixName("EMPerformance-" & Format(Forms!Main!FromDate.Value, "mmddyy") & "-" & Format(Forms!Main!ToDate.Value, "mmddyy") & ".xls")
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformance", TempLoc & FileOut, True, "Summary"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase", TempLoc & FileOut, True, "EM Scheduled Detail"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase-Completed", TempLoc & FileOut, True, "EM Completed Detail"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase2-NewSR", TempLoc & FileOut, True, "EM New Detail"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase3-Pending", TempLoc & FileOut, True, "EM Pending Detail"
Anyone can help me it would be very useful to me.
i am new to VB. when i wa tested one report. I got one error that is: Run time error '3126': Invalid bracketing of name '[Forms!Main!FromDate]'.
Code:
FileOut = FixName("EMPerformance-" & Format(Forms!Main!FromDate.Value, "mmddyy") & "-" & Format(Forms!Main!ToDate.Value, "mmddyy") & ".xls")
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformance", TempLoc & FileOut, True, "Summary"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase", TempLoc & FileOut, True, "EM Scheduled Detail"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase-Completed", TempLoc & FileOut, True, "EM Completed Detail"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase2-NewSR", TempLoc & FileOut, True, "EM New Detail"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EMPerformanceBase3-Pending", TempLoc & FileOut, True, "EM Pending Detail"
Anyone can help me it would be very useful to me.