Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. radubalmus

    The request for procedure "x" failed because "x" is a table object

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

    The request for procedure "x" failed because "x" is a table object

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

    Excel file taking a long time to open

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

    Excel file taking a long time to open

    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!!!!
  5. radubalmus

    Excel file taking a long time to open

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

    Comma and Point

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

    Comma and Point

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

    Multiple join

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

    Multiple join

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

    Multiple join

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

    Multiple join

    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!!!!
  12. radubalmus

    Multiple join

    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)...
  13. radubalmus

    How to show a Userform on top of other applications

    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!!!!
  14. radubalmus

    How to show a Userform on top of other applications

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

    How to show a Userform on top of other applications

    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!!!!
  16. radubalmus

    How to show a Userform on top of other applications

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

    Add a file to an Sql Server database using VBA

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

    Attach a file to an recordset?

    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!!!!
  19. radubalmus

    Add a file to an Sql Server database using VBA

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

    Add a file to an Sql Server database using VBA

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

Part and Inventory Search

Back
Top