ive been develop a project known as ordering system i need to delete data from db by clicking the button ive follow a tutorial from utube and to the exact same code he been used error "object reference not set to an instance of an object" ive double check my db dan the code in vb, there nothing wrong i hope some could help me code used for db : Private Sub Delete(id As String) Dim str As String = "server = localhost; userid = root; password = 1234 ; database = kedaikopimamba_db" Dim MysqlConnection As New MySqlConnection(str) MysqlConnection.Open() Dim …

Member Avatar
Member Avatar
+0 forum 6

I'm working with VB.net 2010. I need an windows form where i can select scanner's connected to my pc and then scan image and save it by a save dialogbox.... Waiting for help.....

Member Avatar
Member Avatar
+0 forum 7

Dim Values As Range Dim CurrentSheet As Worksheet Set CurrentSheet = ActiveWorkbook.ActiveSheet Set Values = Rows(5) For j = 0 To 20 For i = 1 To Values.Cells.Count - 1 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=Delimit2!$A$" & i, Formula2:="=Delimit2!$B$" & i Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font Color = -16383844 TintAndShade = 0 End With With Selection.FormatConditions(1).Interior PatternColorIndex = xlAutomatic Color = 13551615 intAndShade = 0 End With Next i Next j In this I code, I would like to increment column A to C and B to D after For loop of i gets over.

Member Avatar
+0 forum 0

Hello, I wrote some codes for student login. the codes checks for the "username", "password" as well as their type of "status", from the database. once this input are met, the student logs in successful, otherwise a message pops up. The problem i encountered is this, i have 11 student records in my database and only the first 6 students can login successfully. the remaining 5 students cannot login. Despite entering the correct username, password and status for the last 5 students in the database, the message "Invalid username and password" comes up. I don't know where my code went …

Member Avatar
Member Avatar
+0 forum 4

Hi, i'm using vb.net and i have connected a database to it. As per my interface i should add, delete,go back,go next and save my records. All the buttons work apart from delete. The problem is i do not know the codes for deleting a particular record during the run time, can anyone help me out with the codes and steps of deleting a particular record.

Member Avatar
Member Avatar
+0 forum 14

My application is developed in visual basic 6 and oracle 11g express is its database. Now we need to make it available on our network for multiple users to use it simultaneously. How can I configure it for the same. What is the procedure to make my application a networked multi user app. What installations should I do on other systems. Should I make a “setup” of my app to install on each system? And further more how the connection between the app and database will be created? Thanks.

Member Avatar
Member Avatar
+0 forum 2

Hi im im trying to get attributes from two diffrent tag names.. <img class="chimg" alt="SOME TEXT" src=" #1 IMAGE LINK TO GET"/> <span>" #2 TIME TO GET" </span>" SOME TEXT "</a> </h3> <div> <a href=' #4 LINK TO GET' onclick="window.open('Some link'); return true;" title=' #3 TITLE TO GET' >SOME TEXT</a> I WANT TO PUT THESE IN ORDER FOR EACH LINK DataGridView1.Rows.Add(""IMAGE LINK"", ""TIME TO GET"", ""TITLE TO GET"", ""LINK TO GET"" ) this is what i have so far Dim ElementCollection As Windows.Forms.HtmlElementCollection ElementCollection = WebBrowser1.Document.GetElementsByTagName("a") For Each curElement As HtmlElement In ElementCollection DataGridView1.Rows.Add(curElement.GetAttribute("title"), curElement.GetAttribute("href")) Next Please help..

Member Avatar
Member Avatar
+0 forum 1

Hi, im using vb2010 with MS Access 2013. I have this form that displays ID values from database into a listbox And when an ID is clicked the details that correspond with that ID are displyed into textboxes. Screenshots : Forms : http://imgur.com/a/NrTTD Display details : http://imgur.com/a/twF7P The delete button does delete the data from database but im having trouble with the form as when the data is deleted the "deleted" data is still displayed on the form. How do i refresh the forms so it does not display the deleted data after deletion? Delete Button Private Sub btn_delete_Click(ByVal sender …

Member Avatar
Member Avatar
+0 forum 2

hi, I have an excel sheet and the is a row filled with data the row starts from B5 everytime, what i want to do it to read the values of the cell until the row comes to an empty cell how do i do it, thanks appreciate a reply, thanks

Member Avatar
Member Avatar
+0 forum 13

Is there any way possible to display a slideshow of pictures on a vb 6 form? What steps are required? Thankyou

Member Avatar
Member Avatar
+0 forum 10

