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

[shaolinkungfu]

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

Good day Sir:

sorry to disturb you again... may ilang question lang ulit ako. nagsearch na kc ko sa internet pero di ako makakuha ng exact answer. tanong ko lang kung pano magcompute ng numeric value with a format of; for example: 1,500.00 - 700.00.

ok this is the scenario

i have 2 textboxes, let say text1 and text2

text1 holds a value of 1,500.00 and the text2 holds a value of 700.00

sa database ko currency ang field data type nila... i formatted it already. gusto ko lang macompute ko cla then sa text3 lalabas ang sagot pagkatapos ko macompute ung text1 and text2.

thanks in advance Sir....

 

[chrislpc]

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

Dim Value1 as double
Dim Value2 as double
Dim Diff as double

Value1 = cdbl(text1.text)
Value2 = cdbl(text2.text)
Diff = Value1 - Value2
Text3.text = Cstr(FormatNumber(Diff, 2,vbfalse, vbfalse, vbtrue))

 

[knives645]

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

Good day Sir:

sorry to disturb you again... may ilang question lang ulit ako. nagsearch na kc ko sa internet pero di ako makakuha ng exact answer. tanong ko lang kung pano magcompute ng numeric value with a format of; for example: 1,500.00 - 700.00.

ok this is the scenario

i have 2 textboxes, let say text1 and text2

text1 holds a value of 1,500.00 and the text2 holds a value of 700.00

sa database ko currency ang field data type nila... i formatted it already. gusto ko lang macompute ko cla then sa text3 lalabas ang sagot pagkatapos ko macompute ung text1 and text2.

thanks in advance Sir....

ganito..

Private Sub Command1_Click()

Text3.Text = Format(CSng(Text1.Text) - CSng(Text2.Text), "#,###.00")

End Sub

 

[shaolinkungfu]

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

Good day sir. Happy New Year!

why keeping so silent this past days? busy po ba kayo?

 

[knives645]

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

sir eric, wala poh bang DAO tutorial? Even trappings lang sir. Yong gagawin naming sales system eh for multi-user kasi sir. Di ba hindi pwde ang ADO for multiple user?tama poh ba sir?
nakalimutan ko na kasi yon.

Thanks ahead sir. God Bless.
Marami kana pong natulungan sir. Isa na ako don (Java).

Any details? What database you prefer to use?
If SQLServer, Oracle, well, i would prefer ADO codings..

If MS Access? pwede and DAO, look at this link,,,
http://thedailyreviewer.com/office/view/multi-user-access-db-dao-or-ado-101817861
http://support.microsoft.com/kb/191253

pero, hindi masydong ginagamit ang Access as server database,
baka magkaproblema lang kayo in the end..
SQL Server na lang, and Ado codings...

Good Luck..

 

[doorbreaker]

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

up ko lang to, dami tmad mag hanap eh

 

[shaolinkungfu]

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

good day to you sir,

question lang po, pano ba iset ang color ng shape na nilagay ko sa data report ko. for example sa database field ko (field name: status, status = true (this is the value of the field status)) paghugot ko sa database ko then ipiprint ko sya sa datareport, sa datareport ko nirepresent ko sya as shape (circle).

kapag true ang value ng status field ko sa database ko, pagprint ko dapat naka vbBlack ung shape ko na nasa datareport ko. pano po ba i-code ito?

and one more question pa po. is it possible ba na gumamit ng 2 parameters to call data sa iisang datareport para maidisplay ang data galing sa magkaibang table sa loob ng iisang database? pano rin po ung pagcode nun. sinusubukan ko kc kaya lang error ang lumalabas. naghahanap ung isang parameters ng fields sa table kung saan sya naka-assign na nandun naman sa isang table. ganon din ang problem nung isang parameter.

ex.

sql = " select column1, column2 from table1 "
sql2 = " select column3, column4 from table2 "

rst1.open sql
rst2.open sql2

ganito ung cnubukan kong gawin sa query, then errors rise-up.

thanks a lot po...

 

[charjho]

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

sir pa add po sa ym poh... [email protected].. tnx

 

