20,285 Topics

Member Avatar for
Member Avatar for kcvenkat87

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.......

Member Avatar for kvprajapati
-1
116
Member Avatar for coolheadedguy

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 …

Member Avatar for kvprajapati
-1
100
Member Avatar for murid
Member Avatar for jbennet
-1
73
Member Avatar for Baillie11

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 …

Member Avatar for TomW
-1
137
Member Avatar for realone

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 …

Member Avatar for sknake
-1
111
Member Avatar for yorro
Member Avatar for Ulukay

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 ?

Member Avatar for Ulukay
-1
103
Member Avatar for yorro

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") …

Member Avatar for yorro
-1
97
Member Avatar for yorro
Member Avatar for lil_Is

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

Member Avatar for lil_Is
-1
3K
Member Avatar for virtualmisc

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 …

Member Avatar for sknake
-1
85
Member Avatar for Atove

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 …

Member Avatar for sknake
0
94
Member Avatar for s.chauke

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 …

Member Avatar for s.chauke
0
525
Member Avatar for flit07

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 …

Member Avatar for flit07
0
106
Member Avatar for navinkumar

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. …

Member Avatar for navinkumar
0
109
Member Avatar for Skwerlz

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 …

Member Avatar for kvprajapati
0
130
Member Avatar for Skwerlz

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 …

Member Avatar for Skwerlz
0
178
Member Avatar for yorro

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 …

Member Avatar for yorro
0
175
Member Avatar for ITfav

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 …

Member Avatar for TomW
0
313
Member Avatar for Smalls

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 …

Member Avatar for Smalls
0
2K
Member Avatar for kabirieram

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 …

Member Avatar for SQL_dba
0
86
Member Avatar for leroi green

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] …

Member Avatar for leroi green
0
150
Member Avatar for Atove

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 …

Member Avatar for TomW
0
114
Member Avatar for wallance

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 …

Member Avatar for TomW
0
133
Member Avatar for babbu

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]

Member Avatar for TomW
0
391
Member Avatar for mansi sharma

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 …

0
48
Member Avatar for ChinnuBlr

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 …

Member Avatar for Geekitygeek
0
89
Member Avatar for Denxerator

[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 …

Member Avatar for Geekitygeek
0
241
Member Avatar for lil_Is

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 …

Member Avatar for babbu
0
146
Member Avatar for Anupama G

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?

Member Avatar for Anupama G
0
271

The End.