Hi Group, I've imported an existing form into a new project that I'm creating (using Visual Studio 2015 Express/VB.net). When displaying the "Design" version (the user interface), it looks like a plain form and doesn't resemble the actual form in the original program. As per the directions, I added the existing item through the Solutions Explorer (Add > "Existing Item"). I added the programName.Designer.vb programName.resx programName.vb Where did I go wrong? What am I missing? In advance, thanks for your help. Don

Member Avatar
Member Avatar
+0 forum 1

I wish to print invoice using printer.print method ( using USB dot matrix printer in continous paper) Some invoice contain 6 lines, some 15 lines. Now afer printing 5 lines printer ejectng paper. so paper waster ( paper width 5 inches, continous paper). I wish to top printing after printing invoice without ejecting paper. i am using 'Printer.Height 'Printer.Width property but no use ? please suggest me to overcome the problem

Member Avatar
Member Avatar
+0 forum 3

Hi Dw. Firstly I would like to ask if there is anyone know a good download link to download VB6.0 I'm in need of this IDE. Now coming to my actual question of how to detect USB insertion and removal and get a drive letter for it in VB5.0? Thank you Dw.

Member Avatar
Member Avatar
+0 forum 1

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 ON a[key] = b.ID ORDER BY a.rank desc; Below is what I tried so far but it doesnt work. it treat as '"ra"' and not '"ra*"'. Any idea how can I fix this? Dim mkey As String = "ra" Dim query As String = "SELECT DISTINCT a.[rank], b.Description FROM CONTAINSTABLE(myTable, …

Member Avatar
Member Avatar
+0 forum 1

Hie someone please tell me from which site we can download vb.net software either 2008 or 2010?

Member Avatar
Member Avatar
+0 forum 4

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 button click. can anybody please help

Member Avatar
Member Avatar
+0 forum 1

Hi. I have to do a MVC project and I don't know exactly how to do it. on the clientside I will have an input form the data (at least two codes and up to 8) will be sent to the server (best way?) then the server will access a database and run a series of algorithms (i already have the code in **vb** from a previous windows forms app) and return 5 to 10 objects (numbers and strings) to the client which will display the results on a different view depending of the result. **can anyone make a quick …

Member Avatar
Member Avatar
+0 forum 2

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 my application, the first combobox populates without any duplicates just as it shoud but when I select a System Name from it, the location combo box populates just one entry and doesn't allow a drop down of all the other location names. Here's my code: [CODE] '---Form_Load Dim con As …

Member Avatar
Member Avatar
+0 forum 3

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 are equal to "USA Hawaii". And then out of those rows I want it to pick out the rows in column B that say "7". And then out of those rows I want it to pick out the row that says "58". I was going to use and If statement …

Member Avatar
Member Avatar
+0 forum 2

I need some help created a google weather api using vb .net. I found the code online and there are no errors. Problem is that I can't seem to display wether information. Nothing shows up on screen and I am not sure what I did wrong. any ideas? Imports System.Net Partial Class UI_MasterPage Inherits System.Web.UI.MasterPage Protected Sub SearchIB_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles SearchIB.Click Dim WeatherData As New Weather.WeatherInfo_Typed WeatherData = Weather.Grab_Weather("texas") temp.InnerHtml &= WeatherData.location & "--" & WeatherData.forcast_date & "--" & WeatherData.checked_time_date & "--" & WeatherData.humidity & "--" & WeatherData.forcast_date End Sub End Class <Runtime.CompilerServices.Extension()> Module …

Member Avatar
Member Avatar
+0 forum 1

I am new at vb .net and I want to know how to make website in it? like connect two papes or using header in different file and linking it together etc.. for some reason when I create a page than vb studio automatic adds a form tag and creates two files(aspx and aspx.vb files). I am not sure if I need aspx.vb when making websites. # header.aspx # since menu is always same in all pages. it would be good idea to put the code in different file and include when you need it. <html> <body> <form...> <div> <% …

Member Avatar
Member Avatar
+0 forum 1

I would like to assign a CTRL Q shortcut to the Quit submenuitem (filesubitem1) but can't find the right syntax. Any assistance will be greatly appreciated. Thank you. If user_wants_file_menu = True Then Dim fileItem As ToolStripMenuItem = New ToolStripMenuItem("File") Dim filesubitem1 As ToolStripMenuItem = New ToolStripMenuItem("Quit") filesubitem1.ShowShortcutKeys = True filesubitem1.ShortcutKeys = Shortcut.CtrlQ 'this errors at compile time fileItem.DropDownItems.Add(filesubitem1) menustrip.Items.Add(fileItem) AddHandler filesubitem1.Click, AddressOf QuitToolStripMenuItem_Click_1 End If

