20,278 Topics

Member Avatar for
Member Avatar for julio.azevedo.562

I have a graph in my excel file. There is two values that changes this graph appearance, so I want to change these cell values in a FOR loop, in order to make a "animation". Is it work? Every step of the loop will change the graph, but how can …

Member Avatar for ddanbe
0
42
Member Avatar for Mr.M

Hi Dw I'm creating a program which I want to check if the normal and also a hidden folders exist or not and if exist delete it.

Member Avatar for fourty
0
210
Member Avatar for aabbccbryanmark_1

Private Sub txtPassword_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtPassword.KeyPress Dim NotAllowed As String = "~`@%^&+={[}]()!:,;'><?/|\-.#+()_$*" If e.KeyChar = ChrW(Keys.Enter) Then e.Handled = True End If If e.KeyChar <> ControlChars.Back = True Then If NotAllowed.IndexOf(e.KeyChar) = -1 = False Then e.Handled = True End If End If End …

Member Avatar for Atove
0
2K
Member Avatar for Start4me

I have a radio button and a listbox. After clicking on the radiobutton, a collection of items will be added into the listbox. I'm trying to go back to the collection I've started working on to edit a System.Collections.Specialized.StringCollection, but after running the program, the list of items has not …

Member Avatar for G_Waddell
0
349
Member Avatar for cascade001

what i am trying to do is make a program to read an excel file that i already have , choose certin columns depending on its header title then paste these columns into sheet2 . the problem is when i check for the columns i want to extract it gives …

Member Avatar for julio.azevedo.562
0
3K
Member Avatar for radium61

