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!

yung sa MDB file kailangan mo ng MS Access, preferably 2003 pababa.

tapos gamitin mo datasource sa tools mo para maconnect mo yung VB form mo sa MS Access file.
medyo self explanatory na din naman yung pagawa ng form. kung interesado ka pede mo naman kasi laruin eh :)

pede mo din paglaruan yung MS Access file mismo. may panggawa na sya ng forms so no need for datasource
 
gandang umaga po sa inyo.....ask ko lang po kung meron po ba ditong tutorial ng pagawa ng form sa vb 6 tapos ang gagamitin data is mdb file...hindi po ako programmer.....working na po and nagka interest lang akong gumawa ng program using vb 6 kasi puro data ang kaharap ko sa work.....meron po kayang makakapag bigay dyan ng tutorial...????thanks in advance.


Meron dito, just keep your eyes open.

VB6 MSAccess Sample using ADO
 
ganun nman talaga yan. walang masyado nag rerequest bro, pero pagnakita nila, useful nman pala sa kanila.
 
Explain QUEUE.
Are you referring sa MSMQ ng Microsoft or logical queue lang yan?

Ano kinalaman ng MSDN dyan?
msdn is basically an ebook at manuals for Microsoft products, so ano kinalaman nyan sa project mo?

galit po ba kayo?:):):)
easy lang po...

ung queue po gagamitin ko sana sa pagstore or sa paghold ng mglalanding at magttake off na airplanes.

ang pinagagawa po kasi smin ngayon ay airport simulation so i need to know how to implement queues in vb6.

salamat po. uuu
 
galit po ba kayo?:):):)
easy lang po...

ung queue po gagamitin ko sana sa pagstore or sa paghold ng mglalanding at magttake off na airplanes.

ang pinagagawa po kasi smin ngayon ay airport simulation so i need to know how to implement queues in vb6.

salamat po. uuu

Pano mo naman nasabi na galit ako? Kung galit ako di na ako sasagot.

Nagtaka lang ako bakit nadawit ang MSDN, it means yung information mo ay medyo di tama.

QUEUE para sa yo is basically FIFO(First In, First Out) diba?

Madami kasi way para i-implement ang QUEUEING, yng simpleng listbox lang pde na, or linked list, collection, etc.

Ordered list lang ang queue. yung pde kang mag lagay sa ilalim at kumuha sa ibabaw. in other words PILA.

Ilagay mo lang sa listbox or any list container, habang may incoming ilagay mo sa ilalim, then dispatch kung ano ang nasa ibabaw.

Meron kasing service sa Windows OS na MSMQ, thats the best way lalo ang data galing sa ibang program, pero i think di yun ang hinahanap mo.

eto to prove na di ako galit, ill throw in a very basci Queueing class for you

Code:
CQueue - a class module to implement First-In-First-Out (queue) structures
'--------------------------------------------------
'
' The CQUEUE class
'    Dim qu As New CQueue
'
'    ' enqueue to items to the queue
'    qu.Enqueue 1234
'    qu.Enqueue 5678
'    ' display number of elements in the queue
'    Debug.Print "Count = " & qu.Count
'    ' peek at the element about to be read
'    Debug.Print "Peek = " & qu.Peek
'    ' print the elements in the queue while removing them
'    Do While qu.Count
'        Debug.Print "next item = " & qu.Dequeue
'    Loop
'--------------------------------------------------

' this is the collection that holds the values
Dim colValues As New Collection

' add a new value to the queue
Sub Enqueue(value As Variant)
    colValues.Add value
End Sub

' read the next value from the queue and remove it
' raises and error if the queue is empty
Function Dequeue() As Variant
    Dequeue = colValues.Item(1)
    colValues.Remove 1
End Function

' Return the next value from the queue, without removing it
' raise error if queue is empty
Function Peek() As Variant
    Peek = colValues.Item(1)
End Function

' Return the number of values in the queue
Function Count() As Long
    Count = colValues.Count
End Function

' clear the queue
Sub Clear()
    Set colValues = New Collection
End Sub
 
Last edited:
Pano mo naman nasabi na galit ako? Kung galit ako di na ako sasagot.

Nagtaka lang ako bakit nadawit ang MSDN, it means yung information mo ay medyo di tama.

