Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~15.0K People Reached
Favorite Forums
Member Avatar for Noorul Ariff

Dear... I'm doing INVENTORY PROJECT... I'm using ACCESS as BACK-END... My tables are PURCHASE and SALES... In PURCHASE table, fields are CODE(primary key), PRICE, DATE, TOTAL, QTY... when I'm entering datas in form and when i click submit, the datas stored... but when i enter same DATA(CODE), it is showing …

Member Avatar for Steffany
0
8K
Member Avatar for Iamateur

I have added form1 and on it 2 text boxes. text box1 to accept fromdate and textbox2 to accept todate. After this,I added Crystal report from Add new Item. Then in Crystal report I added table and its columns. After that I wrote code behind form1. The code is not …

Member Avatar for Oheneba Kwadwo
0
2K
Member Avatar for kingsonprisonic

This module is for validating textboxes.... After using this module in your project you can simply validate all of your text boxes like [CODE] Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load AssignValidation(Me.TextBox1, ValidationType.Only_Digits) AssignValidation(Me.TextBox2, ValidationType.Only_Characters) AssignValidation(Me.TextBox3, ValidationType.No_Blank) AssignValidation(Me.TextBox4, ValidationType.Only_Email) End Sub [/CODE]

Member Avatar for Iamateur
4
1K
Member Avatar for fkatan

Hi, I use databinding.addnew() but when I try to type data in cell an error message apper(DBNULL Exception).... Pls let me konw: How can I insert or edit data in DataGrid Thanks

Member Avatar for harsh01ajmera
0
3K
Member Avatar for mie.ilani

how to get the current row after save and editing row. what code should be addded after this code below con.Open() a = strn.ExecuteNonQuery MsgBox("Updated") adap = New OleDbDataAdapter("select * from Parcel", con) adap.Fill(ds, "1") ParcelDataGridView.DataSource = ds.Tables("1")

Member Avatar for lolafuertes
0
97
Member Avatar for mie.ilani

Dim MaxVal As Integer For a = 0 To DataGridView1.RowCount - 1 If MaxVal < DataGridView1.Item(DataGridView1.ColumnCount - 1, a).Value Then MaxVal = CInt(DataGridView1.Item(DataGridView1.ColumnCount - 1, a).Value) End If Next MsgBox("The Optimum Value is " & MaxVal, 1, "Optimum Choice")

Member Avatar for mie.ilani
0
158
Member Avatar for mie.ilani

anyone can help? i want to check whether the data has been exist or not. but its shows some error in this code. error :No value given for one or more required parameters. Public Sub doSave() Dim con As New OleDb.OleDbConnection(My.Settings.KK3DB) Dim cmd As New OleDb.OleDbCommand Dim adap As New …

Member Avatar for mie.ilani
0
107
Member Avatar for mie.ilani

anyone can help me? my login doesnt work smoothly. i want to login based on Username, Password & Category. So that, if the user is Admin all data can be access, while if user is Staff, only few data can be access. Public Sub DoLogin() Dim strsql As String Dim …

Member Avatar for mie.ilani
0
127
Member Avatar for mie.ilani

Hye, i got problem while saved the record. here is my code. Imports System.Data.OleDb Imports System.Data Imports System.Configuration Public Class Form2 Shared STAFF As Form2 Function GetInstance() If STAFF Is Nothing Then STAFF = New Form2 ElseIf STAFF.IsDisposed Then STAFF = New Form2 End If Return STAFF End Function Private …

Member Avatar for poojavb
0
126
Member Avatar for mie.ilani

i have problem with query the database. i want to add data into two table that share same Primary key. here my code error message :The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the …

Member Avatar for Reverend Jim
0
223
Member Avatar for mie.ilani

need help! Public Sub emailNotification(ByVal strTo As String, ByVal strFrom As String) Try If strTo Is Nothing Then MessageBox.Show("Please Check Email") Else Dim [to] As New MailAddress(strTo) Dim [from] As New MailAddress(strFrom) Dim message As New MailMessage([from], [to]) message.Subject = "Parcel Info No: (" + txtTracking.Text + ")" message.Body = …

Member Avatar for Oxiegen
0
156
Member Avatar for aminevb

I can't add infromation to my Projet.mdb ! please help me ! this is my code Try Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = C:\projet.mdb" Dim Save As New OleDbCommand Dim Conn As New OleDbConnection(ConStr) Save.CommandText = "INSERT INTO Client(Nom,Prenom,Adresse,Téléphone,date) VALUES(@p1,@p2,@p3,@p4,@p5)" Save.Parameters.AddWithValue("@p1", TextBox1.Text) Save.Parameters.AddWithValue("@p2", TextBox2.Text) Save.Parameters.AddWithValue("@p3", TextBox3.Text) Save.Parameters.AddWithValue("@p4", …

Member Avatar for Begginnerdev
0
89
Member Avatar for bigzos

Hey guys,I have an excel sheet with one of the columns as name .There are many rows with same name and I wish to mail all the rows with same person name to that person(given there is a column specifying email address).I will be thankful for your suggestions. The following …

Member Avatar for bigzos
0
96