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

[markk_2005]

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

ayy sayang, kala ko Crystal Report yung sample.. Prehas lang ba yan sila SIr?.. crystal report yung required ng teacher namin eh.

 

[ericgmejia]

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

ayy sayang, kala ko Crystal Report yung sample.. Prehas lang ba yan sila SIr?.. crystal report yung required ng teacher namin eh.

Haaay, naghirap na akong gumawa, di pa maapreciate.

Kung marunong ka ng isang reporting tool, madali nalang aralin yung iba.
E kung yung native reporting ng VB6 di mo alam, what more sa crystal?

Besides naghihintay ako ng suggestions wala nagsasalita, ngayon saka may kikibo.

Ayaw ko din gumawa ng sample na gumagamit ng third party tools kasi di lahat meron nyan,
conflict sa versions, pag vb6 i use crystal reports 8 or 7 lang, ayoko ng 9 pataas.
I use VB.NET para sa Crystal 9 up.

Kung wala dito hinahanap mo, the web is a big place.
Im just trying to share this.

BTW, ask mo nga ang prof mo kung licensed ang school nyo na ipagamit ang Crystal Reports sa students?
Because they cant require you to use unlicensed software.

Dapat may agreement and Crystal Reports and the school para dyan,
and so far wala ako alam na ganyan na school dito sa atin.

 

[markk_2005]

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

opps, high blood naman po ata kayo Sir. Tinatanong ko lang naman kung prehas lang ba ang crystal report at yung data report. Ewan ko kung license yung Crystal report na binigay nung teacher namin, basta yun yung pinakita nya'ng sample.

Anyways, magtatanong na lang po ako ulit sayo sa panahong di ka na po highblood. ;p

 

[rptdelosreyes]

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

big thanks for this!!

 

[CodeKid]

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

sir, bakit wala sa version 3 yung Database? nakalagay po ba? or sa kin lang wala??

 

[ericgmejia]

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

sir, bakit wala sa version 3 yung Database? nakalagay po ba? or sa kin lang wala??

Gamitin mo yung sa version2

 

[maui1127]

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

Salamat nalang po sa Effort TS pero wala ata may makakasolve nito especially kung hindi ikaw ang nagsumula....

Suko na ako..Hehehe...No idea eh...Thanks nlang po!...

 

[markk_2005]

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

Sir, suggestion. wat if multiple delete sa items?..

edit: about sa data report, la rin bang comments kung pano mo po ginawa?..
senxa, noob eh.

 

[ericgmejia]

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

Sir, suggestion. wat if multiple delete sa items?..

Multiple DELETE;

Simple:

gawa ka ng form,
i-list mo sa CHECKED ListView ang lahat ng item,
i check mo ang gusto mo i delete
then run a DELETE query sa ADODB.Command object
one for each checked item sa listview

try mo.

trivial nalang to kung kabisado mo ang mga BASIC SQL Statments like SELECT, INSERT, UPDATE, DELETE

 

[markk_2005]

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

tnx Sir.. nagawa ko na po yun. pero may bug eh. yung mga naka CHECKED items, nadelete. pero yung naka highlight na item(uncheck) ay nadedelete din.

Sir, how can I fix this error?..
image attached.

 

[ericgmejia]

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

tnx Sir.. nagawa ko na po yun. pero may bug eh. yung mga naka CHECKED items, nadelete. pero yung naka highlight na item(uncheck) ay nadedelete din.

Sir, how can I fix this error?..
image attached.

loop and check if ListviewItem is CHECKED,
if true then delete, if not, lampasan mo lang

 

[markk_2005]

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

Sir, suggestion po.. pano yung mga applications na may "save" function, then create back up..
pde nyu po ba gawan ng sample yung program nyu?

 

[ericgmejia]

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

Sir, suggestion po.. pano yung mga applications na may "save" function, then create back up..
pde nyu po ba gawan ng sample yung program nyu?

Backup ng database? just use FileCopy function

Focus lang tayo sa database related functionalities, yung mga borloloy kayo na bahala

 

[markk_2005]

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

opo Sir, yung parang mag ba browse ka ng folder kung san mo pdeng back up yung database mo po.

 

[ericgmejia]

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

opo Sir, yung parang mag ba browse ka ng folder kung san mo pdeng back up yung database mo po.

