Search results

Looking something which can be done without creating the tmp table?

Re: The table name you entered doesn't follow System object-nameing rules Dear Peter, I tried to implement the solution you provided that is also throwing the error: Dim tmpSecucashTableName As String tmpSecucashTableName = "tmpSecucashTable" strSelectSQL = " SELECT SECU.CUSTOMER...

Re: The table name you entered doesn't follow System object-nameing rules Dear vbaInet (VIP) Getting error at below line: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qryTemp101", strFile, True Error: The Microsoft Jet database engine cannot find the input table or query...

Dear Friends, I have Module called ConnectDatabase and in this module we written all database related functions. We have couple of databases and all these database details we have defined in below table. Format of the table (tbl_Supp_Databases) is below...

Re: The table name you entered doesn't follow System object-nameing rules Dear vbaInet (VIP) Thanks for Out of the box solution. Please let me try and I'll let you know. Do you have any out of the solution for below query: http://www.access-programmers.co.uk/forums/showthread.php?t=204227...

Re: The table name you entered doesn't follow System object-nameing rules Hi Peter, Thanks for the reply. I can't save this as a query becuase table does not exist in this database. This .mdb file contains only program and another .mdb file contain tables, data, queries etc. Thanks Ria

Re: The table name you entered doesn't follow System object-nameing rules Hi Dave, I'm not using tablename while exporting the data. Data is extracted using SQL and that data I want to export. Hope this is clear. Regards Ria

Re: The table name you entered doesn't follow System object-nameing rules Dear Friends, Thanks for the reply. Please find the value I'm getting for the variables: strFile: J:\TOSS New MIS Database\2011\Feb 2011\Reports\201102091553_TOSS_2011-01_1553.xls acExport: 1 strSelectSQL: SELECT...

Re: The table name you entered doesn't follow System object-nameing rules Hi Galaxiom, Thanks for the reply. Actually I have changed the ALIAS but error ("The table name you entered doesn't follow TOSS System object-nameing rules.") is displaayed while executing below line...

Dear Friends, I'm getting "The table name you entered doesn't follow TOSS System object-nameing rules." error when executing below code in MS Access using VBA. strSelectSQL = " SELECT SU.CUSTOMER, SU.ISIN_NO, SU.TURNOVER, SU.SOURCE, MAP.OVERVIEW, ADV.SUB_ADV " & _ " FROM...

Thanks for the reply. What is the syntax to convert? I have tried below syntax but that is not working? CDate(Left(VALUE_DATE, 4) & " / " & Mid(VALUE_DATE, 5, 2) & " / " & Mid(VALUE_DATE, 7, 2)) AS VALUE_DATE Regards Ria

Dear Friends, I'm using MS Access Version is 2002. And need to convert String Value to Date format (20110315 --> 15/03/2011) but all records do not have value. There are some records with null value. I tried below SQL in VBA but unfortunately this is also not working and throwing error "Error...

Dear Charles, Version of Microsoft Access is 2002. Yes both are unrelated database. One database contains Form, VBA Code only and second database contains the Tables and data. So user whatever the activities will perform that'll be done in second database which contains all the data. Thanks Ria

Dear Charles, Thanks for the prompt reply. I need to do this using VBA not manually. Please send me the sample code if you have. Thanks and regards Ria

Dear Friends, I need to import Excel file into access table using VBA code and Excel file DOES NOT have any column heading. Any idea how to do import data without changing the file. Thanks Ria

Hello Dear Friends, I have two access files. First file keeps only the Code and second file contains all the tables and data. I want to import the data from excel sheet into access (Second file which contains all the tables) using VBA. Below code is written in first file and data...