Recent content by radubalmus

Hello all I get the above error tring to create a new entry in an sql database. I am using an excel frontend with ADO connection. This happens since we have upgraded excel from 2003 to 2010 The error happens on MyRecordset.Open this is the code: Dim MyConnection As ADODB.Connection Dim...

Hello all I get the above error tring to create a new entry in an sql database. I am using an excel frontend with ADO connection. This happens since we have upgraded excel from 2003 to 2010 The error happens on MyRecordset.Open this is the code: Dim MyConnection As ADODB.Connection Dim...

i have an excel file witch i use as an interface to connect with a sql server. within the excel file i write and read in/from the sql server. so i have a lot of macros in the file. but for some time now the excel takes long time to open, and i don't have any macros on workbook_open event...

Thanks for the sites i am not using any macros when the file is opening.i use the macros after the i open de file. There are simple solutions for almost every problem! The hard part is to see them!!!!

Hello I have an excel file in witch i use o lot of macros and since a while it takes about 30 sec to open(on slower pc takes even longer or if i put it on the network). any ideas why?? how can i make it open faster? Thanks There are simple solutions for almost every problem! The hard part...

Yes CautionMP you are right.. So i discovered my self.. On the pc i was try to implement the Regional Language was Spanish... and the way nubers are showed is diffrent: In english: 123,456,789.00 In spanish: 123.456.789,00 :)) There are simple solutions for almost every problem! The hard...

I am using VBA to calculate some values: energy = (speed / 3.6) ^ 2 * weight / 1000 / 2 sheet.Cells(20, 2).Value = energy and on the PC i am working i obtain: energy = 92.32423 but when i am trying to use the macro on an other PC i got: energy = 92,32423 and when i am trying to show the...

it is working thanks There are simple solutions for almost every problem! The hard part is to see them!!!!

Thanks bborissov i 'll give it a try.. i have one question :)) Can i put in the WHERE a criteria from test and a criteria from test_orders?? ex. WHERE test.test = '" + singletest + "' AND test_orders.costcategory='" + category + '" There are simple solutions for almost every problem! The...

Maybe i didn't explained my self better it is just lile you say i use the result from the first to build the second.. but it is taking to long to see the results soo i would like to use an sql join for combining the two querys into one query(i think this will be much faster).. and so i...

hy bborissov what do you mean exacly?? i want the "product_rating" from test_orders table for a certain testorder and "result1,...." from the test table for the same testorder There are simple solutions for almost every problem! The hard part is to see them!!!!

Hy i am tring to join 2 querys but i don't get any results and running them apart takes for ages I have two table and i have only one commun column "testorder" the code looks like this For testcounter = 2 To test.count + 1 singletest = test.Item(testcounter - 1)...

you mean that you can't hadle the userform(drag it on the screen??) and with the last example posted you can move it??? There are simple solutions for almost every problem! The hard part is to see them!!!!

thanks combo, this helps a lot There are simple solutions for almost every problem! The hard part is to see them!!!!

thanks guys, combo, the API works like a charm(i was thinking i need API, from what i was reading, but i never use it before) Where can study more about API(do you have some interesting links)???? There are simple solutions for almost every problem! The hard part is to see them!!!!