[iruka]

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

malakiong 2long to sming mga beginner..thanks alot..

 

[jamessanjose14]

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

brad kaya mo ba gumawa ng ADODB gamit access lang? yung VBA Macro lng.. Need lang talaga. Thanks!

 

[knives645]

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

brad kaya mo ba gumawa ng ADODB gamit access lang? yung VBA Macro lng.. Need lang talaga. Thanks!

Actually, sa first page ng thread na to
merong example nang hinahanap mo....
Pwede mong pag-aralan kung gusto mo..
Well, kung iba yung process nyo, malamang
gagawa ka ng sarili mong program, wag kang
mag-alala, madami tutulong sayo..

Ano bang system ang hanap mo?
Pang-thesis o business?
May process flow na ba?

 

[jamessanjose14]

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

mejo business kasi... Planning to propose a system.. kaso bawal mag install ng VB6 dun...
Ang tanging pede lang is office.. Kung VB6 lang is walang problema talaga kasi ADODC and Data
Environment marunong ako... Hinahanap ko sa office parang walang ganun...

 

[koykoys]

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

this is my favorite part in programming _

 

[knives645]

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

mejo business kasi... Planning to propose a system.. kaso bawal mag install ng VB6 dun...
Ang tanging pede lang is office.. Kung VB6 lang is walang problema talaga kasi ADODC and Data
Environment marunong ako... Hinahanap ko sa office parang walang ganun...

Ah, i see now, if VB6 is prohibited in your office, then you'll go VBA
programming, you can use MS Access as your database and Macro Programming for your codes, walang ADODC or Data Env. dun,
however, you can use ADODB or DAO codes....

Actually, VBA programmer ako dati, maganda rin, pwede gamitin
ng multiple users coz it resides in a server folder, pero meron
meron disadvantages and you should use it with care,
issue kase ang security, dapat secured ang folder, and
magbibigay ka ng permission sa mga user, tapos, prone ang
Database, pwede kase i-over-write kahit nino, kaya kelangan
lagi kang nag-ba-back-up,..
Isa pa ang Size, Access can only hold 2GB of data..
Pag nga umabot sa 100MB (approx. in 1 year) mabagal na, so you haveto do regular Compact and repair..
Para hindi lumaki masyado at bumagal, I always separate the data
yearly, i put them in separate UI...

Pero don't worry, it's just a matter of techniques, meron paraan
maitago ang database, para hindi ito mai-edit,
I have spent a lot of times nuon para sa securities...
Gladly, successful naman..
lahat ng mga features, incorporated sa Codes ko,
like daily back-ups, Auto-send of e-mail reports,
Crosstab queries.. etc...

Advantages, madali syang i-modify, hindi na kelangan gawing
executable file..
You'll see, once you started doing it...
I'm willing to help, in any ways...

Good Luck!

 

[jamessanjose14]

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

sample po pede? well succesfull yung nahanap kong connection..
ADODB sya... nagtataka lang ako alang timer dito...
so palagay ko gagamit nalang ako ng LOOP? Pero sample naman po
if pede... salamat!!!

 

[jamessanjose14]

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

Nga pala.. Sample na din po sa pageexport ng database sa excel..
kasi yung VBA sa excel di ako makapagdeclare ng ADODB... May gagawin
pa ba dun? Salamat ulit!!

 

[knives645]

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

Nga pala.. Sample na din po sa pageexport ng database sa excel..
kasi yung VBA sa excel di ako makapagdeclare ng ADODB... May gagawin
pa ba dun? Salamat ulit!!

On your opened Excel or Access,
press alt-F11 then, goto Tools and click References,
checked mo yung...
Microsoft ActiveX Data Objects 2.8 Library
or yung 2.6 or 2.7,

 

[jamessanjose14]

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

La pala timer d2. ANY other way para mkpagcreate ng intervals? sample po. thx

 

[jamessanjose14]

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

up lang..

 

[akira556]

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

astig to I am a first year bscs and currently learning vb6 into our home, sa ebook ko nasa database na ko, makakatulong to sakin.. thanks po ^_^