- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
12 Posted Topics
 | Hi guys.. Im still working on my project, it is a payment and enrollment system. Ive been thinking what to do with the Student ID since it requires a format like xx-xxxx, its possible that ill make two fields right? i mean the first xx on xx-xxxx to make it … |
| | try [CODE]If Text1.Text = "" Then[/CODE] good luck |
| | hi guys, is this possible [CODE]Private Sub Command1_Click() Adodc1.Refresh Adodc1.Recordset.Update Adodc1.Recordset.Fields("Balance") = Val(Text1.Text) - Val(Text2.Text) Adodc1.Recordset.Fields("Amount_Paid") = Val(Text2.Text) + Val(Text3.Text) Adodc1.Recordset.Update Adodc1.RecordSource = "SELECT * FROM Tuition_Fee WHERE Tuition_Fee_ID_PK = " & Form2.Label16.Caption Adodc1.Refresh Text4.Text = Adodc1.Recordset.Fields("Total_Tuition") Text3.Text = Adodc1.Recordset.Fields("Amount_Paid") Text1.Text = Adodc1.Recordset.Fields("Balance") MsgBox "Tuition Updated" Printer.Print " Official Reciept" … |
| | u mean use of textchange? example you are making a program for grades and you want to have an exception or filter of what you are puting in.. since highest grade you can have is 100 therefore [CODE]Private Sub Text1_Change If Text1.Text >= 101 Then MsgBox "Invalid Input for grades!" …  |
| | Guys. can you help me with my project again? hehe.. sorry for flooding forum with my threads.. I have a table that have a field name Amount_Paid, Date, and Transaction_Number.. i want to add all the data that has been saved on Amount_Paid that has same that, for example, today …  |
| | how many input if requires the program? is the Textbox are trying to hide are those sum/products/diferrence/quotient that are require for final answer? if yes you can try making some textboxes outside then set its visibility to false. |
| | Hi guys, I just want to ask if its possible to print some desired fields or data that is within database or vb used on MS word.. like this one example: First Name: (Field_FirstName on db) Last Nane: (Field_Lastname on db) scan by: (Text1.Text on vb) is it possible? if … |
| | I used autonumber for my id. i attach the screen shot.. [ATTACH]13899[/ATTACH] and i dont know how to make a code for compute command.. It should compute all the payments on that day, but i really dont have an idea how to make it.. ill attach my vb and access … |
| | [QUOTE=Jx_Man;1147929]so..you on form2 and after msg u want to back to form1?right? so just showing form 1 after message.. [CODE]Private Sub Command1_Click() If Text1.Text = "" Then MsgBox ("You have no content on your 1st Textbox") Form1.Show Unload Me Else End If End Sub [/CODE][/QUOTE] [CODE]Private Sub Command1_Click() If Text1.Text … |
| | |
| | |
| | Im just having a problem on my VB 5 update command.. [CODE]Adodc1.RecordSource = "UPDATE Tuition_Fee SET (Amount_Paid, Balance) VALUES(" & WHERE Tuition_Fee_ID_PK = " & Form2.Label16.Caption 'Adodc1.RecordSource = "UPDATE Tuition_Fee SET (Amount_Paid = " & & ", Balance = " & Val(Text1.Text) - Val(Text2.Text) & ") WHERE Tuition_Fee_ID_PK = " … |
The End.