Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

Exclusively for Visual Basic 6.0 Programmers Only!

mga ka-SB ask ko lang kung paano mag load ng Picture nagaling sa "ComboBox" ang value... Ginagamit ko yung string na LoadPicture, pano ko ba sya i-combine sa ComboBox..

Di ko msyadong magets tol, paki linaw or screenshot po tol
 
need help po sa project

pahelp po ndi ko kc malaman kung anong kulang ko d2.. kelangan daw kc n kpag nag add ako ndi daw tatanggapin ng program kpg may blank n field.

e2 po codes:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String

Private Sub cboAccountType_Change()
cboAccountType.Clear
cboAccountType.AddItem "Admin"
cboAccountType.AddItem "User"
End Sub

Private Sub cmdAdd_Click()
txtUsername.Enabled = True
txtPassword.Enabled = True
txtConfirmPass.Enabled = True
cboAccountType.Enabled = True
txtUsername.SetFocus

cmdAdd.Enabled = False
cmdSave.Enabled = True
cmdCancel.Enabled = True
End Sub

Private Sub cmdCancel_Click()
txtUsername.Enabled = False
txtPassword.Enabled = False
txtConfirmPass.Enabled = False
cboAccountType.Enabled = False

cmdAdd.Enabled = True
cmdSave.Enabled = False
cmdCancel.Enabled = False
End Sub

Private Sub cmdSave_Click()
sql = "SELECT * FROM tblUserAccounts WHERE Username = '" & txtUsername.Text & "'"
Set rs = New ADODB.Recordset
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

If rs.RecordCount > 0 Then
MsgBox "Username already taken."
Else
rs.AddNew
rs!UserName = txtUsername.Text
rs!Password = txtPassword.Text
rs!AccountType = cboAccountType
rs.Update
rs.Close

Set rs = New ADODB.Recordset
sql = "SELECT * FROM tblUserAccounts"
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

Set DataGrid.DataSource = rs
rs.Requery

txtUsername.Enabled = False
txtPassword.Enabled = False
txtConfirmPass.Enabled = False
cboAccountType.Enabled = False
txtUsername.Text = ""
txtPassword.Text = ""
txtConfirmPass.Text = ""
cboAccountType.Clear

cmdAdd.Enabled = True
cmdSave.Enabled = False
cmdCancel.Enabled = False

End If
End Sub

Private Sub Form_Load()
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Database\dbEnrollment.mdb;Persist Security Info=False"
cn.Open
cn.CursorLocation = adUseClient

Set rs = New ADODB.Recordset
sql = "SELECT * FROM tblUserAccounts"
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

Set DataGrid.DataSource = rs
rs.Requery

End Sub
 

Attachments

  • asd.bmp
    697.6 KB · Views: 7
mga sirs patulong naman po sa prob ko..

search button po ung ididisplay sa txtbox ung datas galing sa database..
di ko kasi maintindihan ung sample ni sir eric!! newbie plng kc ako..

sana po matulungan nyo ko
gusto ko po kasi talagang matuto..
 
Re: need help po sa project

Private Sub cmdSave_Click()
if txtUsername.Tex = "" or txtPassword.Text = "" then
Msgbox "Please fill-up all fields"
Exit sub
end if

sql = "SELECT * FROM tblUserAccounts WHERE Username = '" & txtUsername.Text & "'"
Set rs = New ADODB.Recordset
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

If rs.RecordCount > 0 Then
MsgBox "Username already taken."
Else
rs.AddNew
rs!UserName = txtUsername.Text
rs!Password = txtPassword.Text
rs!AccountType = cboAccountType
rs.Update
rs.Close

Set rs = New ADODB.Recordset
sql = "SELECT * FROM tblUserAccounts"
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

Set DataGrid.DataSource = rs
rs.Requery

txtUsername.Enabled = False
txtPassword.Enabled = False
txtConfirmPass.Enabled = False
cboAccountType.Enabled = False
txtUsername.Text = ""
txtPassword.Text = ""
txtConfirmPass.Text = ""
cboAccountType.Clear

cmdAdd.Enabled = True
cmdSave.Enabled = False
cmdCancel.Enabled = False

End If
End Sub
 
Re: need help po sa project

pahelp po ndi ko kc malaman kung anong kulang ko d2.. kelangan daw kc n kpag nag add ako ndi daw tatanggapin ng program kpg may blank n field.

e2 po codes:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String

Private Sub cboAccountType_Change()
cboAccountType.Clear
cboAccountType.AddItem "Admin"
cboAccountType.AddItem "User"
End Sub

Private Sub cmdAdd_Click()
txtUsername.Enabled = True
txtPassword.Enabled = True
txtConfirmPass.Enabled = True
cboAccountType.Enabled = True
txtUsername.SetFocus

cmdAdd.Enabled = False
cmdSave.Enabled = True
cmdCancel.Enabled = True
End Sub

