Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
2
Posts with Upvotes
2
Upvoting Members
2
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
2 Endorsements
Ranked #630
~10.8K People Reached
PC Specs
hp I5
Favorite Forums
Member Avatar for kimangel

Hi all, Kimangel is here, would like ask your help on my laptop problem. My acer laptop shutdown automatically, sometimes in just seconds, minutes, or hours. I already clean up the cpu fan, and the motherboard. The cpu fan stops after a second when turn on, that is on Bios …

Member Avatar for hithirdwavedust
1
1K
Member Avatar for kimangel

Hi expert, I have the code to delete all entries in the datagrid but it seems it will not delete just in one click. Pls help me on this. Thanks Private Sub cmdRefresh_Click() Set rs = New ADODB.Recordset rs.Open "select * from ItemPurchased", cn, adOpenStatic, adLockPessimistic Do While Not rs.EOF …

Member Avatar for dwirch
0
93
Member Avatar for kimangel

Hi expert, Just want ot ask the correct code format for moving message to a new location. MsgBox "Do you want to save?", vbYesNo, 10, 10 Thanks

Member Avatar for J.C. SolvoTerra
0
223
Member Avatar for kimangel

Hi expert, just want to ask the correct code format for moving a message box. MsgBox "Do you want to save?", vbYesNo, 10, 10 Thanks

Member Avatar for LesF
0
84
Member Avatar for kimangel

hi experts, gud am! I need your help on my DTR form. When I generate report for the total hours, the counts on the hours is correct only when time in and time out difference is more than 30 minutes but when it's less than 30 minutes for example: 12:46:13 …

Member Avatar for kimangel
0
191
Member Avatar for kimangel

Hi experts, I have listview table but when I click or double click the row the data could be changed or edited? How could I disable it but still able to select every row? Many thanks! Kimangel

Member Avatar for kimangel
0
3K
Member Avatar for kimangel

Hi experts, I have a type mismatch error in getting time difference from database. Below are my codes. Private Sub cmdSearch_Click() Dim sTrID As String Dim Total As Integer Dim xhours As String Dim Intime As String Dim Outtime As String sTrID = txtSearch.Text Set rs = New ADODB.Recordset rs.Open …

Member Avatar for QVeen72
0
301
Member Avatar for kimangel

Hi Experts, my sql query below returns 0 value, though I have entries in my data base. Please help me check my codes below; Private Sub cmdSearch_Click() Dim sTrID As String sTrID = txtSearch.Text Dim Total As Integer Set rs = New ADODB.Recordset rs.Open "Select Count(DateIn) as Total from Time_In …

Member Avatar for kimangel
0
290
Member Avatar for kimangel

Hi experts, I have a Daily Records form of an employee. my fields are; search box search button datefrom (datepicker) dateto(datepicker) datagridview (fields are Employees_IdNo, DateIn, TimeIn and TimeOut) totaldays totalhours The scenario is this, first search for an employee using Employee number, set the datefrom and dateto to two …

Member Avatar for kimangel
0
194
Member Avatar for kimangel

Hi experts, I have an update form, even without changes made in fields the form will still be updated. How can I code that the form will not update without changes made. Pls help me. Thanks alot. below is my code. Private Sub cmdUpdate_Click() If Trim(txtLastname.Text) = "" Or Trim(txtFirstname.Text) …

Member Avatar for kimangel
0
140
Member Avatar for kimangel

Hi Experts, good day! I have hard time coding the click event when I click cmdTime on the second time a message box will say, "Your first time in for 2/16/13 at 9:00:33 am, Are you sure you want to record this time in, Yes Cancel?" The time 1:22:33 is …

Member Avatar for kimangel
0
180
Member Avatar for kimangel

Hi Expert, my Option1.value is not save to databse while Option2.value is saving. Pls help me check my code. Thanks Private Sub cmdSave_Click() Set rs = New ADODB.Recordset rs.Open "select*from Employees", cn, adOpenKeyset, adLockOptimistic On Error GoTo err rs.AddNew rs!Employees_IdNo = txtSearch1.Text rs!Lastname = txtLastname1.Text rs!Firstname = txtFirstname1.Text rs!Middle_Initial = …

Member Avatar for kimangel
0
267
Member Avatar for kimangel

Hi experts, kimangel is here again, doubling my time. Thanks alot for helping. I have problem with two tables, when I click cmdSearch button searching for Employees_IdNo error occur "The specified field 'Employees_IdNo' could refer to more one table in the FROM clause in your SQL statement. below is my …

Member Avatar for AndreRet
0
177
Member Avatar for kimangel

hi experts, i have problem saving my logout entry could not be saved on database. Password & username textbox is in the login form on form 1 and lbldate & lbltime is on form 2. Log-out click is a Menu editor on form 2. Pls help me check my code. …

Member Avatar for AndreRet
0
175
Member Avatar for kimangel

Hi experts, my time value display is the word "true" on Label2.caption and not a real time. On Label1.caption the is the exact date. Only the time got wrong. below is my code: Private Sub Timer2_Timer() Label1.Caption = Date Label2.Caption = time End sub I have a timer1 the dispaly …

Member Avatar for AndreRet
0
103
Member Avatar for kimangel

Hi Sir, Kimangel is here again! Gud Day! How would I code that a cursor will automatically return to its place where it was encountered error? unless resolved. Below is my code; Private Sub txtContact_No1_LostFocus() On Error Resume Next If txtContact_No1.Text = "" Then MsgBox "Fill up the field to …

Member Avatar for AndreRet
0
199
Member Avatar for kimangel

hi experts, i have problem in displaying commas and decimal to a certain amount in a textbox and label. it only display certain amount without comma. below are my codes; ______ Private Sub lblAllowable_Change() lblAllowable.Caption = Format("4321", "#,##0.00") End Sub ____ ____ Private Sub cmdSearch_Click() txtLastname.Text = "" txtFirstname.Text = …

Member Avatar for AndreRet
0
2K
Member Avatar for kimangel

Hi experts,gud day! Here I am again needing your help. How will I code condition that textbox will only be enable after 6 months from date of hired or textbox will be disabled after typing certain amounts because it is not yet 6 months from date of hired. A message …

Member Avatar for AndreRet
0
185
Member Avatar for kimangel

hi, good day! I have problem in coding this; combo box list - positions like Manager & supervisor and a label for the Rate of each position. When I click the manager, the label below will auto display the rate for Manager which these two data, Position and Rate, are …

Member Avatar for kimangel
0
1K