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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
As I indicated, It repeat the same over and over and all the records has the same value, Not what I want. Here is what I mean. Private Sub Command1_Click() Dim mcnn As New ADODB.Connection Dim mstrSQL As String, mdblData As Double mcnn.ConnectionString =...- gthandle
- Post #9
- Forum: Data Warehousing/Big Data
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
It works in MS Access mdb BUT I want to use within my application in VB. This application has to open dBase,Excel,MS Access or flat file. So that is why I have to find a way to make it work in VB. "SQL statement".- gthandle
- Post #6
- Forum: Data Warehousing/Big Data
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
First of all Thanks for all your help. It doesn't works. It calls only once. That means if the first number is 9 it will always use the 9 to all the records processed. If I want to pass a field to this function. HOW ?. I tryed and it didn't work. "UPDATE [table] set field1 = '"...- gthandle
- Post #3
- Forum: Data Warehousing/Big Data
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
This call is from VB project NOT "MS Access Database file". It work only in MS Access not in VB. WHY ??????? and how to make it works. "UPDATE [table] set field1 = myfunction()" Here is my function code: public function myfunction() as variant myfunction =...- gthandle
- Thread
- Replies: 8
- Forum: Data Warehousing/Big Data