Private Sub cmdCancel_Click()
txtUsername.Enabled = False
txtPassword.Enabled = False
txtConfirmPass.Enabled = False
cboAccountType.Enabled = False

cmdAdd.Enabled = True
cmdSave.Enabled = False
cmdCancel.Enabled = False
End Sub

Private Sub cmdSave_Click()
sql = "SELECT * FROM tblUserAccounts WHERE Username = '" & txtUsername.Text & "'"
Set rs = New ADODB.Recordset
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

If rs.RecordCount > 0 Then
MsgBox "Username already taken."
Else
rs.AddNew
rs!UserName = txtUsername.Text
rs!Password = txtPassword.Text
rs!AccountType = cboAccountType
rs.Update
rs.Close

Set rs = New ADODB.Recordset
sql = "SELECT * FROM tblUserAccounts"
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

Set DataGrid.DataSource = rs
rs.Requery

txtUsername.Enabled = False
txtPassword.Enabled = False
txtConfirmPass.Enabled = False
cboAccountType.Enabled = False
txtUsername.Text = ""
txtPassword.Text = ""
txtConfirmPass.Text = ""
cboAccountType.Clear

cmdAdd.Enabled = True
cmdSave.Enabled = False
cmdCancel.Enabled = False

End If
End Sub

Private Sub Form_Load()
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Database\dbEnrollment.mdb;Persist Security Info=False"
cn.Open
cn.CursorLocation = adUseClient

Set rs = New ADODB.Recordset
sql = "SELECT * FROM tblUserAccounts"
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

Set DataGrid.DataSource = rs
rs.Requery

End Sub

dapat may error trappings ka dun sa may save button mo..
example:

if textbox1.text = "" then
msgbox"Blank entry not allowed."

else

dito na yung save codes mo.....
 
haha pareho lng tayo nanganga-ilangan ng tulong dito noh. .inopen ko tong thread para sa ating lahat. .haha lahat tayo studyante dito! :p :p :p

kuya! patulong naman po...

pwede po ba gumawasa vb 6 ng simulation of a single runway airport?
applicable din po ba sa vb6 ung mga simulation????
need kc namin e..
kailangan po ng following:
1. simulation clock
2. methods to schedule the ocurence of events
3. tools to collect and analyze statistics
4. tools for reporting results
5. random number generators

need to know if it would be possible na maacomplish, or other language na lng.
salamat ng madami!! uuu
 
masters!!!!!!!
kuya, ate! patulong naman po...

pwede po ba gumawa sa vb 6 ng simulation of a single runway airport?
applicable din po ba sa vb6 ung mga simulation programs????
need kc namin e..
kailangan po ng following:
1. simulation clock
2. methods to schedule the ocurence of events
3. tools to collect and analyze statistics
4. tools for reporting results
5. random number generators

need to know if it would be possible na maacomplish, or other language na lng.
tpos patulong na din sa logic.. ^^
salamat ng madami!! uuu
 
URHonor kumusta na po yung request ko po sa inyo. yung pm ko po dati sa inyo!
 
@ codeproject
hinahanap ko pa tol. I will upload it pag nkita ko na. Pasensya na.
 
salamat sa mga nag respond dun sa post ko. natapos ko dn xa kaninang madaling araw.. nasolve ko n dn.. mejo matagal lang dn kc napatigil sa pagpprogram.. ahehe.. agen ty po:thumbsup:
 
mga bro help para sa kapatid ko nakaproblema na kc sya gusto ko po sya tulongan
di po ako marunong VB6

pero tulongan nyo naman ako gumawa ng student profile.....:pray:

turbo C lng kc alam ko.... :D
 
Last edited:
I have two of these statements in one form

Private Sub lvwEvents_ItemClick(ByVal Item As MSComctlLib.ListItem)
m_EventNumber = Item.Tag
GetEventFile Item.Tag
End Sub

Private Sub lvwContestants_ItemClick(ByVal Item2 As MSComctlLib.ListItem)
m_ConsNumber = Item2.Tag
GetContestantFile Item2.Tag
End Sub

Ang problema is ayaw magpalit ng value ni Item2.Tag

Paano po yun?
 
I have two of these statements in one form





Ang problema is ayaw magpalit ng value ni Item2.Tag

Paano po yun?


Base sa code mo na nakita ko, walang problem sa code, sa database ang problem, yung sa table mo ng contestant, ginamit mo as tag yung EventID para makuha ang isang contestant, dapat ContestantID ang ginamit mo as Tag sa 2nd listview para makuha yung particular contestant.

by the way ganda ng coding mo, malinis. parang pro.
sumabit lang sa database design.
 
mga bro help naman .... maliit n tulong lang..nalimutan ko kasi ...

may textbox ako ..which is list ng mga information ng judge.. name,gender,address and so on... then may button na add muna..saka n ung iba...then ang prob is .. d ko na alam kung papanu ko ma a-add ung info sa textbox through listview.. help pls... tnx
 
Back
Top Bottom