10,992 Topics
![]() | |
how to get null field value from access in vb6 in my 2 record field the value is empty but i'm not able to get that empty field in vb6 ... .... set rs = new adodb.recordset rs.open ("select * from table1 where id = '2'") text1.text = rs!name please … | |
hi.... can you tell me how can i make the antivirus in visual basic 6? if you have somw source code it will be more benificial for me. thnaks in advance.... | |
-->>Hi,I am getting tired of recreating the menus in every form I design my be due to lack of information... -->>Thus I was wondering if there is a way that I write codes in may be a module so that I may be using it... -->>by just calling it in … | |
Well I have to make a microwave program in Visual Basic for school. I can't seem to find anything in the index that will help me with the timer/countdown. I found TimeOfDay() and was going to use that for the clock but I can't figure out how I would make … | |
how can i do visual basic coding for optimisation problem for steepest deecent, powel method, fiscer reeves, penalty function, geometric programming, . can u give us the whole code for any single problem on each method | |
Hi there, I'm a Visual Basic novice and have written a very simple GUI which I want to use to run a c++ program. I'm wondering how I would write the button click event to call the C++ program? I assume there's probably a simple way to do this but … | |
Private Sub cmdAdd_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection Dim rsAdd As ADODB.Recordset Set rsAdd = New ADODB.Recordset Dim Query As String con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Asus\Desktop\VBTHESIS_liel2\ListofMembers.mdb;Persist Security Info=False" con.CursorLocation = adUseClient rsAdd.Open "SELECT * FROM census WHERE ID ='" & strId & "'", con, adOpenStatic, adLockOptimistic 'If textboxes … | |
Imports MySql.Data.MySqlClient Public Class Form1 Public sConnection As New MySqlConnection Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If sConnection.State = ConnectionState.Closed Then sConnection.ConnectionString = "SERVER = localhost; USERID = root; PASSWORD =; DATABASE = vb;" sConnection.Open() End If LoadPeople() End Sub Public Sub LoadPeople() Dim … | |
Hello everybody , Im created an Application in vb6.0 . In that application i have to store data in a web Mysql database.How can i connect tht | |
i am trying to execute an exe file on a remote computer using vb 6.0 and i'm using psexec here is my code: shell("psexec //computer1 d:\test.exe") but it is not working by. by the way i am using a cloned system. can anybody help me.. thank you so much. | |
hi guyzz i wanted to remove item in the lisview using the for each i want to delete multiple item with similar field in the listview. any help.. for this problem.. it could be possible ? i have here code but it delete only selected item in the listview. (ListView1.ListItems.Remove … | |
hi i need to connect a vb application to a mysql database which is in a remote server plz suggest solutions thank u very much | |
Hi all, With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure … | |
-->>Hi to all, now I was about to document the help file of my applicatiion and I thought "How or what kind of controls will I use to have something like waht Microsoft has in a Word application where I can just write the documentation in in such a way … | |
Sir good morning. can you give me some codes of how to make a Online Grading Enquiry System using visual basic. i need your help sir beacause this is uour project. hope can you help me.. thnx in advance more power god bless | |
hi, i am getting Run time error '13': Type mismatch error. below is my code: Dim ndMain As Node Set ndMain = TreeMain.Nodes.Add(, , "Root", "Main Menu", "myappname") thanks, krunal | |
Students Details and Mark Entry Form Input : Number of students, Student Name , Student Id, 5 subject marks entered through inputbox by using dynamic array Output: List of all input Students Grade Form Input: - Output : List of students Name, ID, 5 subjects, Average, Grade Students Grade Analysis … | |
Hi, I'm manage how to find word in textbox. In textbox : "How i can be a good programer? How i achieve that?" If i want to search "How" then it should return 2 How words in text. Please Help. Thank You. | |
-->>Hello I hope all is well. -->>I'm trying to join or select some data from 5 tables by using the following join statement: SQL ="SELECT RegistrationTB.Christian_Name,RegistrationTB.Father_Name,RegistrationTB.Birth_Date," "BaptismTB.Date_Baptised,BaptismTB.Parish_Name,BaptismTB.Minister_Name," & _ "CommunionTB.Date_Communised,CommunionTB.Parish_Name," & _ "ConfirmationTB.LC_No,ConfirmationTB.Date_Confirmation,ConfirmationTB.Parish_Name,ConfirmationTB.Minister_Name," & _ "MarriageTB.LM_No,MarriageTB.Date_Married,MarriageTB.Parish_Name,MarriageTB.Mr_Name,MarriageTB.Mrs_Name,MarriageTB.Certificate_No,MarriageTB.Minister_Name " & _ "FROM RegistrationTB " & _ "INNER JOIN BaptismTB ON RegistrationTB.LB_No=BaptismTB.LB_No " … | |
-->>I hope all is well... -->>I have tried to use the package and Deployment wizard to create a setup for My application... -->>But the way My setup Icon Is (The default one) makes me feel uncomfortable,as I have an Icon alredy for my application and used it in all of … | |
-->>Hi all... -->>Here is what makes me be unconfortable here... -->>I was trying to develop a Progam that will help me creat a folder and make a copy of my passports -->>I managed to creat a folder but when I try to Copy the files is where I get an … | |
Hi, I have been working with some legacy code at work. There seems to be a common logic in storing an entire table in the database as an array. I have got no clue at all as to why this needs to be done. The recordet is open the entire … | |
In my project, I have two seperate forms and in one of them I can add various panels using a button. After adding let's say 5 panels I click on one of them and I need the code to tell me which panelI clicked on. The reason I need this … | |
Is there a way to create a VB6 e-mail program fearturing attachments that bypasses attachment size limitations? Thanks in advance! | |
Hi all I would like to search a Excel List of names(voters Registration list) by typing a name to see if that person is registered. Can anyone advice me how to do it or provide me with a sample program Many thanks | |
Hello Community, I would like to know if there is a way to use augmentations on a visual basic.net program? Eg. "ProgramName.exe Command" And i mean on my vb program so i could use a commandline using cmd to do something on my program. Please Help. | |
Post Thread: Searching Database file if existing or not. How to Add the Microsoft scripting runtime dll in my Project reference menu. I saw Microsoft Script in the components. Is this the file? Anybody can help me or give me step by step procedure to add this Microsoft Scripting runtime … | |
So I have a main form and 5 other forms. When I press a button on the main form, I want it to open Form2 and disable a certain button in form2 so that it cannot be used. I produced this code but the button is still active and there … | |
Hello guys I have got a little programme that been written in Python, I did connect it to an application been created in Visual Basic 2010, But to run the Python file, Of course you will need to install the Python software/Format to be able to run the python file, … | |
I wanted to know how to separate contents of a tab from another tab. I tried Deleting It but it was deleted even in tab 1 I used Microsoft Tabbed Dialog Control SP6 Any help would be Appreciated Yuvjeeth | |
Good day! I have a variable string that will hold numbers...I need a function that will check if the number meets the below criteria: **( Acceptable format )** -accept positive numbers -accept negative numbers -accept single decimal place (ex. 567.89) -will not accept double demical place (ex. 567.89.678) -will not … | |
**how can i delete a record on a database? im using this codes: Private Sub cmdDelete_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection Dim rsDelete As ADODB.Recordset Set rsDelete = New ADODB.Recordset MsgBox "Are you sure you want to delete?", vbYesNo, "Santo Niño Census Info System" ' i … | |
Hello Community, I was wondering if there is a way to replace a cell value from one excel spreadsheet and save it as another spreadsheet but with the replaced cell value. Please Help | |
I'm trying to switch "M" to "Mr." and "F" to "Ms." when the last name is selected in the listbox. When I clicked on the first name it worked, but when I clicked on anyother name, I got this error message: --Additional information: Index was outside the bounds of the … | |
using MS Excel 2007, and VBA I have two combobox.The first combobox has three items as:{One, Tow, Three} now I would like to load the second combobox based on what user select in combobox1. For example if user select One in the from combobox1 then namebox1 will populate to combox2 … | |
Has anyone tried to run a vb6 exe on the new MS Surface tablet? | |
Hello, I need a simple way to mail from OUTLOOK WEB APP not from OUTLOOK via a VB6 code. Anyone know how to do that? Any code/link avaliable? Thanks, Krunal | |
I'm still having a problem with this. Can someone help? Let me explain a little more of what I need. Range("G3:G" & Cells(65536, "A").End(xlUp).Row).Select Selection.FormulaR1C1 = _ "=IF(ISNA(VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0)),35,VLOOKUP(RC[-6],SUMMARY2!C[-6]:C,7,0))" Sub Compare() Worksheets("SUMMARY2").Visible = True I'm still having a problem with this. Can someone help? Let me explain a little more of … | |
Hi guys, im developing an inventory system. things are doing good until ms access starts to slow down my vb6 project. my records are already exceeding 13k rows. retrieving and recording are laggy. like 3-15sec waiting. now. im planning to migrate to mysql. i already have mysql and SQLyog as … | |
how can i connect crystal report 8 with my vb code ? | |
hallo all.. i have question about connecting barcode scanner to vb6 how to connecting barcode scanner to vb6... i use usb barcode scanner... did i must set port or some code in vb6..??? or it works automatically..??? i need some code reference plsss... | |
GIVEN below is vbscript to connect to acess database and insert records into the table using forms Private Sub Command1_Click() Set rs = cn.Execute("insert into employee values('txtempname.text',txtempid.text,txtssn.text) ") rs.Close cn.Close End Sub Private Sub Form_Load() datafile = "C:\mas.accdb" With cn .Provider = "microsoft.ACE.OLEDB.12.0" .ConnectionString = datafile .Open End With End … | |
I want to change form background color permanently at run time. when i start my application next time then i want to see the changed color please help thanks in advance | |
Hello everyone Is there any way to kill the python.exe in Task Managaer "On Windows" using visual basic The Problem is that i do open more than 1 python file at the same, But on task manager it's hows me something like this Python.exe python.exe python.exe python.exe I have got … | |
Hello How to change the resolution in VB6 ??? If one have 1200x900 and other have 800x 600 how can VB6 change or know what resolution the user have. Thanks Lenny | |
Can someone please show me how to get the Odd number using the For..Next loops in VB I have declared the following; Dim intCounter As Interger Dim intStartValue As Interger Dim intEndValue As Interger Dim intSum As Interger intStartValue = 0 intEndValue = 50 intSum = 0 Iam trying to … | |
Hi everyone I'm new in VBA and I have a problem with my code, if someone can help my I will be grateful. I have this part of code in Excel VBA an work fine Dim NumeroArchivo As Integer Dim conta As Integer Dim ListArchivAbierto As String NumeroArchivo = Workbooks.Count … | |
When working with loop some time the loop goes into infinity while testing and I have terminate with “Ctrl+Alt+Del" and lose all unsaved work. How to get out of infinity loop without losing unsaved work. thanks | |
hi. im developing an inventory system. my problem is i need to create a datareport with date range so i created a query in ms access and i got the result but to get the result i should run the query first then a dialog box will pop-up to get … | |
Hello , I'm making tetris in vb.net and i'm working with an image in a picture box that falls and with classes , my whole program works but hen my image falls it actually copies itself , does anyone know an eraser function or something or a method how to … |
The End.