how can i limit the data size while entering to the database ?
how can i limit the data size while entering to the database from Excel sheet using vb6?
Answer Question
| May 2, 2008 10:43 AM
Microsoft Excel, VB, Visual Basic
how can i limit the data size while entering to the database from Excel sheet using vb6?
Answer Question
| May 2, 2008 10:43 AM
Microsoft Excel, VB, Visual Basic
convert fraction to decimal numbers
In Visual basic how do you convert fraction to decimal numbers?
Answer Question
| May 1, 2008 8:55 AM
Conversion functions, Visual Basic
In Visual basic how do you convert fraction to decimal numbers?
Answer Question
| May 1, 2008 8:55 AM
Conversion functions, Visual Basic
Using shell execute from Visual Basic
How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland
Answer Question
| May 1, 2008 5:34 AM
Microsoft Access, Oracle, ShellExecute, SQL Loader, Visual Basic
How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland
Answer Question
| May 1, 2008 5:34 AM
Microsoft Access, Oracle, ShellExecute, SQL Loader, Visual Basic
IS It Possible to create Recusrive function using sql udf or stored procedures?
Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. [...]
Answer Question
| April 28, 2008 7:38 AM
Recurive function, Recursion, SQL, SQL UDF, VB, Visual Basic
Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. [...]
Answer Question
| April 28, 2008 7:38 AM
Recurive function, Recursion, SQL, SQL UDF, VB, Visual Basic
Working with Excel in ActiveX DLL
I have a OCX file that is registered on client’s PC and called from ASP to perform the Excel manipulation (copy charts and paste into PPT). I tried to register the OCX on server and called using <Object> tag, did not work, still looking for the OCX on the client. Created a new DLL file [...]
Answer Question
| May 20, 2008 5:59 PM
ActiveX, DLL, Microsoft Excel, OCX, VB, Visual Basic
I have a OCX file that is registered on client’s PC and called from ASP to perform the Excel manipulation (copy charts and paste into PPT). I tried to register the OCX on server and called using <Object> tag, did not work, still looking for the OCX on the client. Created a new DLL file [...]
Answer Question
| May 20, 2008 5:59 PM
ActiveX, DLL, Microsoft Excel, OCX, VB, Visual Basic
How to rectify the overflow error occured?
Hi.. i appended 4 to 5 records, after that overflow error had occured while executing the sql query in vb…. Pl guide me how to solve this? Sree…
Answer Question
| September 28, 2008 4:20 PM
SQL error messages, VB, Visual Basic
Hi.. i appended 4 to 5 records, after that overflow error had occured while executing the sql query in vb…. Pl guide me how to solve this? Sree…
Answer Question
| September 28, 2008 4:20 PM
SQL error messages, VB, Visual Basic
How to work with Visual Basics 6.0 and SQL Server 2000
I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?
Answer Question
| February 11, 2012 1:17 PM
SQL Server 2000, SQL Server integration/interoperability, VB, Visual Basic
I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?
Answer Question
| February 11, 2012 1:17 PM
SQL Server 2000, SQL Server integration/interoperability, VB, Visual Basic
How to pass Parameter of stored procedure Crystal report
How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure
Answer Question
| April 16, 2008 12:42 PM
Crystal Reports, Stored Procedures, VB, Visual Basic
How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure
Answer Question
| April 16, 2008 12:42 PM
Crystal Reports, Stored Procedures, VB, Visual Basic
SAP Security outside in
Question, I came to this company 1yr ago and noticed immediately they had not implemented Security!!! SAP_ALL for everyone in Production!!! So as my second BIG project I took on, Security. In building the profiles for these people I came across 2 problems which are holding me from rolling out these profiles I built, which [...]
Answer Question
| September 12, 2008 3:16 PM
SAP, SAP security, Security Program Management, VB, Visual Basic
Question, I came to this company 1yr ago and noticed immediately they had not implemented Security!!! SAP_ALL for everyone in Production!!! So as my second BIG project I took on, Security. In building the profiles for these people I came across 2 problems which are holding me from rolling out these profiles I built, which [...]
Answer Question
| September 12, 2008 3:16 PM
SAP, SAP security, Security Program Management, VB, Visual Basic
How to Split a String using Visual Basic
I want to Split the String sMemberName=Totalmarket <null> <null> C10A and store it separately how can i do it using Visual Basic
Answer Question
| March 15, 2008 8:54 AM
Strings, Visual Basic
I want to Split the String sMemberName=Totalmarket <null> <null> C10A and store it separately how can i do it using Visual Basic
Answer Question
| March 15, 2008 8:54 AM
Strings, Visual Basic
How can I learn more about Java and scripting languages?
I got my bachelor’s degree in electronics and communication engineering and continued to get my master’s in networking. When I started applying for internships, I found that most of the companies require Java, C, C++, Perl, HTML and Visual Basic, but I only have C and a little bit of C++ programming skills. I don’t [...]
Answer Question
| March 16, 2010 7:59 PM
C, C++, Career development, HTML, Java, Networking, Perl, Programming Languages, Scripting languages, Visual Basic
I got my bachelor’s degree in electronics and communication engineering and continued to get my master’s in networking. When I started applying for internships, I found that most of the companies require Java, C, C++, Perl, HTML and Visual Basic, but I only have C and a little bit of C++ programming skills. I don’t [...]
Answer Question
| March 16, 2010 7:59 PM
C, C++, Career development, HTML, Java, Networking, Perl, Programming Languages, Scripting languages, Visual Basic
How to add another row header to Excel Report using Visual Basic
HI, I want to add another row and column header to a Excel Report using Visual Basic..
Answer Question
| March 11, 2008 11:07 AM
Microsoft Excel, Visual Basic
HI, I want to add another row and column header to a Excel Report using Visual Basic..
Answer Question
| March 11, 2008 11:07 AM
Microsoft Excel, Visual Basic
How to search particular data in range of data and everytime save it in a cell
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
Answer Question
| March 29, 2008 8:45 AM
Microsoft Excel, VBA, Visual Basic
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
Answer Question
| March 29, 2008 8:45 AM
Microsoft Excel, VBA, Visual Basic
Recordet
Why we close/destroy recordset in vb? Is it good practise to close/ destroy recordset?
Answer Question
| April 13, 2011 3:11 PM
Recordset, VB, Visual Basic
Why we close/destroy recordset in vb? Is it good practise to close/ destroy recordset?
Answer Question
| April 13, 2011 3:11 PM
Recordset, VB, Visual Basic
VB6 vs. Visual Studios 6
What is the major differences between VB6 and Visual Studio 6.0
Answer Question
| February 21, 2008 5:08 PM
VB, Visual Basic, Visual Studio
What is the major differences between VB6 and Visual Studio 6.0
Answer Question
| February 21, 2008 5:08 PM
VB, Visual Basic, Visual Studio
Object.MouseEnter and/or Object.MouseLeave
I have built a program that is using 75 Control Buttons, laced in a Panel, on one form. Using a ForEach/Loop to loop through all 75 buttons, I am looking for the syntax (code) that will allow me to indentify which of the 75 buttons activated the ForEach/Loop by way on Object.MouseEnter and/or Object.MouseLeave in [...]
Answer Question
| February 22, 2008 7:28 PM
Object.MouseEnter, Object.MouseLeave, Visual Basic
I have built a program that is using 75 Control Buttons, laced in a Panel, on one form. Using a ForEach/Loop to loop through all 75 buttons, I am looking for the syntax (code) that will allow me to indentify which of the 75 buttons activated the ForEach/Loop by way on Object.MouseEnter and/or Object.MouseLeave in [...]
Answer Question
| February 22, 2008 7:28 PM
Object.MouseEnter, Object.MouseLeave, Visual Basic
data reportsin vb
how to do filter in database if i have to print a saperate record from a database, with the helpof dataraports, how to use tht.when ever i give give print command it will print all record that r present in the database, plz give me the details or code that i can print only a [...]
Answer Question
| February 20, 2008 9:53 AM
VB, VB Data Report, Visual Basic
how to do filter in database if i have to print a saperate record from a database, with the helpof dataraports, how to use tht.when ever i give give print command it will print all record that r present in the database, plz give me the details or code that i can print only a [...]
Answer Question
| February 20, 2008 9:53 AM
VB, VB Data Report, Visual Basic
Mobil 5.0 open an MS Access database
Can someone who has used a Mobil5.0 application to open,modify a MS Access Database. Would you share how you did this? I’m fairly new to VS2005. I have a application that communicates with a text file but would really like it to use a database instead.
Answer Question
| February 6, 2008 2:31 PM
Mobile data systems, Mobile devices, Visual Basic, Visual Basic developers, VS 2005, Wireless
Can someone who has used a Mobil5.0 application to open,modify a MS Access Database. Would you share how you did this? I’m fairly new to VS2005. I have a application that communicates with a text file but would really like it to use a database instead.
Answer Question
| February 6, 2008 2:31 PM
Mobile data systems, Mobile devices, Visual Basic, Visual Basic developers, VS 2005, Wireless
Visual Basic 6.0 Programming Trigonometry Question Using Repetition Method
Write a program to produce three lines of a trigonometry table. The program should request a number of degrees, n, as input and display the values of the sine, cosine, and tangent, function for angles of n – 1, n, and n + 1 degrees. The values should be displayed with five decimal places neatly [...]
Answer Question
| February 1, 2008 10:55 PM
VB, Visual Basic
Write a program to produce three lines of a trigonometry table. The program should request a number of degrees, n, as input and display the values of the sine, cosine, and tangent, function for angles of n – 1, n, and n + 1 degrees. The values should be displayed with five decimal places neatly [...]
Answer Question
| February 1, 2008 10:55 PM
VB, Visual Basic
Upper limit for numeric fields
What is the maximum numeric field length for Visual Basic Applications running on SQL 2000
Answer Question
| January 4, 2008 10:46 AM
Programming, SQL Server 2000, Visual Basic
What is the maximum numeric field length for Visual Basic Applications running on SQL 2000
Answer Question
| January 4, 2008 10:46 AM
Programming, SQL Server 2000, Visual Basic
