20,284 Topics
| |
hi everybody i need some code for auto inncrement in msaccess database file and in form textbox and if we add any data the number should increment automatically please help meee thanks in advance | |
Hey guys I'm really stuck in this very urgently needed solution, been working for 3 weeks plus and still can't come up with a working solution! Help needed asap. [U]ISSUE:[/U] The problem is simple. I have 2 PCs. One is 'master', second is 'slave'. On 'master', I have my .NET … | |
Hello, I’ve just about scrambled my brain on this, searching and trying things, so I’m hoping someone sees something that I’m missing or can explain it to me. I’m new to .NET, used to do a lot of programming in VB but that was many years ago. I mainly lurk, … | |
I use Visual Basic 2008 I had this code in Visual Basic 6.0 that the replace the ASCII value of [COLOR="Red"]decimal point [/COLOR]for the ASCII value for a [COLOR="red"]comma[/COLOR][CODE] Private Sub Text1_KeyPress(KeyAscii As Integer) If KeyAscii = 46 Then KeyAscii =44 End Sub [/CODE] But this does not work Visual … | |
Hi Everyone, I'm using MS Access as the database and using a command builder. .GetInsertCommand get the correct insert command text but .GetUpdateCommand gets the wrong command text. It even returns a primary key value of 1 which is not the actual value it should be. In order to get … | |
Dear All , I have a binary file , the defincition of its content is as below L Here is one of my 'log items' from the data.bin, all data is stored in little endian (ie. least significant byte first) 11 63 39 46 --- Time, UTC in seconds since … | |
[CODE]If strCardNum.Length <> 5 Then MessageBox.Show("Please enter a 5 numbers.", _ "Georgetown Credit", _ MessageBoxButtons.OK, MessageBoxIcon.Information) ElseIf Not (Integer.TryParse(strCardNum.Substring(0, 1), intNum1) _ OrElse Integer.TryParse(strCardNum.Substring(1, 1), intNum2) _ OrElse Integer.TryParse(strCardNum.Substring(2, 1), intNum3) _ OrElse Integer.TryParse(strCardNum.Substring(3, 1), intNum4) _ OrElse Integer.TryParse(strCardNum.Substring(4, 1), intNum5)) Then MessageBox.Show("The card number entered is not number") Else … | |
I am on a visual basic mysql project Here is the code : [CODE]Imports MySql.Data.MySqlClient Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As MySqlConnection conn = New MySqlConnection conn.ConnectionString = "server=db4free.net;Port=3306;user id=****; password=****; database=ume_corporation" conn.Open() Dim myadapter As New MySqlDataAdapter … | |
I have this rather stupid litle excel issue which somehow just doesn't go away by itself; I'm creating a excel chart from three rows of information data. Each row has a header, so far so good. The first row exixt of calender data and I planned it to use them … | |
Dear All , The question is quite simple for all of you . I have a binary file . A description for this file says that : "first 2 bytes in the header is the number of records" I have opened this file and loaded it into bytes by this … | |
I use Visual Basic 2008 I use Datagridview with column "verkoopprijs" I want comma instead of decimalpoint My problem is this 25[COLOR="red"][B].[/B][/COLOR]25 to fill column as decimal point in column "verkoopprijs" the system automatically adjusted to [COLOR="Red"]€ 2,525.00[/COLOR]. This is not okay 25[COLOR="Green"][B],[/B][/COLOR]25 as fill in column with comma in … | |
Hy guys as mentioned before on my threads I'm a self teaching person learning VB. I' sucessfully created a project fully functional using access database. I've read about SQL connection on VB .net. But I'd apprecite a help to have some one guiding me step by step on how to … | |
Hi, My code is pretty much complete. I just need help in 2 things 1) When the program runs the 0 appears, which is fine, but when I type/write a number the Zero would continue next to the number i type/write 2) When i make an operation, such as add/divide/multiplication … | |
I have two forms (Form1 and Form2) which appear side by side. I want to "tie" them together, IE, you drag form1, and form2 follows it. I was thinking of using the Me.LocationChanged Event, but before I do that, I'm wondering if I'm overlooking a native way to get the … | |
Hi Guys please I need your help. I'm creating this small application that will control some equipments based on its bar code and the owner picture. everything is working fine, except the picture. is there a way to save image to access database using ADO Connections and\or recordsets? I've head … | |
hi guys... i can connect now to the mysql database and is able to display the database names (because i have 3 databases) in a combo box.. i was stuck up in displaying tables from mysql in a listview.. please help me solve this.. here are my codes: [code] Public … | |
hello my first thread to as for something here but i like daniweb a lot i'm trying to save data from listview to sql server [CODE] Dim iCount As Integer Dim iLoop As Integer Dim query3 As New SqlCommand Dim lvitem query3.Connection = New SqlConnection("Password=sasa;Persist Security Info=True;User ID=sa;Initial Catalog=Tel;Data Source=HA-PC") … | |
i have this insert code that is refusing to work it is giving me error 26: something to do with the network or connection. i am using sql express 2005 and vb.net 2008 any help will be greatly appreciated [CODE]] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT … | |
I have this litle problem: I have inserted a lot of data into a excel form. After that I wish to do a bit of sorting and all that stuf before I actually create a chart. So I used the subtotal routine. Somehow this routine ignores my first row of … | |
I have a RichTextBox where part of the RichTextBox is Bold and the rest is not. If I do a SelectAll, the SelectionFont member doesn't get set. Anyone know why? In WordPad, with the identical Font and bolding set on part of the text, the SelectionFont appears to get set … | |
In the following code, a selection in excel is selected. All of this information is then transfered to The DestFile. In this case the DestFile is Firm_ATC0.asc. I would like the program to put all the information from the A colum in the Firm_ATC0.asc file, and all the information in … | |
Last week, Microsoft released a set of tools for developing software for the new Windows Phone 7 using Visual Basic. In order to use the tools, you have to have Visual Studio 2010 Professional or better (right now the Express versions don't work, although I've heard that will change). But … | |
Dear All , I have a device with upon serial communication , it send the data as HEX values , (eg, C020042ABD0F91A103E400F929EBC) . I use the following code to get data from the serial port. [code] Dim fStream As New FileStream(sFileName, FileMode.CreateNew) ' creates new file Dim bw As New … | |
Hello all, I have an app that I've developed that has a vb.net front end and a SQL Server 2000 database backend. I currently have it running fine on my machine and it also installs fine on all the users that are inside the domain that the app was written … | |
[code] Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.Data.SqlClient.SqlConnection Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Inherits System.Windows.Forms.Form Dim myConnection As New SqlConnection Dim myCommand As New SqlCommand Dim ds As New DataSet Dim cmdtext As Integer Dim action As String Dim view As DataView Dim dr … | |
Hi All, I want to transfer a html file generated by my VB application to my account in Unix Server, please let me know if this is possible and if yes, how can I achieve this? Thanks in advance! | |
So I have problem with a code I am writing, when I write a string to a text document, I get the following error; "Conversion from string "1, 1, 2, 3, 5, 8, 13, 21, 34, 55" to type 'Integer' is not valid." Please help; code below. Thanks in advance! … | |
I'm having some problems with the UPDATE statement in VB.NET. Not the UPDATE statement directly, but when it comes to incrementing a field's value by 1. Below is the code that I'm using for writing to the database, as well as the two UPDATE SQL statements that I've tried. Any … | |
Hi Everyone, Can you look at this code because I am sure I'm missing something. I am trying to reset a Dataset. I have a form that has 1 text box and has 2 queries that locate the data. One is by customer ID and the other is by customer … | |
I was able to find a few different threads that talk about using Excel in VB.net, but none seem to help me. Here is what I'm trying to do... I do not want the standard excel toolbar to be usable. I have a form that opens an excel file with … |
The End.