Recent content by jkainth

Hey guys I have some problem. i am using vba in excel to get some data from ms access 2003. I Have a stored query in the access database that i need to run and get the recordset using ADO. The query that i need to execute is a select query that uses other smaller queries to generate the final...

I have an access db 2003. I have a few tables and a few queries. I am using VBA in excel and need to get some data. Since my queries are quite long and complicated, i as wondering is there a way to call/run a select query that is stored in ms access via ADO?

ms access I have a empty table called ...'Table2' with 3 fields 'firstname', 'lastname', 'value' i have another table called ...'Table1' with 2 fields 'firstname', 'lastname' i have form with a textbox callled Text0 this is the query that i am having trouble with: INSERT INTO Table2 SELECT...

ms access I have a empty table called ...'Table2' with 3 fields 'firstname', 'lastname', 'value' i have another table called ...'Table1' with 2 fields 'firstname', 'lastname' i have form with a textbox callled Text0 this is the query that i am having trouble with: INSERT INTO Table2 SELECT...

i have form with textboxes, which gets populated with a query...(example): firstname(labels) lastname age ------- -------- ---- john (textboxes) Brown 30 linda pillon 42 . . . the user can make any changes to the above data while in the textboxes. There is a button in the footer section which...

Hey Well the example i have shown above is fairly simple, but what i am doing is quite very complex. There is alot a calculations that i do on the queried data. Moreover there are textboxes that get filled with data that doesnt arrive from the query. So exorting the qury isn't much of an...

i have form with textboxes, which gets populated with a query...(example): firstname(labels) lastname age ------- -------- ---- john (textboxes) Brown 30 linda pillon 42 . . . the user can make any changes to the above data while in...

Hey guys Need some help...im all brain dead trying to figure this out. I have a table that has the following(dummy date and table) Date person_ID pens_bought 19/10/2004 t15 50 21/10/2004 t15 150 19/10/2004 t15 70 21/10/2004 t20 20 29/10/2004 t20 100 In my...