10,989 Topics
| |
How can I connect my msacces database and use SQL query command like "Select Field FROM Table Where Field1 = foo AND Field2 = foo2" in Visual basic 6 and display the query result to a textbox. | |
| Option Explicit Dim mem As Double, ans As Double, desi As Boolean, n As Double Dim no1 As Double, no2 As Double, fact As Integer, i As Integer Dim operation As Boolean, op As String, res As Double, index As Integer Private Sub cmd1divide_Click() n = Val(Label1.Caption) If n = … |
hey..can somebody help me? how can i make this work? one pc has a vb6 application which added a record in the database (mysql) and when he/she had already added a record, a pop up message will show to the another pc that a new record has been added to … | |
hi, i have just migrated from CR8.5 to CR9. now i want to run/display Crystal Report 9 on client machine without installing it there. so, which .dll required for this situation? thanks, krunal | |
I am trying to use an IF statement to enable/disable command buttons; however, I get the following error message "Run Time Error '424': Object Required". The "cmdDeptStoresMC.Enabled=True" is highlighted in yellow when I run the code. Please assist. Below is my code: Sub Check_AccessRights() Dim X As String Dim Y … | |
William is interested in numbers. His friend Mary has been programming using Visual Basic and has told William about the Radom Number facility that the programming language provides. William never takes anything for granted and says to Mary: “I wonder how good this random number generator is. Suppose you write … | |
I have two forms as form1 and form2 in my project.in form1 it has textbox as txtid. I take n=txtid.text in from1.then how can I use the same value of n (got at form1) applicable at from2. | |
hi, i have a problem of Index was outside the bounds of the array. i don't understand how to amend the existing solution in my case. anyone could help me? the message error is System.IndexOutOfRangeException {"Index was outside the bounds of the array. below is the code & the error … | |
i have 5 form that with 4 form to enter input and the last form is to make a calculation and display the output.But the problem is,i cannot get the calculation and the output to be played because the last form does not attach the input that i have enter … | |
I'm using a MSHFlexGrid (fgdVehicle) to input data from a database ( via a recordset (rsVehicle) ). You can either enter the data into the database in two ways : 1. From the database application 2. From a form. The problem is present in the second method. There are specific … | |
hi, can u help me my Datagrid which connected to ADODC1 was updating evrytime i click my ADD command button, then i made another command button to CLEAR what data is in the grid, i used this codes to do that but always error like this "KEY COLUMN INFO IS … | |
Hey so I have a customer form which has two buttons and displays contact data,containing a simple cancel and proceed. The main functionality is behind the proceed on_click handler.Becuase I want to determine whether the the entered details belong to a new person or just edit. I have got the … | |
i want to add items from webbrowser to listview i had use these codes to add in text1.text text1.text = WebBrowser1.Document.Body.InnerText now i want to use listview i try this LV.ListItems = WebBrowser1.Document.Body.InnerText but its wrong need lil Help with this code | |
hi, my command button sets its function to get the sum of my daily income. And when i click it again the sum will become double (EVERY CLICK) so i want to my command button to WORK by only 1 CLICK. example 10 + 10 = 20 when i click … | |
How to create flexgrid control with save & modify & deletaion & cancel button one example | |
Hi, help me please I have a project that gather the total cash of my customer. First when i click the 1st total button, the cash value will go to adodc1. Adodc1 is set for DAILY cash values inputs. After multiple cash value in the adodc1 i need to total … | |
I need assistance with using Keypress to only allow a certain range of numbers (1-26) to be typed into the textbox. When ever I do it, it only allows me to press the numbers "1 and 2". I'm very new to VB so the help is much obliged. I know … | |
I am new to Visual Basic 6 Class Modules and am having difficulty constructing a certain class. First off, I created a simple class, which is basically an array with some basic properties (Sum, etc). Next off, I want to create another class, which has these arrays as properties. As … | |
i wrote and compiled an vb 6 program on a windows xp sp2 box i am trying to run the program via a batch file from an nt box i get this error: runtime error 91: object variable or With block variable not set the program runs under the scheduler … | |
hi i need a code for update a record in vb6 i am using ms acess and ado | |
hey..can someone help me?? i have a html/php file with a command button and when i clicked it, it will run the exe file of a vb6 application. how can i do this?can i have sample code?? thanks in advance. | |
Hi friends, I'm developing an application for HR. I have two tables so far.One is tblDetails and the other is Academic. I have created a relationship (ID to AcademicID), I have been able to pull data to a form by this SELECT statement: sqlSearch = "SELECT tblDetails.ID, tblDetails.FirstName, tblDetails.Surname, Academic.AcademicID, … | |
http://www.warriors-rules.com/socks.txt i want to creat login application for this application have 2 textbox 1 webbrowser 1 button login text1.text username text2.text password i am useing htaccess for this AuthUserFile /.htpasswds/.htpasswd AuthName "Sockz-5 Login" AuthType Basic require valid-user | |
my text box have multi lines i want to count those lines and show it in form caption. spoz i have 12 lines in text1.text i want show it like this Sockz-12 | |
Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = … | |
The attached excel worksheet can explain better of what I need. I need to calculate the attached based on fiscal year starting with August and ending in July for the next 5 years. If you have any other questions for better understanding please let me know. | |
vb6 code to check if record doesnt exist,then insert new record.server is ms access 2010.So when i used the Dlookup function If IsNull(DLookup("[empid]", "[employee]", "[empid]= & txtemplid.text")) Then I got error like "function or subfunction not defined .is it due to issues with referencs .how can i fix this error … | |
my record got OrderFormNo and CashBillNo.(one to one insert) if 1st record OrderFormNo is 123 and CashBillNo is ABC, if 2nd record also same OrderFormNo, the CashBill must be same. As a result, I want detect if got same OrderFormNo in database but different CashBillNo, will not insert to database. | |
roll no. name 2/12/2012 14/12/2012 23/12/2012 12 james 56 90 88 23 philip n/a 99 76 45 rosy 55 n/a 85 6 peter 59 74 45 13 sam 69 73 n/a this data i have in excel sheet,i want to write a vba code that depicts individual student's performance in … | |
**PLEASE HELP ME. THIS CODE WILL RETRIEVE THE SEQUENCE YOU MADE. AND WILL OUTPUT IN THE TEXBOX IN THE NEXT FORM. BUT MY PROBLEM IS THAT IT DOES NOT RETRIEVE/GIVE THE GENERATED SEQUENCE. FOR SHORT NO OUTPUT T__T . PLEASE HELP.** Public Sub getJO() Dim oradb As String = "Provider=OraOLEDB.Oracle; … |
The End.