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...
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 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!!!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.