Recent content by manoj.mcans

  1. M

    Opening the Excel file using VBA

    Thanks Its working fine
  2. M

    Opening the Excel file using VBA

    Hi, I am trying to open the excel file using VBA in MsAccess using below code, its execute fine and but didnot open the excel file Can any one help me where i am missing , that would be great help. ---On Btn Click event------------ Private Sub Command0_Click() Call ExcelInstance End Sub...
  3. M

    Pass Through take long time while save in MsAccess

    Hi, I created two seperate pass through queries in MS Access SQL Mode its take long time to save and open the same pass through queries . My table is on server and access on my local pc via ODBC link. Please try to resolve this issue , when i have make any changes in pass through query , i...
  4. M

    Query takes long time in execute

    Thanks yah i got it and found also that proprty for saving passowrd. then window does not pop up. Thank you very much one different query is: if i run pass through query using vba and from then it ask for connection string ..i have also mention but i am not getting where the error coming ...
  5. M

    Query takes long time in execute

    Thanks, Yah i have central database i.e in oracle all my team member use that via access odbc connection for generating the reports. we have more than one centeralize database. each user has its own credentials for that. I face one new problem in pass through query i.e whenever i run pass...
  6. M

    Query takes long time in execute

    Thanks , is there no other option exists, can i do code in VBA for pass through for making the Machine data source connection.. because if i make seperate pass through query for each database and then link then in ms access then also it very slow. I got one another common problem that most...
  7. M

    Query takes long time in execute

    I have 3 different database in oracle 1. for euipment detail 2. financial data 3 Asset status detail i have to fetch data from each database according to requirment . so different database has different username and different password for accessing. when i make query in ms access with 2 or...
  8. M

    create table with same structure from other table

    Hi, there are two method of creating the same table i.e By using Make Table query i.e first select the table which ever you can to copy in the design view and then select Query->MakeTable and then type new table name ..New table will be created. second: by using the SQL view tablename_old is...
  9. M

    Query takes long time in execute

    Thanks , I am creating the queries using 3 database, usually i was building the query using one database, first i make DSN in Machine Data Source and then select what ever DSN i want and then run the query, Its run fine Now Problem is: could you please help me , how to connect more than...
  10. M

    Query takes long time in execute

    Many thanks from the last few days i was struggling with pass through query and i was putting the double quotes in where clause , that was showing error instead of using single quotes.. now its working Thnak you very much
  11. M

    Query takes long time in execute

    Yah , I can not access the server , i have to run the queries on local machine , because there are lots of user who are accessing the server, Pass Through query option is fine but problem is whenever i run my query using where clause if field name consist underscore in column name , it shows...
  12. M

    Query takes long time in execute

    Hi, I have build one query which has 8 -9 subquery and 5-6 tables each table has 1/2 million records . i link tables via ODBC in oracle.this query take minimum 2 hour to execute, Please any one could suggest me , how to optimize the query and achieve the result in less time. Many Thanks
  13. M

    Simple Query

    If we have action query then we can directly run that query without going inot query design mode like docmd.runSQL queryname can we run simple select clause statement purely using vba instead of going into query design mode
  14. M

    Simple Query

    I want to run simple Select * from Tablename using vba code not going in query design mode. usually i use first create simple query in query design mode with name abc then in vba code I have made the odbc connection in Ms-Acccess Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim...
  15. M

    Problem in Under exist in Field_Name

    Yah its confirm its a text datatype.. i also tried like operator , but still it is not working ... but its work except pass-through query..
Back
Top Bottom