Di na uso ang new year's resolution aminin na natin sa mga sarili natin na hindi naman tlga natin nababago lahat ng gusto nating baguhin kung mag rereflect ka matapos ang taon marerealize mo lang na wala ka ngang nabago sa sarili mo though sa iba nag wowork naman pero sa totoo lang karamihan eh nakikiayon lang sa laging ginagawa ng karamihan: ang mag karoon ng new year's resolution. Dahil sa mga ganyang reasons naisipan kong huwag ng tangkilikin ang new year's resolution subalit naka isip rin naman ako ng bago kong agenda sa darating na new year, ito'y mag set ng goals na dapat i accomplish within a year. Kung titignang mabuti at iaanalyze mas maganda ang ganitong concept kaysa mag set ka ng new year's resolution. By end of year malalaman mo talaga kung may ginawa ka sa buong taon o may naacomplish ka, magkakaroon ng magandang evaluation the whole year at lahat ng goal na naabot mo eh accomplishment yun at of course yung iba kundi kaya meron pa namang coming year para i achieve yun, basta at least may ma achieve sa mga goal but of course, achieve as many as you can hindi yung pagkatapos ng isa laylow na hanggang sa nahayaan na at mawala ka sa momentum mahirap ibalik sa dating state.
Ok ang haba ng intro considering that plano ko tlga yan this year mag set ng goal starting this 2010 onwards naisip kong gawing trend ito kada new year and by year end ay i-evaluate ko kung its a good year or not. Ngayon may mangilan ngilan nako naisip na goals. That's why I made this post para ma share na din sa mga readers ng blog ko yung mangilan ngilang interesado para naman makakuha idea or baka sakaling ma motivate ko kayo na mag set din ng goal that you need to accomplish for the whole year.
Here's My list:
I need to accomplish:
Civil Service Commision Exams
CCNA - cisco exams*
Increase Vocabulary
Write My Autobiography Draft
Ipasa ang Thesis
2 as minimum grade*
Speak Fluent English
Makapag OJT sa magandang Company*
*- Iba ang level of difficulty and I have no idea kung pano magsisimula.
Of course di lang yan lahat, I consider january as the planning month pero so far yan ang mga unang pumasok sa isip ko. I hope maaccomplish ko yang mga yan bago matapos ang 2010. Happy new year mates. Set your goals!
over and out.
Thursday, December 31, 2009
Wednesday, December 30, 2009
Year End Special
bago matapos ang taon naisipan kong mag update ng blog. Anong nilalaman?
syempre ano pa bang laman ng mga year end special kundi ang pag balik tanaw kung ano mga nangyari sa akin buong taon. Tampok dito mga highs and lows ko buong taon, masaya man o hinde kasama yun dito.
Simula ng taong 2008 wala talaga akong balak i accomplish wala akong list of activities na dapat kong tapusin wala ring kung anong bagay na dapat bilhin at wala rin akong balak makipag ugnayan sa mga tao. Tipong Come what may at Ill see what I can do ang lagay ko nun mga simula pa lang. Inaasahan ko na tlga na darating yung thesis at mga sakit sa ulo na subject pre reqs na kailangan ipasa, na may mini thesis na akala ko mahirap pero once na nalaman ko agenda ng mga profs, easy easy nlng rin naman. Yung ibang nangyari di ko na rin inaasahan, ayos din kahit papano kung irerecall ko lahat, It was a good year.
second year second sem, Sadsign and Theo takot takot pa sympre mga prof diskarte nila yun para makapanakot ng estudyante para sipagin at pag handaan ang mga subjects nila para sa iba effective at para naman sa iba hindi mas lalo lang sila di ginagahan pero sakin naman wala lang. Di ako na motivate ng mga panakot nila o nanlumo man lang sa kung ano pang ipadagdag nila sa mini thesis. Pero inaamin ko nahirapan din ako salamat sa mga kagrupo kong laging idle at ako lang ang gumawa ng simple maintenance ng database, ang gagaling nila mag cheer. Ang daming gabi ring wala akong tulog ang daming araw na umaga na ako natutulog ilang cobra ang aking naubos malagpasan lang at maiahon ang mga kagrupo. Isipin mo ng exaggeration ko lang ang mga yan pero lahat yan totoo, di ako martyr kelangan ko lang tlga, para sa sarili ko rin naman yun ako rin ang babagsak pag di ko ginawa yun. Swerte nga mga kagrupo ko pasa sila walang kahirap hirap.
Tulad nga ng sabi ni Manny Villar "sipag at tyaga lang yan", tama nga naman dahil sa sipag at tyaga eh nakalagpas ako ng second year second sem. Ok na ok dahil walang sabit. As in walang sabit, walang incomplete walang bagsak walang tres(considered sabit kasi yun) wala, flawless. Napagisip isip ko minsan ok rin naman pala maging masipag at matiyaga PERO minsan lang. Matapos ang second sem mga 2 week or 1 week break ata yun, di ko na maalala pesteng STM eh pumasok ang march, Summer. Unang papasok nyan e vacation swimming or outing pero HINDE, Meron akong summer class, ayos lang naman naging summer class ko pero mas pipiliin ko pa rin ang vacation sa bahay tumambay kumain matulog hayy ang sarap ng buhay. May magandang part din naman kahit papano parang nag silbing team building naming mag kakatropa sa school yung summer kasi isang section lang lagi kami magkakasama sa mga klase iba't ibang activities lalo na sa PE mga kalokohan sa klase mas tumibay ang samahan pero in the end na realize ko rin na ayoko palang masanay ang sarili kong kasama sila. bakit? secret
Conclusion: isa to sa mga low times ko down down!
Chapter 2
June 2009 - October 2009
Ulit matapos ang isa o dalawang linggo di ko nanaman maalala, regular sem ulit. Non-stop na pagpasok yun ni minsan di ko naisipang umabsent masipag ako pumasok dahil narin sa non-stop rin ang baon kung non-stop ako papasok, yun lang ang logic nun. Masasabi ko lang malala talaga mga umpisa neto, unang una alam kong mahirap rin ang mga subject ko nung sem na yun pangalawa di ko na kaklase yung mga kaibigan ko pangatlo bago yung mga classmates ko at panghuli ay di ko rin trip ang mga classmate ko. Nung inanalyze ko at nalaman kong ganyan nga ang kalgayan ko, di naman ako pinanghinaan ng loob. Pinilit ko rin namang i set aside yang mga yan pero di ko rin tlga maiwasan maapektuhan ng mga kung ano anong elemento lalong lalo na mga kaklase ko. Di conducive to learning yung classroom pag kasama mo yung mga taong yun, di naman lahat sa kanila ganun pero kung ang majority eh mga nonsense leechers at lagi pang mga active sa panget na trip eh siguradong apektado ang buong klase at di ako yung tipong kayang mag concentrate sa tinuturo ng prof kahit na alam kong sobrang gulo na ng klase. Alam ko may pag ka alien ako pero di pa totally alien, medjo pa lang. Isa na yan sa mga factors plus meron pa akong thesis at sa kalupit lupitan eh na grupo pako sa mga astig, astig in a way na ako ang kanilang ace player astig sa dahilang ang gagaling nila mag cheer, astig din dahil nakaabot sila ng third year na kahit konting vb eh nahihirapan sila, pero ok na rin may nababato ako ng mga ideya ko kung ano gagawin kesa naman sa wala tlga. At least meron silang compliance compared dun sa mga nauna wala tlga.
November - December 2009
Masaya. Masaya. :)
syempre ano pa bang laman ng mga year end special kundi ang pag balik tanaw kung ano mga nangyari sa akin buong taon. Tampok dito mga highs and lows ko buong taon, masaya man o hinde kasama yun dito.
Simula ng taong 2008 wala talaga akong balak i accomplish wala akong list of activities na dapat kong tapusin wala ring kung anong bagay na dapat bilhin at wala rin akong balak makipag ugnayan sa mga tao. Tipong Come what may at Ill see what I can do ang lagay ko nun mga simula pa lang. Inaasahan ko na tlga na darating yung thesis at mga sakit sa ulo na subject pre reqs na kailangan ipasa, na may mini thesis na akala ko mahirap pero once na nalaman ko agenda ng mga profs, easy easy nlng rin naman. Yung ibang nangyari di ko na rin inaasahan, ayos din kahit papano kung irerecall ko lahat, It was a good year.
Chapter 1
january 2009 - May 2009,
second year second sem, Sadsign and Theo takot takot pa sympre mga prof diskarte nila yun para makapanakot ng estudyante para sipagin at pag handaan ang mga subjects nila para sa iba effective at para naman sa iba hindi mas lalo lang sila di ginagahan pero sakin naman wala lang. Di ako na motivate ng mga panakot nila o nanlumo man lang sa kung ano pang ipadagdag nila sa mini thesis. Pero inaamin ko nahirapan din ako salamat sa mga kagrupo kong laging idle at ako lang ang gumawa ng simple maintenance ng database, ang gagaling nila mag cheer. Ang daming gabi ring wala akong tulog ang daming araw na umaga na ako natutulog ilang cobra ang aking naubos malagpasan lang at maiahon ang mga kagrupo. Isipin mo ng exaggeration ko lang ang mga yan pero lahat yan totoo, di ako martyr kelangan ko lang tlga, para sa sarili ko rin naman yun ako rin ang babagsak pag di ko ginawa yun. Swerte nga mga kagrupo ko pasa sila walang kahirap hirap.
Tulad nga ng sabi ni Manny Villar "sipag at tyaga lang yan", tama nga naman dahil sa sipag at tyaga eh nakalagpas ako ng second year second sem. Ok na ok dahil walang sabit. As in walang sabit, walang incomplete walang bagsak walang tres(considered sabit kasi yun) wala, flawless. Napagisip isip ko minsan ok rin naman pala maging masipag at matiyaga PERO minsan lang. Matapos ang second sem mga 2 week or 1 week break ata yun, di ko na maalala pesteng STM eh pumasok ang march, Summer. Unang papasok nyan e vacation swimming or outing pero HINDE, Meron akong summer class, ayos lang naman naging summer class ko pero mas pipiliin ko pa rin ang vacation sa bahay tumambay kumain matulog hayy ang sarap ng buhay. May magandang part din naman kahit papano parang nag silbing team building naming mag kakatropa sa school yung summer kasi isang section lang lagi kami magkakasama sa mga klase iba't ibang activities lalo na sa PE mga kalokohan sa klase mas tumibay ang samahan pero in the end na realize ko rin na ayoko palang masanay ang sarili kong kasama sila. bakit? secret
Conclusion: isa to sa mga low times ko down down!
Chapter 2
June 2009 - October 2009
Ulit matapos ang isa o dalawang linggo di ko nanaman maalala, regular sem ulit. Non-stop na pagpasok yun ni minsan di ko naisipang umabsent masipag ako pumasok dahil narin sa non-stop rin ang baon kung non-stop ako papasok, yun lang ang logic nun. Masasabi ko lang malala talaga mga umpisa neto, unang una alam kong mahirap rin ang mga subject ko nung sem na yun pangalawa di ko na kaklase yung mga kaibigan ko pangatlo bago yung mga classmates ko at panghuli ay di ko rin trip ang mga classmate ko. Nung inanalyze ko at nalaman kong ganyan nga ang kalgayan ko, di naman ako pinanghinaan ng loob. Pinilit ko rin namang i set aside yang mga yan pero di ko rin tlga maiwasan maapektuhan ng mga kung ano anong elemento lalong lalo na mga kaklase ko. Di conducive to learning yung classroom pag kasama mo yung mga taong yun, di naman lahat sa kanila ganun pero kung ang majority eh mga nonsense leechers at lagi pang mga active sa panget na trip eh siguradong apektado ang buong klase at di ako yung tipong kayang mag concentrate sa tinuturo ng prof kahit na alam kong sobrang gulo na ng klase. Alam ko may pag ka alien ako pero di pa totally alien, medjo pa lang. Isa na yan sa mga factors plus meron pa akong thesis at sa kalupit lupitan eh na grupo pako sa mga astig, astig in a way na ako ang kanilang ace player astig sa dahilang ang gagaling nila mag cheer, astig din dahil nakaabot sila ng third year na kahit konting vb eh nahihirapan sila, pero ok na rin may nababato ako ng mga ideya ko kung ano gagawin kesa naman sa wala tlga. At least meron silang compliance compared dun sa mga nauna wala tlga.
November - December 2009
Masaya. Masaya. :)
Sunday, November 8, 2009
Rhyming while thinking of my hunn
Free flowing, emotions arising we're high and transcending
a crazy world with full of possibilities surrounded by failures without capabilities
we're always at our prime even sometimes running out of dime but never time
Problems pops, at times tears won't stop but at the end of the day our love never stops
I love you with all my might, we both know what is right and we'll wait till we reach the day that we'll be both wearing white
Some people may delay, some people would just likely to stay even though they causes such dismay all of these won't be a factor if we have each other all day
Constant communication creates a great connection between us results in sensible discussions and meaningful conversations
And by times we missed each other, we just think and never let someone bother while thinking soon we'll see each other
mood swings, go deep inside our minds and made us think
Now thinking of the future, we have a lot to nurture to improve what we'll have for our future feature
Rest assured, I'll be sure to make our lives meaningful despite of hardships and ridicule still this will remain as a whole.
PS: tamad mag edit..
a crazy world with full of possibilities surrounded by failures without capabilities
we're always at our prime even sometimes running out of dime but never time
Problems pops, at times tears won't stop but at the end of the day our love never stops
I love you with all my might, we both know what is right and we'll wait till we reach the day that we'll be both wearing white
Some people may delay, some people would just likely to stay even though they causes such dismay all of these won't be a factor if we have each other all day
Constant communication creates a great connection between us results in sensible discussions and meaningful conversations
And by times we missed each other, we just think and never let someone bother while thinking soon we'll see each other
mood swings, go deep inside our minds and made us think
Now thinking of the future, we have a lot to nurture to improve what we'll have for our future feature
Rest assured, I'll be sure to make our lives meaningful despite of hardships and ridicule still this will remain as a whole.
PS: tamad mag edit..
Wednesday, October 28, 2009
Silence isn't nothing
I do have a plain and simple plan
and I'm so sure I don't have any fan
with this plan, I have started the race
It's set regardless of what people I face
While Fear and Shame lurking in my mind
I compartmentalize, conquer myself and find
the sea of people, fazed, intrigued about my disguise
the hate, wait, faith carved in their face as I shoot them with lies
I laugh to the fullest I think I'm the smartest
their ignorance completely describe how a failure they are
I'm not make believing because it's better than not knowing
I'm an ignoramus, better off leaving their mind confusing
With this plan that I'll lead I do not wish to succeed
instead, I just have to retain the recent status that people believe
people have been divided, defied and have been denied the truth
for my silence, never reached their minds because of a stupid fool
So I ain't gonna talk but I am gonna walk
to move forward, to motivate and talk
love drove me to stay this way although i know i'll be in shame
but I am sure, all will be pissed off at the end cursing me by name.
Does my silence puzzle your mind?
Sunday, October 25, 2009
A letter to B-One
Dear B1,
I am very thankful that you are so eager to come by here and spend time with me.
Though I know you have a lot to consider by the time I invited you, still you answered me positively with no hesitations. The only concern is whether the "higher authority" will let you go or not. But that's not the problem at all since few days after that you actually confirmed that you're coming. At first I am just grateful that finally! finally, there's a good friend whom I can bring at the night out. For a while I never thinked of you, I have in my mind that you'll come and it's given, I don't have to go further to you as my subject. My mind was focused on something that was actually nothing soon as I find out. Then things continue to progress and I started realizing that those something around me were actually nothing. It was empty, I feel like deserted, No I am deserted, I just feel like more than that. Then I actually removed the possibility of something and focuses on what I might have. Then I thinked of you, I remembered, I recalled you are not something. definitely not something, for you're the real thing.
Then I started thinking of you, the next time I know, I'm rationalizing. I asked myself Why? Why did you say yes? though you can say No that easily, there's a dozen of reasons why you have to say No and you end up saying yes. I'm not much of a good friend, I admit. I do make you laugh sometimes, but I do annoy you as well. I have never done something significant for you but Im sure you have done a lot for me. The votes and other stuffs I can't remember. as for what I've done for you, it's just a mere thanks everytime after you vote. So I clearly don't see any reason why you have to go. But then I answered in your behalf, by "what ifs" a lot of what ifs actually, I have thought a lot of good reasons and there could be a possibility that there's no reason at all. I'm puzzled, confused I overthink I questioned but all I have for an answer is my thoughts. Stupid move though I have learned If you want to know something about a person, then ask that person. Despite the fact that I know that, The truth is I'm afraid to ask, it might implicate an idea that I don't want you to go or other ideas you might think on why I asked that question. Then I ignored it and focus on you again. This time to know you more, we conversed and stay late night exchange a lot of ideas, invent jargons on us and a lot more.
I have to tell you it's fun. I would like having more of those, I would like to know more of you because suddenly you're interesting. I wish it could stay like this even after the night out. Also, I would like you to know that you've been a good friend, one of the best I've had. A friend to keep. This is my way of saying thanks, as you have said "I'm a man of words" I'll dedicate to you this epic post. Whether you like it or not it doesn't matter, the most important thing is the message that it'll deliver. If you have fun reading then thanks and If you don't I'm sorry for wasting your time. OVER and OUT.
I am very thankful that you are so eager to come by here and spend time with me.
Though I know you have a lot to consider by the time I invited you, still you answered me positively with no hesitations. The only concern is whether the "higher authority" will let you go or not. But that's not the problem at all since few days after that you actually confirmed that you're coming. At first I am just grateful that finally! finally, there's a good friend whom I can bring at the night out. For a while I never thinked of you, I have in my mind that you'll come and it's given, I don't have to go further to you as my subject. My mind was focused on something that was actually nothing soon as I find out. Then things continue to progress and I started realizing that those something around me were actually nothing. It was empty, I feel like deserted, No I am deserted, I just feel like more than that. Then I actually removed the possibility of something and focuses on what I might have. Then I thinked of you, I remembered, I recalled you are not something. definitely not something, for you're the real thing.
Then I started thinking of you, the next time I know, I'm rationalizing. I asked myself Why? Why did you say yes? though you can say No that easily, there's a dozen of reasons why you have to say No and you end up saying yes. I'm not much of a good friend, I admit. I do make you laugh sometimes, but I do annoy you as well. I have never done something significant for you but Im sure you have done a lot for me. The votes and other stuffs I can't remember. as for what I've done for you, it's just a mere thanks everytime after you vote. So I clearly don't see any reason why you have to go. But then I answered in your behalf, by "what ifs" a lot of what ifs actually, I have thought a lot of good reasons and there could be a possibility that there's no reason at all. I'm puzzled, confused I overthink I questioned but all I have for an answer is my thoughts. Stupid move though I have learned If you want to know something about a person, then ask that person. Despite the fact that I know that, The truth is I'm afraid to ask, it might implicate an idea that I don't want you to go or other ideas you might think on why I asked that question. Then I ignored it and focus on you again. This time to know you more, we conversed and stay late night exchange a lot of ideas, invent jargons on us and a lot more.
I have to tell you it's fun. I would like having more of those, I would like to know more of you because suddenly you're interesting. I wish it could stay like this even after the night out. Also, I would like you to know that you've been a good friend, one of the best I've had. A friend to keep. This is my way of saying thanks, as you have said "I'm a man of words" I'll dedicate to you this epic post. Whether you like it or not it doesn't matter, the most important thing is the message that it'll deliver. If you have fun reading then thanks and If you don't I'm sorry for wasting your time. OVER and OUT.
SINCERELY,
B2
Friday, October 23, 2009
Doubts and Changes
self evaluation of my doubts and the changes it may cause.
Thinking keeps me busy, I think in a lot of things a lot of activities a lot of ideas but I never end up thinking about a certain person for hours. Consumes my time though I'm having fun, well having conversations are fun but I don't really like conversations. Well hows that? Great! that's why I'm having doubts.
Connection, Yes, I feel somehow connected and I don't know why or is it just my imagination doing that? I 'm puzzled, I'm doubting.
Plus, I have observed that connection leads to closeness and closeness puts you in a certain position in a person's life but I don't even know if I have the capacity to try and involve myself to take a significant part on a persons life. Or maybe I'm wrong or rather I can simply try to know what it could be like. that's if I can. so this leaves me the option to explore more on what I can't do rather on focusing on what I can do. By doing so, Will I cross the boundaries and invade the unexplored part of myself? Will I take the risk? I don't know what lies there. Am I afraid? Maybe or maybe not. I don't know but I'm in the process.
to be continued for changes...(having a hard time dealing with it) lol
Sunday, October 18, 2009
Disabled Facebook Account
Friday, October 16, 2009
The Neutral Friend
I'm your neutral friend
I'm not a friend in deed
and definitely not that friend
when you're in need
I don't give any advice
but I do have some words
which can serve as a guide
to bother your time and add some spice
I'm far different compared to those stereotypes
yet I'm close being the ones with the positive insights
theres some point that I can develop something
and some point that I can ruin everything
I'm not really the type of friend to keep
and don't even bother to get involved with me too deep
for I can abandon all of you in an instance
so remember to keep your heads up and measure the distance
So am i good? or am I bad?
the answer is neutral, not chosing a side
well it is actually chosing a side
and that side is not chosing a side
maybe I'm somewhere in between?
altering the good and the bad at certain situations
maybe I'm not your friend?
pity you for considering me as one, because I don't
or this is just merely over thinking and this doesn't matter at all.
after all, you have a neutral friend to call. :))
I'm not a friend in deed
and definitely not that friend
when you're in need
I don't give any advice
but I do have some words
which can serve as a guide
to bother your time and add some spice
I'm far different compared to those stereotypes
yet I'm close being the ones with the positive insights
theres some point that I can develop something
and some point that I can ruin everything
I'm not really the type of friend to keep
and don't even bother to get involved with me too deep
for I can abandon all of you in an instance
so remember to keep your heads up and measure the distance
So am i good? or am I bad?
the answer is neutral, not chosing a side
well it is actually chosing a side
and that side is not chosing a side
maybe I'm somewhere in between?
altering the good and the bad at certain situations
maybe I'm not your friend?
pity you for considering me as one, because I don't
or this is just merely over thinking and this doesn't matter at all.
after all, you have a neutral friend to call. :))
Monday, October 12, 2009
emow
bago matulog
gusto ko munang mabusog
sa mga flashes ng mukha mo sa screen
para sa panaginip ko nandun ka rin
uh. wala pa ring kupas!
fuck, malamang late ako nito bukas
pero ok lang dahil ikaw ay nasilayan
sapat na para ako ay maligayahan
so pano? pagkatapos ng ilang minuto
ako'y solve sa sarap ng specialty mo
hanggang sa susunod na madaling araw
magkikita tayo emow
gusto ko munang mabusog
sa mga flashes ng mukha mo sa screen
para sa panaginip ko nandun ka rin
uh. wala pa ring kupas!
fuck, malamang late ako nito bukas
pero ok lang dahil ikaw ay nasilayan
sapat na para ako ay maligayahan
so pano? pagkatapos ng ilang minuto
ako'y solve sa sarap ng specialty mo
hanggang sa susunod na madaling araw
magkikita tayo emow
Sunday, October 11, 2009
Simple Maintenance
FORM1 CODE:
Private Sub S_LOAD_FLEX()
Dim strsql As String
Dim rs_load As New ADODB.Recordset
Dim a As Integer
a = 1
S_SET_FLEX
strsql = "select * from book_tab"
With rs_load
.Open strsql, conn
If .EOF = False Then
Do While Not .EOF
flxBook.TextMatrix(a, 1) = !ISBN
flxBook.TextMatrix(a, 2) = !bookdesc
flxBook.TextMatrix(a, 3) = !bkpub
flxBook.TextMatrix(a, 4) = !bkaut
flxBook.Rows = flxBook.Rows + 1
a = a + 1
.MoveNext
Loop
.Close
End If
End With
If flxBook.Rows > 2 Then
flxBook.Rows = flxBook.Rows - 1
End If
End Sub
Private Sub S_SET_FLEX()
With flxBook
.Clear
.Cols = 5
.Rows = 2
.AllowUserResizing = flexResizeBoth
.SelectionMode = flexSelectionByColumn
.ColWidth(0) = 200
.ColWidth(1) = 1500
.TextMatrix(0, 1) = "ISBN"
.ColWidth(2) = 1500
.TextMatrix(0, 2) = "BOOK NAME"
.ColWidth(3) = 1500
.TextMatrix(0, 3) = "PUBLISHER"
.ColWidth(4) = 1500
.TextMatrix(0, 4) = "AUTHOR"
End With
End Sub
Private Sub cmdAdd_Click()
cmdAdd.Visible = False
cmdSave.Visible = True
End Sub
Private Sub cmdDelete_Click()
Dim strsql As String
Dim rs_del As New ADODB.Recordset
Dim ans As Integer
ans = MsgBox("Are you sure you want to delete this record?", vbYesNo)
If ans = vbYes Then
strsql = " delete from book_tab" & _
" where isbn ='" & txtISBN & "'"
rs_del.Open strsql, conn
MsgBox "record deleted"
S_LOAD_FLEX
CLEAR_ALL_TXTBOX Me
End If
End Sub
Private Sub cmdEdit_Click()
cmdEdit.Visible = False
cmdEsave.Visible = True
End Sub
Private Sub cmdEsave_Click()
Dim strsql As String
Dim rs_save As New ADODB.Recordset
strsql = "update book_tab set " & _
"bookdesc = '" & txtBkName & "'," & _
"bkpub = '" & txtPub & "'," & _
"bkaut = '" & txtAut & "'" & _
" where isbn = '" & txtISBN & "'"
rs_save.Open strsql, conn
MsgBox "Record Updated"
S_LOAD_FLEX
cmdEdit.Visible = True
CLEAR_ALL_TXTBOX Me
End Sub
Private Sub cmdExit_Click()
End
End Sub
Private Sub cmdSave_Click()
Dim strsql As String
Dim rs_add As New ADODB.Recordset
strsql = "insert into book_tab " & _
"(isbn,bookdesc,bkpub,bkaut) " & _
"values(" & _
"'" & txtISBN & "'," & _
"'" & txtBkName & "'," & _
"'" & txtPub & "'," & _
"'" & txtAut & "') "
rs_add.Open strsql, conn
MsgBox "Record Added"
S_LOAD_FLEX
cmdAdd.Visible = True
CLEAR_ALL_TXTBOX Me
End Sub
Private Sub flxBook_Click()
txtISBN = flxBook.TextMatrix(flxBook.Row, 1)
txtBkName = flxBook.TextMatrix(flxBook.Row, 2)
txtPub = flxBook.TextMatrix(flxBook.Row, 3)
txtAut = flxBook.TextMatrix(flxBook.Row, 4)
End Sub
Private Sub Form_Load()
S_LOAD_FLEX
End Sub
Module code(connection String)
Public conn As New ADODB.Connection
Public Sub main()
Set conn = New Connection
conn.ConnectionString = "Provider = MSDASQL.1; Data Source = Book_cn"
conn.Open
Form1.Show
End Sub
Public Sub CLEAR_ALL_TXTBOX(frm As Object)
Dim obj As Object
For Each obj In frm
If TypeOf obj Is TextBox Then
obj.Text = " "
End If
Next obj
End Sub
Note:
here's a simple vb program that can add, update and delete record.
Provided with code, you just have to copy and paste it in your code window then provide the right interface and object names for you to be able to run it smoothly.
as for the database, you need the MyODBC 3.51 driver and you have to create the fields on SQL table. field names are given, make sure that you entered the right field name to avoid errors while running the program. just refer on the pic. above for database setting.
btw this program doesn't include restrictions and validations on it.
questions? feel free to pm or mail me:
mail: antisocialnoob@gmail.com
YM: alucardallan@yahoo.com
Subscribe to:
Posts (Atom)