Yung ngang FileCopy na function

Try mo

Gammit ka ng commondialog to browse a folder
then
Syntax:
FileCopy sourcefilename, destinationfilename

FileCopy "c:\cardata\pic.jpg" , "c:\data\mycar\pic.jpg"

 

[markk_2005]

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

Yung ngang FileCopy na function

Try mo

Gammit ka ng commondialog to browse a folder
then
Syntax:
FileCopy sourcefilename, destinationfilename

FileCopy "c:\cardata\pic.jpg" , "c:\data\mycar\pic.jpg"

pa check po Sir,

kung ganitong format po ang syntax ko,
FileCopy "c:\cardata\pic.jpg" , "c:\data\mycar\pic.jpg"
napapagana ko po..

ngunit nu'ng tinry ko yung commondialog, ayaw na po mag save.

eto code

Private Sub try_Click()
Dim OriginalFile As String
Dim MyDatabasefile As String

OriginalFile = App.Path & "data.mdb"

CommonDialog1.Filter = "Database Files|*.MDB"
CommonDialog1.DefaultExt = ".mdb"
CommonDialog1.FilterIndex = 3
CommonDialog1.Flags = cdlOFNOverwritePrompt
CommonDialog1.DialogTitle = "Save database"
CommonDialog1.FileName = MyDatabasefile

CommonDialog1.ShowSave

If CommonDialog1.FileName = "" Or CommonDialog1.FileName = OriginalFile Then
If Left(App.Path, 1) <> "\" Then ChDrive Left(App.Path, 1)
ChDir App.Path
Exit Sub



FileCopy App.Path + "data.mdb", "C:\WMdbase" & Date$ & ".mdb"

End If



End Sub

wala din namang error.. tama po ba tong format ko?
FileCopy App.Path + "data.mdb", "C:\WMdbase" & Date$ & ".mdb"

baka po kasi specific address yung sourcefile na kelangan, diba?

 

[ericgmejia]

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

pa check po Sir,

kung ganitong format po ang syntax ko,
FileCopy "c:\cardata\pic.jpg" , "c:\data\mycar\pic.jpg"
napapagana ko po..

ngunit nu'ng tinry ko yung commondialog, ayaw na po mag save.

eto code

Private Sub try_Click()
Dim OriginalFile As String
Dim MyDatabasefile As String

OriginalFile = App.Path & "data.mdb"

CommonDialog1.Filter = "Database Files|*.MDB"
CommonDialog1.DefaultExt = ".mdb"
CommonDialog1.FilterIndex = 3
CommonDialog1.Flags = cdlOFNOverwritePrompt
CommonDialog1.DialogTitle = "Save database"
CommonDialog1.FileName = MyDatabasefile

CommonDialog1.ShowSave

If CommonDialog1.FileName = "" Or CommonDialog1.FileName = OriginalFile Then
If Left(App.Path, 1) <> "\" Then ChDrive Left(App.Path, 1)
ChDir App.Path
Exit Sub



FileCopy App.Path + "data.mdb", "C:\WMdbase" & Date$ & ".mdb"

End If



End Sub

wala din namang error.. tama po ba tong format ko?
FileCopy App.Path + "data.mdb", "C:\WMdbase" & Date$ & ".mdb"

baka po kasi specific address yung sourcefile na kelangan, diba?

You have to check kung may "\" yung path bago mo idugtong ang filename.

The way you use the commondialog, medyo kakaiba.
Suppose to be e gagamitin mo lang ang FileName property ng Commondialog, try to practice using the control.

Always check and verify the path kasi di ka sure kung may "\"

 

[haruka07]

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

Eh sir panu kaya i copy yung data sa mdb papunta s another mdb?

 

[ericgmejia]

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

Eh sir panu kaya i copy yung data sa mdb papunta s another mdb?

Meron import and Export function ang MSAccess, pde yun to copy data from a databse to another.

Kung gusto mo sa VB, then do a READ and INSERT
Read sa DB1, INSERT sa DB2

 

[haruka07]

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

Meron import and Export function ang MSAccess, pde yun to copy data from a databse to another.

Kung gusto mo sa VB, then do a READ and INSERT
Read sa DB1, INSERT sa DB2

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