Search results

Dear All, I have two tables with 200 columns without any primary key. I want to findout the numbers does not match in both. SELECT C1, C2, C3, C4.... C200 from T1 MINUS SELECT C1, C2, C3, C4.... C200 from T2 Please let me know what is the workaround for this. Thanks Ria

We get the file without header and I have table in MS Access database with all the fields but we don't want to change the file manually. No of records also very every month. Thanks Ria

Re: The table name you entered doesn't follow System object-nameing rules Dear vbaInet, Do you have any solution for the issue I posted on below link: http://www.access-programmers.co.uk/forums/showthread.php?t=205121&page=1 Highly appreciate your solution for the above issue as well...

Re: The table name you entered doesn't follow System object-nameing rules Thanks Dear. Great solution! :cool: Thanks a ton. Regards Ria

Re: The table name you entered doesn't follow System object-nameing rules Thanks Dear vbaInet I was doing something wrong that's why I was getting the error. And later I end up changing the code anyway somehow I managed to solve that. Initially I was using [code]...

Dear Friend, Below statement does not have any issue. That is working fine. If Not rsTmp.EOF And rsTmp.BOF = False Then Please see comments in below code which is not working / called. [code] strSelectSQL = "SELECT DatabaseCode, ConnectDB_String FROM tbl_Supp_Databases where...

It's working fine. Not sure what happened. I did not change the code, next day it start working, Thanks for the help

Re: The table name you entered doesn't follow System object-nameing rules Can I used variable for database name? If use variable for database name my system is not responding once it reach below step. [code] objApp.OpenCurrentDatabase (strCnPDatabaseName)[\code] value of strCnPDatabaseName...

Dear Friends, Still same issue. Function is not called at all in below code. [code] strSelectSQL = "SELECT DatabaseCode, ConnectDB_String FROM tbl_Supp_Databases where ConnectDB_String <> """" " Set rsTmp = gsSecuredDatabase.OpenRecordset(strSelectSQL) If Not rsTmp.EOF And...

I commented out because it was not working. If you take out comments and put a breakpoint to test. It'll not call that function. Thanks Ria

Dear All, I'm executing below simple SQL to delete the data from Remote Database but somehow it's not deleting the data. strDeleteSQL = "DELETE FROM " & sTableName gsCnPDatabase.Execute (strDeleteSQL) Code for Remote database [code] Option Compare Database Global...

Code is in CnP Utilities20110211.mdb As other database contains huge data so I created empty databases just for reference. Main Class is: frmLogin Routine is: Private Sub Form_Load() Issue: Below code will extract / fetch the value DatabaseCode and ConnectDB_String from...

Re: The table name you entered doesn't follow System object-nameing rules Hi Peter, Thanks a lot for the help. As now data is coming for 3 tables so SQL is fetching data from 3 tables so I'm updating the code something like this: Dim RemoteTableName_Secu As String Dim...

in frmLogin Private Sub Form_Load() strSelectSQL = "SELECT DatabaseCode, ConnectDB_String FROM tbl_Supp_Databases where ConnectDB_String <> """" " Set rsTmp = gsSecuredDatabase.OpenRecordset(strSelectSQL) If Not rsTmp.EOF And rsTmp.BOF = False Then Do While Not rsTmp.EOF...

If don't use Module name then I'll get the following error: Comple error: "Expected variable or procedure, not module." If you use below code then function is called: If ConnectCnpDatabase.ConnectCnpDatabase() = False Then iOk = MsgBox("Unable to open CnP Utilities Database"...

Re: The table name you entered doesn't follow System object-nameing rules Hi vbaInet, Please help to throw some light on your second option ("connect to the database and use the database object for creating the query so it points to that database.") How to create the object and how to use...

Re: The table name you entered doesn't follow System object-nameing rules Dear vbaInet, tbl_Details_YTD the name of the table. Please find below the code: Private Sub cmdBtnRunSecuSG_Click() On Error GoTo ERR_HANDLER Dim rsTmp As DAO.Recordset Dim strSelectSQL As String Dim stDocName As...

I got one work around for the above problem but that's not good solution. To check the connection for each database I'm following code: If ConnectBacDatabase.ConnectBacDatabase() = False Then iOk = MsgBox("Unable to open BAC Database", vbCritical, "BAC Database not found") End If Same...

Re: The table name you entered doesn't follow System object-nameing rules Dear vbaInet, tbl_Details_YTD the name of the table. Please find below the code: Private Sub cmdBtnRunSecuSG_Click() On Error GoTo ERR_HANDLER Dim rsTmp As DAO.Recordset Dim strSelectSQL As String...

Dear John, Both thread are not identical. I want to import the data in different database not in CurrentDB. I have two different databases (.mdb files). One file contains only VBA Code (No Table, Query) and another database contains all the tables and queries. In other words Code is...