Member Avatar
Member Avatar
+0 forum 2

I have a linq statement where i turned letter grades into numbers to calculate a gpa can anyone tell me why no matter what grade i click i get the same gpa of 68 for each one? maybe someone can look over my code and give me an answer or hint thanks Private Sub btnDisplay_Click(sender As Object, e As EventArgs) Handles btnDisplay.Click Dim dic As Dictionary(Of String, Integer) = New Dictionary(Of String, Integer) dic.Add("A", 4) dic.Add("B", 3) dic.Add("C", 2) dic.Add("D", 1) dic.Add("F", 0) Dim gpa = Aggregate Grade In CoursesDataSet.tblCourses.AsEnumerable() Select Grade.Field(Of Integer)("CreditHours") * dic(Grade.Field(Of String)("Grade")) Into Sum() MessageBox.Show("GPa:" & …

Member Avatar
Member Avatar
+0 forum 3

need to code a linq statement that codes the grade display button so it allows the user to display either all records or only records matching a specific grade. Also it has to calculate a gpa where a=4 b=3 c=2 d=1 f=0 My main problem is with a linq statement how do i define grade into an integer? This is what I have tried so far: Private Sub btnDisplay_Click(sender As Object, e As EventArgs) Handles btnDisplay.Click Dim GPA As Integer = Aggregate CreditHours In CoursesDataSet.tblCourses Select CreditHours * Grade Into sum() MessageBox.Show("GPa:" & GPA.ToString("C2"), "College Courses", MessageBoxButtons.OK, MessageBoxIcon.Information) End Sub …

Member Avatar
Member Avatar
+0 forum 1

Hi guys, I need help with some homework... hopefully this is the right forum. So my last project assignment is making a shopping cart and having the user add, remove items therefrom. I am having a problem adjusting the totals after the items get removed from the cart: Using Lists to show items in cart. Structure Item Public strItemName As String Public dblPrice As Double End Structure Public Sub frmMain_Load(sender As Object, e As EventArgs) Handles Me.Load itmItem(0).strItemName = "The War" itmItem(0).dblPrice = 10 itmItem(1).strItemName = "Radio One" itmItem(1).dblPrice = 15 While intNum <= 2 lstItems.Items.Add(itmItem(intNum).strItemName) intNum += 1 End …

Member Avatar
Member Avatar
+0 forum 3

I've managed (over a very long time) to write a program in VB using Visual Studio 2008. This program is now published to my website and works well. Probably because people shy away from downloading and running .exe files or due to lack of my understanding of search engines, I don't appear to have had much interest. I have now decided to convert it to an Android and then, if I can manage to master Android, possibly to iOS. Having made a start within Android Studio I am finding it very difficult and wondered if I'm missing anything. I have …

Member Avatar
Member Avatar
+0 forum 3

By means of Mates8, graph coding becomes a bit easier. The web page has four textboxes so the figure gets bounded to the left, right, top and bottom; and a draw button. Additionally, a panel control will contain the image generated by the code after the button is pressed.

Member Avatar
Member Avatar
+0 forum 5

Think that macro viruses written in VBA (Visual Basic for Applications) are just something that people using the Internet a couple of decades ago had to worry about? Think again. Word macro attacks never went away, they just went into decline. New evidence suggests they could be making something of a comeback though. Coupled with research showing how non-English speaking recipients are being targeted by phishers using this technique, it makes for worrying reading some 15 years after [Melissa](http://en.wikipedia.org/wiki/Melissa_%28computer_virus%29) struck fear into the email using world. Whenever I hear non-English and phishing uttered in the same breath, I tend to …

Member Avatar
Member Avatar
+1 forum 2

Hi Team, So I am working on this project where I have 5 comboboxes that loads data from an .accdb file and Displays the result as per selection in a Text Box. I need to add Timers(as many as Required) to capture the Text-Box Data **"10 seconds After"** the fifth combobox option is selected. Please Help!

Member Avatar
Member Avatar
+0 forum 1

Hi Team, I'm stuck with my code and I found out this snippet to save(Export) an Excel file to **D:**. However, I would like to give a User an option to save it according to his/her necessity. Please find the Code Snippet below: Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Try If ComboBox1.Text = "Select a Month to Proceed" Then MsgBox("Bad Selection. Make a choice by Selecting a Month first") Else 'Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\msv\MSVDB.accdb;Persist Security Info=True;Jet OLEDB:Database Password=hdAI##^1939") If cn.State = ConnectionState.Open Then cn.Close() End If cn.Open() cmd.Connection = cn cmd.CommandText = "SELECT (EmpID)as …

Member Avatar
Member Avatar
+0 forum 1

The End.