Search results for query: *

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

I have a userform that opens with the workbook, and asks for user and password Private Sub Workbook_Open() Application.WindowState = xlMinimized Application.Visible = False UserForm2.CommandButton1.Enabled = False UserForm2.Show End Sub The problem: When i have other...

Someone told me he did it a few year ago, and he will look for the code to give it to me as example, he used an Ole Object type Field in Acces (like Image in Sql Server) but he didn't remember how.. it would be much easier for me to atach that file to a specific recordset(security reasons, i...

i was meaning exactly that(somethin like attaching a file to a mail). I was thinking it can be done(i am not an expet => that's why i am posting here). There are simple solutions for almost every problem! The hard part is to see them!!!!

Well it would have been great to attach the file to the database(something like you do in mails), because i have an .xls file with that is rather complicated it has 6 sheets, a lot of checkboxes, comboboxes... What do you mean: 2. Append data from one of the tables (sheets) in your workbook to...

Hy i need to attach a file(.xls) to a SQL Server database recordset using VBA. do you have any ideeas, tips (an example would be great :)) Thanks There are simple solutions for almost every problem! The hard part is to see them!!!!