Search results

  1. R

    Update after import is not working

    I'm trying to update one of the field after loading / importing the data in the table. But somehow that field is not getting updated. Below is the code I have used for the same. Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase...
  2. R

    Top Product

    I have 160 products in a table (one columns for each product). Tables structure is like: RM Customer Prd1Rev Prd2Rev Prd3Rev Prd4Rev ..... Prd160Rev What will be the query to find top 50 product's revenue? And what will be the query to find top 50 product's revenue and the RM? something...
  3. R

    #Error while summing up the columns

    When I summing up more than 100 columns then total is showing #Errorinstead of amount. Select C1+C2+C3+C4+C5+...+C100 Till 100 columns sum is ok Select C1+C2+C3+C4+C5+...+C160 but if I add another column then sum is showing as #Error instead of value. :mad: Please let me know what is the...
  4. R

    Compact Secured Database

    Dear All, I'm trying to compact the secured database and wrote below code but I'm getting below error "Cannot Start Your Application" Error When You Open a Database Project That Has an Access Data Connection We have two different databases. One database contains only code and another...
  5. R

    Syntax for MINUS

    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
  6. R

    Not able DELETE / INSERT in Remote Database

    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...
  7. R

    Peculiar 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...
  8. R

    The table name you entered doesn't follow System object-naming rules

    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...
  9. R

    Convert String Value to Date format (20110315 --> 15/03/2011)

    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...
  10. R

    Excel file without header into access

    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
  11. R

    Import Excel to Access

    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...
Back
Top Bottom