10,987 Topics
 | |
| | hi need codes for displaying a negative value eg ($-1000) in the balance txt when a person pays more cash here are my codes Private Sub CmdCalc_Click() 'to declare variables Dim Nam As String Dim Unit As String Dim Amt As Currency Dim Bal As Currency Dim Tot As Currency … |
| | I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x … |
| | Hello everybody... I did a project in c++ about factorials. Now i will do it on VB6. But my problem is somehow my output is always 1. So i think my funktion i made take no action at all. Would be greate if someone can spott my error...Thank you [code] … |
| | Hi, and thanks for reading, I only hope you have a chance of helping me out, whoever you may be i thank you in advance. Here is the problem I am up against. My program is random number selector like a lottery number picker. I made it so it picks … |
| | hello.. can someone help me on my problem with regards to VB... my problem is that i want to change the value of a cell in a flex grid for example if Item no:112 is already in the flex grid and its quantity is 26...and then the next time the … |
| | Hi, I would like to perform a validation check on a field (Employee/Staff Number) there should not be duplicate entries in this field so i would like for a check to be performed when the next field is clicked then a msg displayed saying "Staff Number already exists" Any sample … |
 | Dear Sir/Madam I have a program where I have used a small form as Input / Message Box in place of VB’s InputBox / MsgBox in a click event procedure i.e CmdSave_Click(). Though the code lines are executing in that procedure at a time, the global variable GblBox is not … |
| | hi, i have created a program but don't know what to do. The condition is when text1.text = empty or it has no value then there would be a msgbox popping out. and for the else, there would be no msgbox popping out. i really don't know what's the code, … |
| | I am using VB6 and MS Access for my project. I have to make a printable page to print slips(8 on 1 page) with attributes name, id etc to be retrieved from the database for each slip. how should I approach for this? Is there any tool in vb for … |
| | EXAMPLE if i input like this " int a; " or " a+b-c=d " then the output must? OUTPUT : int = CHARACTERS a to z = VARIABLES ; = TERMINATOR 1 - 0 = NUMBERS + - * / ( ) = OPERATORS = = EQUAL |
| | gud evening to all of u folks folks im so stessed right now cause i have only two days to pass my project in vb6 which is a lending system my big problem is i dont know how to link my customers in formation table and payment table can you …  |
| | im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql.. i have this sql statement on my MsAccess [QUOTE]SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt FROM WItems INNER … |
| | This seems to be a common error, but I can't quite get it fixed in my case. The basic operation of my database / form is: Get search value Retrieve record Display record The form has two combo boxes and several text fields. Each of the combo boxes allows the … |
| | Hi, I am creating an application in vb linked with a access database and i am having problems searching records. For the team screen I have the following database query that I wish to call: [CODE] SELECT TeamName, [Section] FROM Team WHERE (TeamName LIKE ''' & TeamNameSearchTextbox.Text & ''') [/CODE] … |
| | 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" … |
| | HELLO PLEASE HELP to do a CODE PLEASE.. it give the meaning of each input.... if i input in a textbox this int a; then the output in listbox must int = characters a = variable ; = terminators |
| | <<split from [URL="http://www.daniweb.com/forums/post452669.html#post452669"]here[/URL]>> [QUOTE=QVeen72;1120857]Hi, First Check Which Form is giving the error, and also check what all components (ocx) you have used in that form.... SP2 seems very old.. What I recommend is Download and Install Visual Studio latest service pack (SP6 ) on your machine and Complie and Create … |
| | could someone help me compute the EOQ (Economic Order Quantity) in vb..? i really find it hard computing it.. i tried so many times, but i just can't get the logic out of it.. tnx |
| | HI! Anyone here got idea to add shortcut in DEsktop automatically run( using Package and Deploy Wizard)?Izzt it is possible to to? |
| | Hi, Please tell me how to sign a PDF with a digital signature using VB programming. Thanks. |
| | hi, please help me on how to use the textfield_change can you give me an example on this so that i will know how to use this..thanks in advance...hoping for your positive responds....  |
| | I have a test table where I'm using the Last() function but it seems to not work, it always return the 2nd record when i have 10 records.. [CODE]SELECT LAST(Date_Received) FROM serviceRS; [/CODE] returns the 2nd record [CODE]SELECT FIRST(Date_Received) FROM serviceRS;[/CODE] returns the 3rd record X_X |
| | Hi guys Good day. I just want to ask help on how to hide the start menu and prohibit access to it as well as the task manager and the date and time when the form loads, and restore it back when the form terminate without restarting the computer. Thank … |
| | Yeah I was stupid and pressed (X) on all of the bars to the left you know the "Solution Explorer" I think and alot of more, how do I re-enable them? |
| | 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 … |
| | hello,i think this is just a simple question but im not really familiar with the basics of VB6.0 so i am asking it, can i ask how can i set integer value on text1.text without making the value visible on the textbox when i run the program? thanks like text1.text … |
| | My problem are if you log in to the attendance system there is a 30 minutes interval before you can log - out to the system. then if you log- out to the system you can log -in again, until you complete the 8hours of working for one day.  |
| | Hiii...Iwant to retrieve the month part from dtppicker(like i want to display the monthwise reports or display a paricular month's entries from database) ..can anybody provide a solution for this? |
| | I am trying to generate a mouse click based on x, y position and not using a hwnd. I've tried several examples but none seem to work for me. I'm using VB6. Any ideas? |
| | ey, im looking some code that will open up the browse window so i can open a file for my database i have created thanks :) |
The End.