QUEUE para sa yo is basically FIFO(First In, First Out) diba?

Madami kasi way para i-implement ang QUEUEING, yng simpleng listbox lang pde na, or linked list, collection, etc.

Ordered list lang ang queue. yung pde kang mag lagay sa ilalim at kumuha sa ibabaw. in other words PILA.

Ilagay mo lang sa listbox or any list container, habang may incoming ilagay mo sa ilalim, then dispatch kung ano ang nasa ibabaw.

Meron kasing service sa Windows OS na MSMQ, thats the best way lalo ang data galing sa ibang program, pero i think di yun ang hinahanap mo.

eto to prove na di ako galit, ill throw in a very basci Queueing class for you

Code:
CQueue - a class module to implement First-In-First-Out (queue) structures
'--------------------------------------------------
'
' The CQUEUE class
'    Dim qu As New CQueue
'
'    ' enqueue to items to the queue
'    qu.Enqueue 1234
'    qu.Enqueue 5678
'    ' display number of elements in the queue
'    Debug.Print "Count = " & qu.Count
'    ' peek at the element about to be read
'    Debug.Print "Peek = " & qu.Peek
'    ' print the elements in the queue while removing them
'    Do While qu.Count
'        Debug.Print "next item = " & qu.Dequeue
'    Loop
'--------------------------------------------------

' this is the collection that holds the values
Dim colValues As New Collection

' add a new value to the queue
Sub Enqueue(value As Variant)
    colValues.Add value
End Sub

' read the next value from the queue and remove it
' raises and error if the queue is empty
Function Dequeue() As Variant
    Dequeue = colValues.Item(1)
    colValues.Remove 1
End Function

' Return the next value from the queue, without removing it
' raise error if queue is empty
Function Peek() As Variant
    Peek = colValues.Item(1)
End Function

' Return the number of values in the queue
Function Count() As Long
    Count = colValues.Count
End Function

' clear the queue
Sub Clear()
    Set colValues = New Collection
End Sub

jeje.. siguro po msydo lng ako nseryosohan sa tone nyu.
salamat po kuya!
try ko po iimplement to.
salamt po ulit.. uuu
 
search and edit pop up button code needed

p2long nmn ult guys. gs2 ko kc sana pop up window n lang lalabas sa search and edit button ko,

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

Private Sub cboCourse_Change()

cboCourse.Clear
cboCourse.AddItem "ABpolsci"
cboCourse.AddItem "BSC"
cboCourse.AddItem "BSCS"
cboCourse.AddItem "BSE"
cboCourse.AddItem "BSN"
cboCourse.AddItem "HRIM"

End Sub

Private Sub cboGender_Change()
cboGender.Clear
cboGender.AddItem "Male"
cboGender.AddItem "Female"
End Sub

Private Sub cmdAdd_Click()

txtFirstName.Enabled = True
txtLastName.Enabled = True
txtMiddleName.Enabled = True
txtStudNo.Enabled = True
cboCourse.Enabled = True
cboYearLvl.Enabled = True
txtAddress.Enabled = True
txtSubject.Enabled = True
txtAge.Enabled = True
cboGender.Enabled = True
txtBirthDate.Enabled = True
txtContactNo.Enabled = True

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

Private Sub cmdCancel_Click()

txtFirstName.Enabled = False
txtLastName.Enabled = False
txtMiddleName.Enabled = False
txtStudNo.Enabled = False
cboCourse.Enabled = False
cboYearLvl.Enabled = False
txtAddress.Enabled = False
txtSubject.Enabled = False
txtAge.Enabled = False
cboGender.Enabled = False
txtBirthDate.Enabled = False
txtContactNo.Enabled = False

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

txtFirstName.Text = Clear
txtLastName.Text = Clear
txtMiddleName.Text = Clear
txtStudNo.Text = Clear
cboCourse.Text = Clear
cboYearLvl.Text = Clear
txtAddress.Text = Clear
txtSubject.Text = Clear
txtAge.Text = Clear
cboGender.Text = Clear
txtBirthDate.Text = Clear
txtContactNo.Text = Clear

End Sub



Private Sub cmdSave_Click()

