[visual-basic] Forum Topics

Public Class Form1 Dim intsum, intaverage, counter As Integer Private Sub btnAverage_Click(sender As Object, e As EventArgs) Handles btnAverage.Click For counter = 0 To lbNumber.Items.Count - 1 intsum += counter Next intaverage = (intsum / lbNumber.Items.Count - 1) lblAverage.Text = intaverage End Sub Private Sub btnSum_Click(sender As Object, e As …

I am trying to navigate through several we pages and the hyperlinks are constantly changing. I am trying to figure out how to identify a specific link on a web page and then follow it.

I'll try to be brief in this post. I'm working on a cave generation program that will implement cell automata and marching squares. I'm new to Visual Basic and am wondering if the Canvas class is the best way to draw these black & white squares. For a reference the …

Hi to All. Im create a Vb 6.0 project with MS Acess back end. And Its Have A purchase Report Form. It's works good. But I want to made purchase entry by multiple product's data entered at single time. Like Entering products datas one by one it can be listed …

I was wondering if anyone could help me out with a problem I've had for a few days. This is a code snippet of a program I'm writing to move and delete email attachments from one or more selected emails. Everything works great except the program won't edit the body …

1. Write pseudocode to solve the following problem. (i) Declare an array nums that can hold 100 real numbers. (ii) Write pseudocode to load nums with 100 values, entered via the keyboard. Assume all data are valid. (iii) Write pseudocode to prompt for an integer target. Search array nums for …

How to replace string with variable in substring? btw im using vb I have a below query that work fine but I just want to replace "ra*" with a variable. How can I do this? SELECT DISTINCT a.[rank], b.Description FROM CONTAINSTABLE(myTable, *, '"ra*'") AS a INNER JOIN myTable AS b …

Hello, I am facing a very little problem but I am totally confused how to resolve it I have two tables in my access database which have similar items in it from the first table i.e **tbl_reci_inds** I have selected **reci_prod_code** which is a product code, also in this table …

I am trying to work the next and previous button to read or navigate throughrecords, please help me to correct this, I'm stuck here: Private Sub Button7_Click(sender As Object, e As EventArgs) Handles Button7.Click Dim k As Integer Dim i As Integer k = 1 i = k + 1 …

hello, i want to be able to separate the values in a textbox and display the separated values in different labels using a button this is what i want to happen: 1. input "Ac2O3" on textbox 2. Be able to separate "Ac", "2", "O", and "3". 3. show these separated …

I had 3 datagridview in visual basic, and each of them is linked to each other. 1 Main component can have many Failure Mode and 1 Failure Mode can have many Critical. [Click Here](http://i1333.photobucket.com/albums/w631/lloyd1006/1_zpsapbu0wla.png) [Click Here](http://i1333.photobucket.com/albums/w631/lloyd1006/2_zpsbe2c2u3n.png) [Click Here](http://i1333.photobucket.com/albums/w631/lloyd1006/3_zpsw2s2weo6.png) I want to duplicate selected row or record including their children details, …

Hi all, i am doing my project. i need one search box to find something i write in the box, how can i code that? its very important please help

Hello every one. i am trying to catch duplicate values from a data. in the picture when i want to add new record, then if the record already exists then go to that record and fill all the boxes, then i will press the update button,but if not, then add …

How can you write a macros that will loop until it finds a blank cell. Then, once the first blank cell is found do a vlookup to a set of data? It will be looping on the same row.

Dim DMC_No As New List(Of Integer) cmd.CommandText = "SELECT MC_No FROM tbl_MainComp WHERE EquipTag= '" & TextBox1.Text & "'" Using reader As OleDb.OleDbDataReader = cmd.ExecuteReader() While reader.Read() DMC_No.Add(reader.GetInt32(reader.GetOrdinal("MC_No"))) End While End Using Dim DFM_No As New List(Of Integer) For i = 0 To DMC_No.Count - 1 MessageBox.Show(DMC_No.Item(i)) 'This line to …

I have 3 table which are  I want to duplicate a record from the master table in the same time it will duplicate all children table. I will assign new primary key to the new duplicate record. For the tbl_System and tbl_MainComp work fine. But when i have …

Dim DB As New ADODB.Connection Dim rs As New ADODB.Recordset Dim RST As New ADODB.Recordset Dim adoConn As ADODB.Connection Private Sub Command1_Click() Adodc1.RecordSource = "INSERT INTO STUDATA(UserName,Password,Course, Gender,Country) Values ('" & TxtUn & "',' " & TxtPw & " ','" & ChkC.ischecked.tostring() & "','" & ChkCC.ischecked.tostring() & "','" & ChkJAVA.ischecked.tostring() …

Hello I have created a installer package of my project build in Visual Basic 6.0. I have using Advance Installer for making package. every thing works perfectly on other systems but a minor problem in my project i am facing which is very hard for me to resolve is I …

I am desgining a userform in ArcMap, but I don't know how to sum up numeric values in a textbox (txtBox1) in another textox (txtBox2). Can anybody provide me with a vba code for that!

I have a problem!! I am trying to convert pascal code to VB and am stuck. Pascal: TYPE Elements = SET of 1..255; Xpath = ARRAY[0..50] of BYTE; VAR Path0,Path1,Path2:Elements; Path:Xpath; So, Elements is defined as a base set of numbers 1 through to 255 (inclusive). Path0, Path1 and Path2 …

I am trying to make a program but I am stuck with something. I can't solve the problem of saving the contents of a form as a video file. Please help me with this.

Hi, Does anyone know how to have a dropdown appear when typing in a multi line text box? I want it to work in the same way it does in Visual Basic, suggesting what could be inserted based on what the user is typing. Thanks guys, Regards, Luke

Hi guys, ** Im an IT Intern Student here in the Philippines. they gave me a project which is File transferring, copy and delete. I started my OJT/Internship 3 weeks ago. and that entire week, all I have done is the design :( My professors in our university did not …

how to search a data in particular fields(ms access database) in vb6.0 using data1 control. I create a project in vb 6.0 using ms access data base and data control. I want to find a particular name from the data base table field. My code is.... If Data1.Recordset.Fields("C_Number") = Text15.Text …

Good day everyone. i have a vb6 program that attaches files in my database having an attachment field named ATTACHFILE. Saving files works fine but i cant upload/save file to a selected directory. I have the following code below . I was able to save it to my spcefied directory …

I am trying to develope a banking program using vb. But I've never seen one so I don't know what it looks like. Can somebody help out please??

hi everybody.. I'm implementing an interface in vb6. In that I'm creating dynamic controls like comboboxes, buttons etc. how can i identify a button click that is created dynamically. if the button is clicked, then only i can move to next stage.. i.e. i have to write code for that …

Hey guys, I'm teaching myself visual basic using the "Starting out with Visual Basic 2012" textbook and I'm having trouble with a two part programing challenge. I did the first part which was: *"An internet service provicer offers 3 subscriptions packages to its customers, plus a discount for nonprofit organizations …

the error i get from visual studio is `Number of query values and destination fields are not the same.` below is my insert statement "INSERT INTO tbl_ViewAll(EquipTag, S_Name, S_Function, S_Failure, MC_No, MC_Name, MC_Function)" & "SELECT EquipTag,S_Name,S_Function,S_Failure FROM tbl_System UNION " & "SELECT MC_No,MC_Name,MC_Function FROM tbl_MainComp"

Hi everyone, I'm new here. I don't know VBA and have been tasked with a VBA project for whatever reason. We have a recurring bug wherein a report we receive has semi-fake rows, causing all kinds of hell. The current logic I am attempting to execute should run as follows: …

Hello! I'm new to VB and I'm having trouble finding the correct formula for the Average Discount :'( Option Explicit Dim mcurExtendedPrice As Currency Dim mcurFifteenDiscount As Currency Dim mcurDiscountedPrice As Currency Dim mcurTotalDiscountGiven As Currency Dim mcurBookCount As Currency 'Declare module-level variables Private Sub cmdCompute_Click() Dim intQuantity As Integer …

hi all, I m developing a software in vb6 as front end and oracle 11g as backend (i.e. as database) I have desinged some reports with oracle reports builder, how i can call in vb6 program/how to add the oracle reports in vb6 programe. Thanks in advance for help.

hello there im doing a project and need help.. how to show auto-id from ms access table 2000 into vb 6 textbox?

Hello VB.net I don't know if I am in the right thread; but it is most closer to my problem; Currently I have no idea or a near code to solve the problem; In excel, Developers tab, there is a Visual Basic Application; What I'm trying to do is color …

Hello everyone, I am new to VBA and i would appreciate any help as i am pretty confused. I have imported some csv from a folder to different tabs. i need to calculate the average of the range A3:A7, then B3:B7 till E3:E7 and report their values on cells K7 …

I made a little app using access db in my computer, and also make an exe file of that. The db location is on c drive. Now i took only the exe file & and the db to another computer. I put the db in c drive there too. but …

In real life, what is the difference between C# and Visual Basic?. I want to make an application to handle data from a database and I was told that C# is much better, I need advice. Thanks in advanced. Waldis Portes

Hi, I'm trying to create cascading comboboxes, and my code isn't working. I've looked at other threads and I don't know why it isn't working properly. The first combo box displays System Names and the second combobox should populate the all Locations of that specific system chosen. When I run …

Hi all expert, Need help here. RS.Open "Select * From TABLE where Box_ID = '" & BOXID & "' Order By CASE_NO ASC", con1, adOpenDynamic, adLockOptimistic Set DataReport.DataSource = RS DataReport.Sections("section1").Controls.Item("Text1").DataField = RS("BOX_ID").Name DataReport.Sections("section1").Controls.Item("Text2").DataField = RS("LOT_ID").Name In my program i am able to printout the data field. But how can …

Hey guys. So I'm currently building an app and I'm having a bit of trouble. So I have an Excel file and it reads it and opens it fine(I imported microsoft.office.interops.excel but what I want to know is how to loop through column A and pick out the rows that …

hey guys i have a code for auto generation of id in my project... when i add another id the number repeats itself... i recently tried to change the code and then the save codeing didnt work... so i went back with the old one... a lil help pls... Dim …

hello friends, i need a help in vb6, i just start using vb6 for my project. my problem like this, i have two button, button Ok and Next. if i want to prevent user from move to next form before clicking on button ok..how should i put my coding??

Dear all I have combox accumated with 3 perameter Grid Connected PV-SYS- Full Feed In Grid Connected PV-SYS with Electrical Appliance -Net Metering Grid Connected PV-SYS with Electrical appliance ,battery system -Net Metering Each combobox value contain images.I used picture box to dispaly images. How to display the image based …

i have created a customer table containing name and ID in datsbase and i want if i type in the customers ID number lets say in a textbox, (1)it should check the database to see if the ID exist and (2)then call up the corresponding name with that ID and …

Dear all, Here i have attached form window.I wanted to update form with relative data How to refresh the single form. When New project detail is clicked from loaded with project data , when panel button clicked form loaded with panel data. 1)I tried this method. I created a group …

Does anyone use FreeImage with VB6?? I have used this combination quite a bit over the years, but am stuck on something that I can't get working. I want to open a jpg image, rotate it by 30 degrees (or whatever) and then paste the resulting image onto another image. …

Hi All, when i'm trying to call the dll i'm getting runtime error 91 error. below are my findings: 1) i'm able to build the dll without any error 2) i'm able to add reference to that dll 3) all intelesense is working 4) if i add that project to …

Hi. I'm currently developing a very simple standalone terminal EPOS software in VB6, as all the off the shelf products are way too complicated for the single shop its required for, but they want it barcoded to make it easier for them. Currently I'm stumped by one huge bit. It …