Exclusively for Visual Basic 6.0 Programmers Only!

[kwincie257]

ano uli yun? access 2003? gagana din yan, `

nag eerror po sir

 

[kwincie257]

yung searching ilagay mo sa event ng Textbox which is KeyPress.

pwede po penge ng sample code

 

[knowmeifyou]

^Private Sub Text1_KeyPress(KeyAscii As Integer)
'lagay mo dito ung code at saka ung like statement
End Sub

 

[knowmeifyou]

sino ang may source ng license codejock taskpanel....
please share naman poh

wait upload ko for you. Xtreme SuitePro ActiveX v12.0.2 pala yong sakin take not kung gusto mo ung software buy mo ito

http://www.mediafire.com/?n15shjo2ar05tjm

 

[agentmarc09]

since na solve mo na ata yung loading bar, gamit ka ng sql query tapos ipasok mo sa adodc recordsource property. kung paano mag query, try mo sa google. search mo about select statements

salamat master... Gets k0h na, problem ko nlng eh kapag nag search ako ng account n0. Then pag click k0h ng cmdbutton lalabas sa another f0rm ung mga detail...

 

[rayzle16]

let's say may result na ang recordset mo (rs)...

frmResult.Text1.Text = rs!Field1
frmResult.Text2.Text = rs!Field2
frmResult.Text3.Text = rs!Field3
frmResult.Show 1

salamat master... Gets k0h na, problem ko nlng eh kapag nag search ako ng account n0. Then pag click k0h ng cmdbutton lalabas sa another f0rm ung mga detail...

 

[agentmarc09]

let's say may result na ang recordset mo (rs)...

frmResult.Text1.Text = rs!Field1
frmResult.Text2.Text = rs!Field2
frmResult.Text3.Text = rs!Field3
frmResult.Show 1

salamat fUh, pero ask k0h lng pu bkit pu ganun pag bnuksan ko ung gawa ko sa ibang computer eh, nag eerror na. Kumbaga ndi na xia nka connect sa access, may solusy0n pu b dun..?

 

[gtventic]

@agentmarc Buong folder ba ang copy mo sa ibang computer or yung executable lang nang application na ginwa mo?

there is nothing impossible in programming. depenede lang yun sa diskarte nang nagdedevelop.

yung question mo kung may solusyon, syempre meron

check mo ito
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database.mdb;Jet OLEDBatabase Password= " & cDBPassword & ""

yung & App.Path & yun yung solution sa problem mo, ibig sabihin nun kung saan naron ang application path(EXE) mo dun nya hahanapin ang database mo, kaya kahit nasa flash drive ang apllication mo and databse mo tatakbo ang system na ginawa mo
applicatble po yan sa MS access database.

hope nakatulong, ask lang po kayo nang question, sasagutin namin.

 

[maritesmacute]

here i go again xD.. help ulet, sabog na ulit utak ko kakaisip
sql to ha
dba example

field name's ko
company, datereceive, invoicedate, reference, amount. yan
tblreference

eto yung sql q

dba ganito yan.
select amount from tblreference where datediff("d",[datereceive],now) < 31 and company = 'agility') as current

tapos

select amount from tblreference where datediff("d",[datereceive],now) > 30 and datediff("d",[datereceive],now) < 61 and company = 'agility') as 30days

31 kasi current
31-60 pag 30days

eto yung question ko

nag multi select kasi ako

ganito oh

select
(select amount from tblreference where datediff("d",[datereceive],now) < 31 and company = 'agility') as current,
(select amount from tblreference where datediff("d",[datereceive],now) > 30 and datediff("d",[datereceive],now) < 61 and company = 'agility') as 30days
from tblreference
where company = 'agility'

my question is

pano ko mapag hihiwalay yung amount>?
kasi yung nalabas ganito,

company - current----30day----60days
agility ------12312-------55----------60
agility ----- 12312-------55----------60
agility ------12312-------55----------60

dapat ganito lang

company - current----30day----60days
agility ------12312
agility --------------------55
agility ----------------------------------60

 

[diamond hunter]

:help
pwed pahenge nang code sa kapag gamit ko numeric keypad sa keyboard.kapag punindot ako paulit2x nang "0" iisa lang zero tagala lalabas sa display..pa help ulit poh

 

[rayzle16]

obvious naman sa sinabi mo natural wala yung connection sa access, error yan. anong purpose mo sa paglipat pero kulang? in case you will fix this, check your connectionstring and hindi dapat naka hardcode yung path ng file mo (.mdb) just use App.Path then the filename (and folder path if there's any) of your database.

salamat fUh, pero ask k0h lng pu bkit pu ganun pag bnuksan ko ung gawa ko sa ibang computer eh, nag eerror na. Kumbaga ndi na xia nka connect sa access, may solusy0n pu b dun..?

 

[rayzle16]

why don't you take advantage of using VB6 for processing this as per record? wag mo ipilit ilagay sa isang query or multiple queries.

here i go again xD.. help ulet, sabog na ulit utak ko kakaisip
sql to ha
dba example

eto yung sql q


31 kasi current
31-60 pag 30days

eto yung question ko

nag multi select kasi ako

ganito oh




my question is

pano ko mapag hihiwalay yung amount>?
kasi yung nalabas ganito,

company - current----30day----60days
agility ------12312-------55----------60
agility ----- 12312-------55----------60
agility ------12312-------55----------60

dapat ganito lang

company - current----30day----60days
agility ------12312
agility --------------------55
agility ----------------------------------60

 

[rayzle16]

sa KeyPress event ng form, mag declare ka ng variable na double. then yung input i capture mo ilagay mo sa variable (double) but before that gamit ka ng function na Val() pero i-trim mo muna yung decimal point kung wala pa naman decimal na pinasok.

:help
pwed pahenge nang code sa kapag gamit ko numeric keypad sa keyboard.kapag punindot ako paulit2x nang "0" iisa lang zero tagala lalabas sa display..pa help ulit poh

 

[maritesmacute]

why don't you take advantage of using VB6 for processing this as per record? wag mo ipilit ilagay sa isang query or multiple queries.

http://599cd.com/site/courselist/access/access305/?key=AllExperts


hehe,, dun na mismo kay record kay button? try q hehe

 

[maritesmacute]

w000 another answer ang nagawa kohaha..
yehey mas maikli kaysa kay multiple select.. at super dali nya w00000000, at pwede pa lahat gn gusto ko haha.. buti tinesting ko.

 

[agentmarc09]

@gtventic..
@rayzle16..

salamat pu sa iny0 mga master =) working xia..

 

[jeromefelizarta]

sir .. anu pwede po bang gumawa ng countdown timer sa VB 6.0 ?

 

[bryan1207]

sir .. anu pwede po bang gumawa ng countdown timer sa VB 6.0 ?

Pwedeng pwede po. Gamit ka po ng TIMER and lagay ka lang ng interval para sa TIMER.

 

[anniemel]

This thread is open for all vb programmers. .you can post anything you like as long as it is related with Visual Basic 6.0 Programming. .Assignments and tutorials are accepted. .​

So mga Visual basic Programmers tambay na po kayo dito. .hehe

Help nmn po, gusto ko gumawa ng basic na program with database. gusto ko pag nakapagselect ako ng item sa DBCOMBO with datafield name lalabas ung data record sa textbox like name and address. Gusto ko ung basic lang ayaw ko gumamit ng SQL or whatever, basic lang as in basic lang talaga, I can't figure kung ano ung tamang code dito, pero nagawa ko na sya dati pa kaya lang long years ago na sya, nakalimutan ko n talaga sya... Thanks po sa makakatulong.

Pakicheck nlng po ung attachment ko then modify nlng po. thanks...

 

[yt758b34vh83]

@anniemel pakielaborate pa medyo magulo kc explanation mo