11,868 Topics
 | |
 | -->>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! i started my programming studies not a long ago. we work on c++ and somehow the program is not compiling on my computer. the software is legal, i installed and started it with no problem but when i do debug or build i always recieve this error at the …  |
 | |
| | 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 …  |
The End.