If txtFirstName.Text = "" Or txtLastName.Text = "" Or txtMiddleName.Text = "" Then
MsgBox "Please fill-up all fields"
Exit Sub
End If

sql = "SELECT * FROM tblStudInfo WHERE FirstName = '" & txtFirstName.Text & "'"
Set rs = New ADODB.Recordset
rs.Open sql, cn, adOpenKeyset, adLockOptimistic

If rs.RecordCount > 0 Then
MsgBox "FirstName already taken."
Else
rs.AddNew
rs!FirstName = txtFirstName.Text
rs!LastName = txtLastName.Text
rs!MiddleName = txtMiddleName.Text
rs!StudNo = txtStudNo.Text
rs!Course = cboCourse.Text
rs!Subject = txtSubject.Text
rs!Address = txtAddress.Text
rs!YearLvl = cboYearLvl.Text
rs!Age = txtAge.Text
rs!Gender = cboGender.Text
rs!BirthDate = txtBirthDate.Text
rs!ContactNo = txtContactNo.Text
rs.Update

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

Set DataGrid.DataSource = rs
rs.Requery

txtFirstName.Enabled = False
txtLastName.Enabled = False
txtMiddleName.Enabled = False
cboCourse.Enabled = False
txtSubject.Enabled = False
cboYearLvl.Enabled = False
txtAddress.Enabled = False
txtStudNo.Enabled = False
txtAge.Enabled = False
cboGender.Enabled = False
txtBirthDate.Enabled = False
txtContactNo.Enabled = False
txtFirstName.Text = ""
txtLastName.Text = ""
txtMiddleName.Text = ""
cboCourse.Text = ""
txtSubject.Text = ""
cboYearLvl.Text = ""
txtAddress.Text = ""
txtStudNo.Text = ""
txtAge.Text = ""
cboGender.Text = ""
txtBirthDate.Text = ""
txtContactNo.Text = ""

cmdAdd.Enabled = True
cmdSave.Enabled = False
cmdDelete.Enabled = True
cmdEdit.Enabled = True
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=C:\Documents and Settings\Aldrin\My Documents\SE\Database1.mdb;Persist Security Info=False"
cn.Open
cn.CursorLocation = adUseClient

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

Set DataGrid.DataSource = rs
rs.Requery

End Sub

Private Sub cboYearLvl_Change()

cboYearLvl.Clear
cboYearLvl.AddItem "1st"
cboYearLvl.AddItem "2nd"
cboYearLvl.AddItem "3rd"
cboYearLvl.AddItem "4th"
End Sub


Private Sub cmdDelete_Click()

If rs.RecordCount = 0 Then
MsgBox "There are no records to modify or delete!", vbExclamation, "Error"
Exit Sub
End If

If MsgBox("Are you sure you want to delete the selected record?", vbYesNo, "Delete") = vbYes Then
rs.Delete
Else
Cancel = True
rs.Update
End If
End Sub

Private Sub cmdEdit_Click()

rs.EditMode
rs.Update
End Sub

ty po sa 22long:help:
 
Re: search and edit pop up button code needed

p2long nmn ult guys. gs2 ko kc sana pop up window n lang lalabas sa search and edit button ko,



ty po sa 22long:help:

Bakit sa Change Event ka nag Add ng item sa combobox?
So ibing mo sabihin everytime na mag select ako sa combobox ay i clear nya yung items tapos mag add ulit?
Kawawa naman ang processor mo.

Yung sample ko dito may search na window:
http://symbianize.com/showthread.php?t=163979
 
Last edited:
anyone!!

nakakalito po ang classes sa vb.. huhu (o ako lang?) jeje..
di ko malaman pano iimplement.


paturo naman po.
starting from the basic po ah..



salamat. uuu
 
Xenxa na boss hindi ko po alam e. Basta yun lang yung sinaBi ng pRof nMen. Kaya nga ko nagtatan0ng e. Hay.. Mga example lang naman ng mga uTility software at kung kaya po bA i pRogram sa vb6. Yung Ccleaner po bA kayang iProgram sa vb6?
 
Xenxa na boss hindi ko po alam e. Basta yun lang yung sinaBi ng pRof nMen. Kaya nga ko nagtatan0ng e. Hay.. Mga example lang naman ng mga uTility software at kung kaya po bA i pRogram sa vb6. Yung Ccleaner po bA kayang iProgram sa vb6?

