20,285 Topics
![]() | |
hi....tell me hw to do add any date field to ms access using vb.net. i'm created ms access database field date/time datatype but can't add records to database,. how to get system date without time in vb.net....... | |
I am currently working on my final year project and i researching into building an Information system with SQL as database and ASP.Net as an interface? I just want to know if VB6 has the capabilities of been used as a tool to develop an Information system, integrating SQL and … | |
is it possible to run vb program without installing vb ??? if it possible, how it work ??? thanks... | |
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at various times. What I would like to do is bring in an entire table and then query the row(s) i want as I need them. This is what I … | |
pls i need to call a private sub from another private sub.i.e calling dgrid_cellclick from del_click with the sender and e parameters [code]Private Sub Dgrid_Cellclick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles Dgrid.CellClick Dim i, j As Integer i = e.RowIndex j = e.ColumnIndex If (Dgrid.Item(0, i).Value) Then TextBox2.Text … | |
How do you return multiple values in a function? | |
I want to make a hardcopy at runtime of my active form like this [CODE]PrintForm1.Print(Me, PrintForm.PrintOption.FullWindow)[/CODE] It Prints , but i cant get the printer to rescale the screen to fit on one A4 Does anyone knows how to make the screen fit on the page ? | |
My App edits data on a listview, by clicking on a row then clicking the edit button btnEdit. [CODE=vb] Dim PrimaryKey as String Private Sub ListView1_MouseDoubleClicklstSearch.MouseClick With .SelectedItems(0) PrimaryKey = .SubItems(0).Text End With End Sub Private Sub btnEdit_Click If ListView1.SelectedItems.Count > 0 Then ' Show dialog box Else MsgBox("Select First") … | |
Hi all, I am doing a simple application which is to create a register form which I am not quite sure. To stored the data, I am using the MS Access. Hope that anyone could help me. Thanks Regards LiL_Is | |
I have a file which should contain only numeric data. Sometimes, i notice that junk characters or some alpha chars coming in the file. I want to write a script which would delete those unwanted characters and give me only those numbers. It would be better if i could copy … | |
Hi all! I'm trying to create search criteria for searching my sql server database. It selects the correct data when you select an option to search by; however i'm trying to make it so that if nothing is selected in an option it selects all data. the code i'm using … | |
Public Sub ValidateID(ByVal IDno As String) Dim a As Integer = 0 For i As Integer = 0 To 5 a += CInt(ID.Substring(i * 2, 1)) Next Dim b As Integer = 0 For i As Integer = 0 To 5 b = b * 10 + CInt(ID.Substring(2 * i … | |
Hi, I'm trying to change the button backcolor once the Done event is completed. But it didn't work.. [CODE] Public Event Done() Private Sub checkinput() 'Port = ReceivedString.Split("&") 'For i = 0 To UBound(Port) 'Debug.Print("Port: " + Port(i)) 'Next i RaiseEvent Done() End Sub Private Sub changecolor() Handles Me.Done RD6.BackColor … | |
When we run a program and if the program is having a error...then we a popup message saying that there is a error in ur program.... The error message has a option of "Dont Show this message next time" I have enabled the Dont show me error message next time. … | |
Right away, Im fairly new to vb.net. Is there a way to have a local db cache that will use a connection string saved in settings? IE: program obviously has a central db remote computers will sync with when connected. can I save the connection string in the program settings … | |
This may seem like an easy question, but I am new to vb and though I have searched and searched I have come up empty. What I am trying to do is create a piece of software that will give users access to certain things based on their level. almost … | |
I received this error whenever I update an int(3) type field. [B]Error: 438 public member close on type integer not found[/B] This is my code [CODE=vb] conn.ConnectionString = "server=localhost;user id=root;password=;database=test" SQL = "UPDATE testTable SET int = 1 WHERE Name= 'Bob'" Try Dim myData With myCommand .Connection = conn .CommandText … | |
Basically what I want is to have the timer be reset back to 3 sec once the [COLOR="red"][B]Reset button[/B][/COLOR] is clicked. Preferably, I want the code to be in the same sub as the timer, though any better ideas are most welcomed. I've already put in comments where i want … | |
the idea of what i want to do is to display the cpu temperature in a label that will refresh through a timer. i have search several sites including this one that do have the code and how to do it, but then my problem is that several items are … | |
Hi everyone. I am pretty new to Visual Studio .NET and would love to use it. I can understand most of the coding syntaxs in VB. Currently I dont know where to start using VB .NET. Anyone who can help me show me a bit of a highlight where to … | |
hey all, i'm working on a code that i want to start creating new classes with but i want to know if there's a more direct way to send the variables used in the form to a new class for storage. for example i've got this on a form... [code] … | |
Hi all; I'd be really grateful if someone could assist me with this problem. What i am trying to do is create a query that pulls information from two different tables: tblBooking and tblConcessions. tblBooking holds the ID number of tblConcessions as a ForeignKey. What i need within my statement … | |
Hi, I am creating an Excel 2007 add-in using Visual Studio 2008 and I have a Windows Form that allows a user to select a date. What I want to do is store that date in the Workbook that the user saves so that the plug-in can reference that date … | |
m using access 2007 and vb 2005 this is my code [CODE] Dim drNewRow As DataRow = m_DataTable.NewRow() drNewRow("Code") = txtColourCode.Text.Trim drNewRow("Colour Name") = txtBaseColour.Text.Trim drNewRow("Price") = txtPrice.Text.Trim m_DataTable.Rows.Add(drNewRow) m_DataAdapter.Update(m_DataTable) [/CODE] | |
1) What are the benefits of using Class Library? Secondly tell me one thing, I was asked in one of my interviews.Different types of cursors?? As u all know, cursors are of diff types in ADO,RDO,DAO??? So which answer to give???? Do I all have to know all the cursor … | |
Hi, I am facing prblm in selecting compbobox... I have a 2 combobox...cboxSelunits and cboxseldept In selected index change of Cbxunit i am filling CbxDept..... and in selected index change of cboxseldept i need to populate the treeview ----------------------------------------------------------------------- Private Sub cboxSelunits_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … | |
[code]Public Class Form1 Private Sub Button1_Click(ByVal sender As _ System.Object, ByVal e As System.EventArgs) - Handles Button1.Click Button1.Text = "Hello World" End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub End Class[/code] The name of the button isn't changing to Hello World... Anyone … | |
Hi all, I have a program that need to insert the data to the database. In the form, I have 5 textbox control which required the user to insert the data in the database. To create this, I am using the visual studios 2005 and sql server 2005 for the … | |
Hi I am working on a page which requires the grid to be populated with 'n' number of rows, as the user enters the number 'n' in a text box. Can anyone help me out in this? |
The End.