- Messages
- 81
- Reaction score
- 0
- Points
- 26
ano uli yun? access 2003? gagana din yan, `
nag eerror po sir
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!
ano uli yun? access 2003? gagana din yan, `
yung searching ilagay mo sa event ng Textbox which is KeyPress.
sino ang may source ng license codejock taskpanel....
please share naman poh
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...
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
eto yung sql qfield name's ko
company, datereceive, invoicedate, reference, amount. yan
tblreference
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
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'
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..?
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
: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
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.
sir .. anu pwede po bang gumawa ng countdown timer sa VB 6.0 ?
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