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!

[TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataReport

Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

aus to otor.. thanks dito.. nasusundan ko naman kahit papano.., galing ahh.. nasa login pa lang ako.. try ko pa bukas kung pano magadd ng user.. otor, nalalagyan ba ng checkbox ung listview?

oo naman, may property sya para dyan
tignan mo sa properties window
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

salamat otor...
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

otor magaad kasi ako ng user then kelangan syempre ng password.. and i need to encrypt it diba.. dun sa program mo tama ba na gawin ko lang to

sTmpPassword = txtUserAccount(1).Text
cipherPassword = cUserLogin.EncryptPassword(sUserName, sTmpPassword)
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

otor magaad kasi ako ng user then kelangan syempre ng password.. and i need to encrypt it diba.. dun sa program mo tama ba na gawin ko lang to

sTmpPassword = txtUserAccount(1).Text
cipherPassword = cUserLogin.EncryptPassword(sUserName, sTmpPassword)

nasa isang class kasi ang encrypt decrypt
clsXEncryptHex1

kunin mo na diretso yung function na nasa loob ng class, ilagay mo sa module as public then call it as
cipherPassword = EncryptPassword(sUserName, sTmpPassword)
same sa decrypt

basic substitution encryption lang yan

or just use this functions

Code:
Public Function DecryptPassword(Password As String) As String
    Dim cEncrypt As clsXEncryptHex1
    Set cEncrypt = New clsXEncryptHex1
    cEncrypt.Key = 1234567890
    Dim sText As String
    sText = cEncrypt.DecryptPassword(Password)
    DecryptPassword = Mid(sText, InStr(sText, "|") + 1)
End Function

Public Function EncryptPassword(UserName As String, Password As String) As String
    Dim cEncrypt As clsXEncryptHex1
    Set cEncrypt = New clsXEncryptHex1
    cEncrypt.Key = 1234567890
    Dim sText As String
    sText = cEncrypt.EncryptPassword("@" & UserName & "|" & Password)
    EncryptPassword = sText
End Function

lagay mo sa module

kakaiba yan kasi username at password ang ginagamit ko sa encryption
para pag nagpalit ng username magiging invalid ang password
saka para di ma kopya sa ibang record ang password
 
Last edited:
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

oo nga ang galing., ok na napagana ko na... tanong na lang ako ulit pag may problema..
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

bos bakit pag walang laman ang isa sa column sa access

invalid use of null
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

pano ko maiiwasan ung ganung error?
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

pano ko maiiwasan ung ganung error?

una hwag kang mag lalagay ng "ALLOW NULL" na field, kung di maiiwasan dapat may default value, hindi NULL

now kung meron talagang matigas ang ulo na NULL
1. pwede mo i check for NULL by using
Code:
IsNull(rs!FieldName)

2. para mas simple ang buhay ko ganito ang ginagawa ko
Code:
text1.text = "" & rs!FieldNameNaNULL
yes nag aapend ako ng empty string sa field so that maski NULL sya at nagassign ako sa textbox ay OK parin

kasi bawal ang
text1.text = NULL
so para simple ang buhay
text1.text = "" & NULL

so legal parin at walang error
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

thanks.. try ko maya...
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

ok na., gumana na.. thanks otor,. laking tulong to skin..
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

otor,. pano ba lock ang listview..
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

nalock ko na... pano kaya gumawa ng view na ganito., bale may group header taz may mga child item... may isang image sa bawat group., pakitingnan ung nakaattach na file...
 

Attachments

  • New Picture (5).bmp
    1.1 MB · Views: 14
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

nalock ko na... pano kaya gumawa ng view na ganito., bale may group header taz may mga child item... may isang image sa bawat group., pakitingnan ung nakaattach na file...

di ko makita image, paki repost or upload sa image server
tignan natin kung pwede sa native listview or kung kelangan gawan ng user control or 3rd party
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

eto po., pano ko kaya magagawan to ng table sa vb6

table_by_juztarts.jpg
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

eto po., pano ko kaya magagawan to ng table sa vb6

table_by_juztarts.jpg

kung ganyan na view ang hanap mo sa vb6 ei 3rd party grid ang dapat, usually may bayad yun

madali yan sa datagridview ng vb.net

pero kung as is ang vb6 datagrid or flexgrid mahihirapan makuha yan, pwede siguro pero limited lang
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

madali ba pag 3rd party grid.? ano un?
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

madali ba pag 3rd party grid.? ano un?

3rd party components are components not part or vb6
merong mga enhanced na buttons, grids, forms, etc
mga mapoporma at madaming features na components
usually may bayad

dami dito
http://www.componentsource.com/topreviews/datagrids/index.html

eto pa
http://www.bennet-
tec.com/BTProducts/TList/TListScreenShots.htm

http://www.ocx-activex.com/grid.html

kaya lang mga may bayad lahat yan

pag ganyan more on sa commercial or sa trabaho na ginagamit yan kasi kaya ng company bumili ng mga ganyang components.

sa students tyaga muna sa free or native vb6 components
or gawa ng sariling components.

yang pinakita mo ay malamang web or vb.net yan
 
Last edited:
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

sa excel ko gawa un otor.,. nahirapan na ko sa excel kaya ginawa ko sa vb6 .., parang kaya ng flexgrid.., pero nakakapaginsert ba ng img sa bawat cell ng flexgrid?
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

boss, baka may maisip kang paraan, baka kaya sa flexgrid.,. pahelp na lang..
 
Re: [TUT] VB6 MSAccess Sample using ADO (UPDATED V3 20100216) now with ADD and DataRe

boss, baka may maisip kang paraan, baka kaya sa flexgrid.,. pahelp na lang..

kaya naman sa flexgrid kung gusto mo
wala nga lang grouping, yung image kaya yan kasi may merging naman dun ng cells

i set mo lang sa cell then loadpicture

MSFlexGrid1.Cols = 10
MSFlexGrid1.Row = 1
Set MSFlexGrid1.CellPicture = LoadPicture("path of the image")

then may merging, aralin mo kung papano i merge ang cells
With MSFlexGrid1
.MergeCol(0) = True 'First Column in grid
.MergeCol(1) = True 'Second Column in grid
.MergeRow(0) = True 'First Row in Grid
.MergeRow(1) = True 'Second Row in Grid
End With


gamit ka MSHflexGrid para mas flexible


may sample pa ako ng flexgrid dito
http://symbianize.com/showthread.php?t=164703
 
Back
Top Bottom