Napaka BROAD kasi ng tanong mo.
Dito sa Programming,it pays to be specific and detailed
kung di mo maexplain in details ang problem mo, paano kaya yan maiintindihan ng gustong tumulong sayo?

And yes, pde ka gumawa ng kagaya ng CCLeaner sa VB6, yun nga lang mga advanced commands at API ang gagamtin mo kasi madami dun low level processing, like sa registry, Access Rights sa Temp Folders at madami pang iba.
Be ready sa madugong programming.

Suggestion ko sayo, ilista mo yung functionalities ng UTILITY mo then start from there, ano gagawin ng utility? ano function, ano features, etc.

I-layout mo mabuti, then sa bawat function find a way to make it work, dont expect a complete system na gagayahin mo nalang.

hindi masama ang magtanong, just make sure ang tanong mo ay madaling intindihin, para maiwana ang pabalik balik, i admire those na isang question lang nandun na lahat, mas madali sagutin and to the point.

Ano mas malinaw?

"Example ng ulitlity Software"
or
"Example ng Utility Software na gaya ng CCLeaner"
 
Last edited:
Re: search and edit pop up button code needed

Bakit sa Change Event ka nag Add ng item sa combobox?
So ibing mo sabihin everytime na mag select ako sa combobox ay i clear nya yung items tapos mag add ulit?
Kawawa naman ang processor mo.


ahehe.. sensya n po mejo nag uumpisa p lang po kc ako ult.. pero nweiz. ty po:)
 
anyone!!

nakakalito po ang classes sa vb.. huhu (o ako lang?) jeje..
di ko malaman pano iimplement.


paturo naman po.
starting from the basic po ah..



salamat. uuu


Ang programming ay di lang about "If THen Else"
Its about time na matutunan mo ang classes

meron code dun kung papano gamitin ah, nakita mo ba?
Code:
'    
Dim qu As New CQueue ' declare the class
' enqueue to items to the queue
    qu.Enqueue 1234   'add item to the Q class
    qu.Enqueue 5678   'add item to the Q class ULET

    ' display number of elements in the queue
    Debug.Print "Count = " & qu.Count

    ' peek at the element about to be read
    Debug.Print "Peek = " & qu.Peek

    ' print the elements in the queue while removing them
qu.Dequeue 'read and remove the topmost item in the Q
' result is 1234

qu.Dequeue 'read and remove the topmost item in the Q
'result is 5678


ready made code na po yan sa queueing,
gagamitin nalang, and that is the example kung ppano gamitin.
its a very basic PUSH-POP operation.
ADD sa DULO, READ/REMOVE sa TOP, meaning ==== QUEUE

the class code itself has comments.
ano specifically po ba ang di mo maintindihan dun sa class?

so its simple enough to understand, try to relate kung ano ang pinag aralan nyo about Q

eto lang po ang mga methods sa loob ng class:
Enqueue = Add item to the Q, sa ilalalim
Dequeue = Read and remove the first item ng Q
Peek = silipin kung ano ang value ng unang item ng Q, w/o removing it
Count = sasabihin kung ilan ang laman ng Q
 
Last edited:
boss tanung ko lang po kung panu gumawa nang cab file salamat po..
 
boss tanung ko lang po kung panu gumawa nang cab file salamat po..

Cab file for installer or parang WinRar?

Kung sa Installer ng VB6 Applications, use Package And Deployment Wizard.

Kung Simple Cab File lang Use Iexpress (sa run menu, type iexpress)
 
boss kung sa educational software po kaya ano po kayang magandang gawin na program any suggestion po yung 2d lang po kaylangan lang po sa software engineering kung subject gang ngaun wala pa rin akong proposal T_T..
 
boss kung sa educational software po kaya ano po kayang magandang gawin na program any suggestion po yung 2d lang po kaylangan lang po sa software engineering kung subject gang ngaun wala pa rin akong proposal T_T..

Pde ka gumawa ng application para sa Student testing or exams, multiple choice, input mo questions and anwers, student will answer them via the application, timed sya, live ang scoring.
 
pwede po ba humingi ng sample program implementing classQueue kuya?

salamat po..
 
Back
Top Bottom