Recent content by rsampathy
-
R
Format function is not working.
Below function does not work in few machines of Access 2007 version. SELECT Format([Date],'mmm yy') AS Expr1 FROM table1; Error message : Format function not exist. Re-installed Access2007 still same problem. Please any suggestion. REgards, SAM.- rsampathy
- Thread
- Replies: 2
- Forum: Modules & VBA
-
R
EXPORT does not work in some pc's
Thank you. This command works in my PC but not in user PC. In problametic PC - Even it will not open dialog box of dlgSaveAs.show. With dlgSaveAs .AllowMultiSelect = False .InitialFileName = "\\Fmgdata3\data03\GlobalCorporate\Magnum\Reports\Exported Data\Export_" &...- rsampathy
- Post #3
- Forum: Modules & VBA
-
R
EXPORT does not work in some pc's
Hi, I have below EXPORT command in Access VBA code, it does not work in some PC'S (Access 2007). COMMAND: .TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryExporter", strFileName, True, "Data" While generating report, it will appear loading box then it will disappear. It will...- rsampathy
- Thread
- Replies: 4
- Forum: Modules & VBA