Recent content by manoj.mcans

Thanks Its working fine

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

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

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

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

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

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

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

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

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

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

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

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

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

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