Search results

Hi all, I had already written VBcode.... my code works fine for normal queries.. but all my queries using case, substr, and sooo.. so if you see access won't understand case, substr.. if you want access to run such queries then you have to make them as passthru queries.. then the query will...

Hi all, I have 110 queries and i have to set connection string for each query to some... How to do this plsss...

Hi all, I use to run daily 110 passthru queries... My work is ... I ahve to run each query and output is saved into excel and save it.. This almost takes 2 1/2 hrs.. So i written a VB code that will work for normal queries...My code will excute and save output in excel in specified...

Hi all, I use to run daily 110 passthru queries... My work is ... I ahve to run each query and output is saved into excel and save it.. This almost takes 2 1/2 hrs.. So i written a VB code that will work for normal queries...My code will excute and save output in excel in specified...

Re: Ho to Save password while connecting Database from MS access & how to shedule que Hi Den, I tried it works.. but one more new problem... Evrey day these queries will update.. can i make it generic what ever might be the queries that are there in mdb file can i make my password should be...

Re: Ho to Save password while connecting Database from MS access & how to shedule que Hi Den, Thanks for your replay... Iam new to MS access... Yes i think my tables are linked. Is there any way to shedule this reports.. so that each query will run and save the output in excel... I...

Ho to Save password while connecting Database from MS access & how to shedule queries Hi All, Can someone pls help me.. I have a mdb file with some 110 queries in it and a made a ODBC connection to connect to my database and daily at 10:00 pm i ave to run all these queries and sent to...