how can i limit the data size while entering to the database from Excel sheet using vb6?
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. If so please...
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...
Just to ask what really the cause of this kind of error "just in time debugging" Im using visual basic 6 and SQL Server 7, and im developing a biometrics program that this error is frequent to occur...may everyone share there ideas with regards on this matter, really need help. Thanks in advance.
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...
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?
Visual Basic, SQL Server 2000, SQL Server integration/interoperability
How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use...
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use...
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...
How we can publish the Lotus Notes Forms. Mean to say that how we can create the web application using Lotus Notes Forms
I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source").Value= "C:\Data.mdb" .Open .CursorLocation = adUseServer End With Can't i just...
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 selected record. plz...
We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...
In a text file want this type of output results(visual basic). Example-In text file 1001 47rt76gg 1002 gfug87gh 1003 udgf8ug8 1004 duhugh89 1.Number of rows 2.Any duplicates 3.Starting no & Ending no 4.Any additional charactor & tab or space 5.Asending order 6.Missing char
I own my own business and I want to develop a series programs to manipulate menus, data entry screens and data files. I have been looking at visual basic but not sure that is the best option. What software would be the best for me to learn and develop myself for my home business and possibly link...
I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I do not know how to use it....
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...


