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

[ericgmejia]

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

panu po ung code nun? Penge naman poh sample code.

Use the samples on this thread brod. Sobra pa sa kelangan mo ang nandito.

Himayin natin.
You have 2 database with identical struture and you want to copy the data from db1 to db2.
So parang copy and paste, read the data in a table sa db1, then save it sa table sa db2.

Papano mo gagawin yun?

Pinakita ko na how to READ sa database using SELECT query,
then pinakita ko na rin how to SAVE by using INSERT query,
so try to exercise the programmer in you by experimenting on the code.

Yan lang ang paraan para ka matuto.

Its like this, parang sa driving yan, ipinakita ko na kung papano gamitin ang manibela at kambyo at accelerator, sana ika na ang mag drive kung saan ka man pupunta.

 

[ericgmejia]

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

Wala na ba may kailangan dito?

 

[animelover_manga]

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

sir..lalagi ako dito sa thread mo..tulungan mo ako sir ha?jeje!maraming salamat pala sa mga ebooks mo..

 

[bluerain28]

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

thanks sir. pag aaralan ko to kasi may prject kami heheh. ndi sapat ung tinuturo sa skul huhu

 

[animelover_manga]

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

thanks sir. pag aaralan ko to kasi may prject kami heheh. ndi sapat ung tinuturo sa skul huhu

buti pa sayo hindi sapat sa amin talaga hindi ko makonek kasi walang actual..

 

[ericgmejia]

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

Mag Suggest kayo kung ano gusto nyo ilagay natin dyan, pag tinopak ako idagdag ko

 

[ericgmejia]

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

Up lang,
screenshots provided on the first page,
para mas ma appreciate ng iba.

 

[romski]

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

Sir may YM po ba kayo?pahingi po sana Sir in case kung kailangan nang tulong na pang ultimatum.

kung ok lang Sir.

Advance Happy Birthday,

 

[ericgmejia]

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

Sir may YM po ba kayo?pahingi po sana Sir in case kung kailangan nang tulong na pang ultimatum.

kung ok lang Sir.

Advance Happy Birthday,

tutulunga kita kung nahanap mo YM id ko

 

[rptdelosreyes]

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

hanep encrypted pa!!!!!!!!

 

[rptdelosreyes]

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

galing galing!! ganun pala ang gamit ng class modules!

 

[ericgmejia]

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

hanep encrypted pa!!!!!!!!

ano ang silbi ng password kung madaling makita diba?

 

[qqwe123]

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

pano mag retrieve ng data from a database(.mdb) na nakaupload sa isang web server ? XD

 

[ericgmejia]

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

pano mag retrieve ng data from a database(.mdb) na nakaupload sa isang web server ? XD

Saan mo po nakita yang Idea na yan?
Sure ka ba sa question mo?

Can you clarify kung ano ang gusto mo gawin?
Web Server as in WEB talaga or just a networked file server?

Kasi wala tayo access sa file system ng isang web server, kundi yun lang binibigay ng server which is then web page.
Can you get a file from drive c: of symbianize.com?
Mahirap po yun.

So paki clear lang po ang gusto mo gawin.

kasi meron tayong data sa network which is accesible via network share. baka yun ang tinutukoy mo.



=============================================
Matanong ko lang, are you really a serious member ng SB?
Isang post lang at yung user name, tinaype ng tamad, pumindot lang sa first 3 keys sa left keyboard,
di pa dumaan sa introduction page may post na dito.
Dati ka bang member na may ibang account?
What is your intention in using that user name?

This is a sharing site po, we help each other, remember that. yan ang spirit ng SB.

As you can see i post my real name here dahil malinis ang intention ko, how about you po?
Wala man lang effort to type a proper username?

Just the same i try to accommodate your question no matter how far out is.

 

[jaychelle18]

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

wow! ung sample nyo sir eric my encryption at decryption... ung "asdas" ko nging 15 letters/numbers. waaaaaaa galing sir salamt sa sample nyo

 

[ericgmejia]

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

wow! ung sample nyo sir eric my encryption at decryption... ung "asdas" ko nging 15 letters/numbers. waaaaaaa galing sir salamt sa sample nyo

actually madami pirapiraso ng usefull code na mapupulot dyan kung pag tyaytagaan lang na intindihin e, di lang about ADO.

Kaya ko nga ginawa yan para pakinabangan ninyo.

 

[jaychelle18]

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

actually madami pirapiraso ng usefull code na mapupulot dyan kung pag tyaytagaan lang na intindihin e, di lang about ADO.

Kaya ko nga ginawa yan para pakinabangan ninyo.

uu nga po sir. my class module pa nga po eh.. nakagawa narin po ko ng sample ng class module nung sa GRfinger na binigay nyo.. galing nyo talaga sir... I want to meet you sir in person.. pati ung c rptdelosreyes... IDOL galing po talaga.. wala kong masabi kung hindi MAGALING. VERY USEFUL po ung mga samples nyo also ung pagtulong nyo at payo..

 

[ericgmejia]

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

uu nga po sir. my class module pa nga po eh.. nakagawa narin po ko ng sample ng class module nung sa GRfinger na binigay nyo.. galing nyo talaga sir... I want to meet you sir in person.. pati ung c rptdelosreyes... IDOL galing po talaga.. wala kong masabi kung hindi MAGALING. VERY USEFUL po ung mga samples nyo also ung pagtulong nyo at payo..

You are welcome
basta may tyaga ka matuto, may tyaga din ako magturo

Mag suggest din sana kayo kung ano pa idagdag natin sa program na yan at kung ano ang gusto nyo pa makita dyan.

 

[Ronwaldo]

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

sa ngayon i can only say thank you very much sa isang eric mejia. newbie lang ako sa site at i've been reading all your posts sa VB6 forum, nasa page 100 pa lang ako sa kabila... hehehe
dati akong programmer (dos based) at im on the process of upgrading my tools and syempre my skills.. read mode lang muna ako, downloading all your samples, trying to understand them kahit medyo makabuang na..hahahaha..

more power to you sir eric. god bless...

 

[ericgmejia]

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

@Ronwaldo

You are welcome.

Ano gamit mo sa DOS dati?
Clipper? DBase? FoxBase? FoxPro DOS?


=================================================
Salamat sa mga nakaka appreciate,
yung iba kasi humihingi pa ng mas SIMPLE na sample daw,
ginawa ko na yang sample na yan, sana yung iba try to keep up nalang,
i can not teach na yung mga basic, malaking oras na ang kakainin nun.

those are codes used sa mga production level programs ko, malalaking company ang users,
its complete with error handling,
using classes and objects para flexible,
may cleanup ( Set XX = Nothing) para walang HUNG,
madaming concepts na pinakita rin, like naming conventions, indentions, etc
at marami pa

if you follow that together sa style nyo, malamang robust at unbreakable ang program mo at madali pa i maintain ang code.


Good luck.