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

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

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

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

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

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

Hy, I am using VBA(and ADO) and i want to attach a file to a database recordset(i am using sql server database). Never done this before. I need some pointers, examples, links to get started Thanks in advance There are simple solutions for almost every problem! The hard part is to see them!!!!

i am building a query depending if some cells(my interface is excel) have text or not.. it is working, but when i am trying to read from a certain field it gives me an error "80040e14" ex: So the following works: SELECT...

Hy I get this error connecting to my sql database "Run-time error '-2147217900 (80040e12): [Microsoft][ODBC Sql Server Driver][Sql Server]The text, ntext, and images data types cannot be compared or sorted, except using IS NULL or LIKE operator" This is the code: Public Sub initPCR() Dim...

i know how to connect to an acces database, but i need to switch to Microsoft SQL, knowing the server, database name, user and password.. can give me some pointers.. Thanks in advance There are simple solutions for almost every problem! The hard part is to see them!!!!

hy, I have made a small program with an Excel interface and Acces database, and i need to switch to Microsoft Sql. For this the IT guys gave me an adress server, database name, user and password for the Sql server, but not even a litlle bit of tehnic support. I have nerver worked with...

Hy i keep getting this error "Data type mismatch in criteria expression. (Error 3464)" on the red line. have any ideea why? Public Sub initPCR() Dim ordersheet1 As Worksheet Dim query As String Dim pcrNr, paragraphId, samples, partsvizual, partsdimensional, partstests As Integer Dim table...

I understood that Oracle has higher capacity then Acces, and i am considering to switch to Oracle... For this i need some pointers and tips(some links eventualy....) about Connection between VBA and Oracle... Thanks, There are simple solutions for almost every problem! The hard part is to see...

i have a userform with two TextBox to ask for user and password for accesing a file ex: User john.smith Pass password how can i show in the TextBox, for the password, stars instead of letters and numbers So i want to see instead of password: ******** Any sugestions.. There...

i am trying to have a brake in the running of the code... while a cycle is running(ex: For......Next), before incrementation i want to stop and to see what has been happening in the exel sheet, eventualy do some hand modifying, and then to resume the code... i was thinking with a userform, and...

I am kind of a beginner in VBA.. I want to open an Word file, copy something from it and then open an Excel file an paste it there So my problem is that i don't know how to define Excel as an object in Word VBA or define Word As an object in Excel VBA. Would greatly apreciate help