I am trying to bind data to my DataGridView. (However, this is the easy explanation.) Background on what I am trying to accomplish: I have a rather large program here. This part of the code uses a DataGridView to display the data I have read and parsed (from another program …

Member Avatar for radium61
0
2K
Member Avatar for alexander.andrew.7771

Hi , I want to make a program who read a word from a textfile . More accurate, In The text file I have the next text: Version="1.0" Adress="http://" StartFile="/" and my program I want to read what is From Version , to read 1.0 From Adress to read http:// …

Member Avatar for Reverend Jim
0
85
Member Avatar for mokushirokuxen

![7d2f0b828b7075213b3cc4ce79ce21d1](/attachments/large/4/7d2f0b828b7075213b3cc4ce79ce21d1.png "7d2f0b828b7075213b3cc4ce79ce21d1") i have 2 database listview1(from tbl_storage) listview2(fromsales) so i want my listview items and subitems to be increment or be loop correct me if im wrong with that. sellingprice and Qty.(Quantity) ex. itemno | name | qty| price | total | 1 | a | 1 | 100 …

Member Avatar for mokushirokuxen
0
449
Member Avatar for y0yie_333

i now able to save the fingerprint directly to database using this code... Dim fingerprintData As MemoryStream = New MemoryStream Template.Serialize(fingerprintData) fingerprintData.Position = 0 Dim br As BinaryReader = New BinaryReader(fingerprintData) Dim bytes() As Byte = br.ReadBytes(CType(fingerprintData.Length, Int32)) Dim cn As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=dataBEST;Integrated Security=True;Pooling=False") Dim cmd …

Member Avatar for abelingaw
0
465
Member Avatar for jared.geli

Hi guys I'm having a problem in opening excel files using the workbook.open for me to save all the changes made by oledbcommands. Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & path & "'; Extended Properties=Excel 12.0;") MyConnection.Open() Dim i = 0 Dim h = Label1.Text Do 'Dim q = …

Member Avatar for jared.geli
0
674
Member Avatar for Start4me

I have a list box, with an item "Math". When I click on the Math item, I want a new collection of items to be added to the listbox after removing the current Math item, and make a back button to appear to return Math item back in case I …

Member Avatar for Start4me
0
245
Member Avatar for Start4me

I'm trying to select items from the listbox when pressing Enter on the selected item. Here is what I have tried so far: Private Sub ListBox1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ListBox1.KeyDown Select Case e.KeyCode Case Keys.Enter ListBox1.SelectedItem = ListBox1.PerformMouseClick() End Select End Sub

Member Avatar for G_Waddell
0
372
Member Avatar for Start4me

When creating a new project, I have a list of Frameworks to chose from. I need a Framework which will allow my program from Bin -> Debug -> Program.exe to work on various computers, such as Vista, Windows 7 & 8, and perhaps any others of the Windows family. I …

Member Avatar for Minimalist
0
305
Member Avatar for danielagaba

Hi I've run this code and i get no errors but my form data is not saved on the dataset or database. This is the click event code. [code] Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDictionary|\TMSDB.mdf;Integrated Security=True Instance=True") Dim ds As New DataSet conn.Open() Dim Adp As New SqlDataAdapter("select * …

Member Avatar for jigar.makhija
0
963
Member Avatar for Paladine

Just got to playing around, and felt that the VB forum on here could use some posts. What I was playing around with forms in VB.NET and wanted to hard code centering a form. Here is what I found...and if anyone has an easier or slicker way...let me know. -in …

Member Avatar for dinesh.panjwani.98
1
7K
Member Avatar for christan

Greetings, Can someone please tell me on how to use this class? Public Function GetDataFromStoredProcedure(ByVal spName As String) As DataTable Dim ds As New SqlDataAdapter Dim dt As New DataTable Dim cmd As New SqlCommand Dim con As New SqlConnection(_connectionString) Try _success = True con.Open() cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = …

Member Avatar for christan
0
183
Member Avatar for Nkkinx

i've upgraded my vb.net application from visual studio 2005 to 2013 and and when i click to show a form which its windowstate is set to maximize , the form shows in design size and i need to open another form and go back to it to get it in …

Member Avatar for Minimalist
0
118
Member Avatar for LukeJWhitworth

Hello, I'm new here so sorry if this question isn't worded how they usually are but I can't figure out how to get vb to only display the dates of working days (Monday - Friday). I have got it to calculate days between certain dates (I thought that might get …

Member Avatar for Reverend Jim
0
182
Member Avatar for christan

Greetings, i just want to ask how to insert a data with fk. Like if i insert a data on tblPatient, the patientID will be displayed on the tblRecord. is it just a normal insert into tblpatient or is there another code for it? Thanks.

Member Avatar for G_Waddell
0
215
Member Avatar for cambalinho

i did an Empty project(bored... only problems :( ). but can i add a manifest file to exe or the project?

0
65
Member Avatar for on94

I have 2 form called form1 and form2 why i cannot use this code form1.textbox.Text = "Hello" ????

Member Avatar for G_Waddell
0
119
Member Avatar for y0yie_333

what's the problem with this ? any 1 can help me out..tnx in advance Dim filePath As String Try filePath = Application.StartupPath() & "\" & DBFile connection = New OleDb.OleDbConnection(ConnectionString & filePath) connection.Open() Dim command As OleDb.OleDbCommand = New OleDb.OleDbCommand command.Connection = connection '---set the user's particulars in the table--- …

Member Avatar for y0yie_333
0
152
Member Avatar for aaronernest.borres

Good day Can you please help me with my codes. My teacher tasked us to make a program that will accept a password from the input box then will show form1. Otherwise, it will repeat on asking for the correct password. the program will stop asking if you gave the …

Member Avatar for aaronernest.borres
0
208
Member Avatar for christan

Greetings, can someone please give me an idea on how to make a stored procedure with foreign key. Here's what i want to happen. 1) I have 1 button for Adding patient. 2) On the add patient button, i want to Add the patient information on the tblPatient and insert …

Member Avatar for christan
0
170
Member Avatar for Start4me

I have a listbox with items and a panel. What I want to do is when I click on an item, a label shows up in a panel, which was already there before the item was clicked. I've managed to show the label, but it didn't add to the panel, …

Member Avatar for Start4me
0
293
Member Avatar for dhimanbiswas4u

Get the image source of the below link which pass the condition **itemprop="image"** and **id="poster_image"** <img itemprop="image" id="poster_image" style="width: 300px; height: 442px; " alt="" title="" src="*This is the source.jpg*" />

Member Avatar for fourty
0
99
Member Avatar for poksmdpk

please anyone help, can anyone know how to search data in my form without any search button, i would like to search data once i automatically enter specific data in my form as a fast result, please?

Member Avatar for fourty
-1
160
Member Avatar for SkyInfinity

Dim checks As Double Dim Fee As Double Dim Q As Double Dim Initial As Double Initial = 10 Dim number1 As Decimal = 0.1D Dim number2 As Decimal = 0.08D Dim number3 As Decimal = 0.06D Dim number4 As Decimal = 0.04D TextBox1.Text = checks If checks >= 1 …

Member Avatar for fourty
0
146
Member Avatar for SkyInfinity

This is the problem I am working on ( you have likely seen it before) A bank charges $10 per month, plus the following check fees for a commercial checking account: $0.10 each for less than 20 checks $0.08 each for 20 through 39 checks $0.06 each for 40 through …

Member Avatar for Reverend Jim
0
274
Member Avatar for elouch

how can i paste result from excel formula to value or even store the result into a string below codes does not seem to works... For x = 2 To rowcount worksheet2.Range("B" & x).Value = worksheet2.Range("D" & x).Text worksheet2.Range("C" & x).Value = worksheet2.Range("E" & x).Text Next worksheet2.Range("C" & x).Value = …

Member Avatar for fourty
0
1K

The End.