10,987 Topics
 | |
| | good day.! whats wrong with this sql query.Im using mysql as backend database.it hangs when i execute this sql code: [code=vb] Dim statusko, oldstatus As String statusko = "verified" oldstatus = "to be verified" sql3 = "UPDATE paymentsummary SET status='" & statusko & "' Where username='" & ListView1.ListItems.Item(listselect).SubItems(4) & "' … |
| | i want when user clicks on save button I want to update the database and refresh the listview on the curren page. i have written a code but data is not instantly comming after save button .Here is the code what i have written.I simple Want when Press ok .addded … |
| | Hi, I want to know can I set priority to my application such that the windows will close my application first when it shutsdown! Basically I want the window to ask my application to close itself before closing other programs when its shutting down. Thaks |
| | i USED THIS CODE TO ASSIGN THE BRAND DBS TO A VALUE OF 200 [code]Private Sub xModelComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles xModelComboBox.SelectedIndexChanged If xModelComboBox.Text = "DBS" Then xTotalPriceLabel.Text = "$200,000" End If[/code] AND THIS CODE TO CALCULATE THE FOLLOWING iNITIAL PRICE= is the default price for … |
| | Hello to all the people of the forum today asking a collaboration or guidance on a process to be developed Is developing an implementation assessment, in which there exists the option to raise questions in bulk, at the time and has made the implementation of PHP for the Web version, … |
| | Ok how would i be able to set a color palette to some variables....i need it to change the color of all these vars at one time :S [code]Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.1", "0xD4AF37") Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.2", "0xD4AF37") Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.3", "0xD4AF37") Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.4", "0xD4AF37") Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.5", "0xD4AF37") Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.6", "0xD4AF37") Call ShockwaveFlash1.SetVariable("_level0.holder_mc.GLOBAL_CRUMBS.player_colours.7", "0xD4AF37") Call … |
| | hi guys wondering if you can help i have thrown together a rough and ready project using winsock, now it is just thrown together to see if i could get it to work the problem is (well it does work first of all) when i receive data it is in … |
| | [B]Need Help To Make First Letter Of All Words In A Textbox To Uppercase[/B] so, i have this code to convert first letter of word to uppercase: [CODE]Private Sub txtFields_Change(Index As Integer) txtFields(Index).Text = UCase$(Left(txtFields(Index).Text, 1)) & LCase$(Mid$(txtFields(Index).Text, 2)) txtFields(Index).SelStart = Len(txtFields(Index).Text) End Sub[/CODE] but, this was before i realize … |
| | hi all, N good morning! I am developing an application in vb. I had developed my application on my PC in 1024*768 screen resolution. When i rum my application in the same screen resolution then it runs properly but when i run my application on 800 * 600 sreen resolution …  |
| | I wish to connect 2 computers together using a crossover Ethernet cable and then write a program in Visual Basic 6 to send data between them. How do I do this and are there any Vb examples? How do I know the address of the ethernet port to open? |
| | I am trying to select data from a database in the based on a condition....Its just a simple select SQL query [QUOTE]SELECT playerid FROM player WHERE username = 'John'[/QUOTE] Therefore, from this I would like to store John's playerid to a variable and then use this variable. Below is my …  |
| | hello, im making a game, (multiplayer) and i would basicaly like an image (bullet) fly accross the scren on the vbkeyx command. however, i can not figure out how to do it. the bullet should move left accross my form but then i must have one to move right also … |
| | Hello everybody.. I have a form in my project, that's having a Grd name MSFlexGrid and a Data1. Besides, it also have a cmdCalculate and cmdExit button. Their codes are below. [code] Private Sub cmdCalculate_Click() Dim i As Integer Dim TAmt As Currency TAmt = 0 For i = 1 … |
| | I am newbie in the world of programming.. and I am using vb6.. can anyone help me to do get the data ranging it by the date. What Im trying to mean is ex: I have a data which includes data form january to june. I want to display feb … |
| | This is the code i m using for updating table,which the user is entering through textbox in vb form Con.Execute "update Details set NAME='" & txtName.Text & "' and DT_OF_BTH='" & txtDOB.Text & "' and DT_OF_JOING='" & txtDOJ.Text & "' and SALARY_ACC='" & txtAccountNo.Text & "' and REMBSMNT_ACC='" & txtRmbr.Text … |
| | Good day! Im so confused of auto incrementing a receipt number format. example i have a starting receipt no. (00000) in a mysql field called or no. when the paymentfrm load, the textbox that contains the receipt no will be added by one so that it will become 00001. I … |
| | Hi im using VB6 and I want to display the message and then beep but it doesnt beep, it only displays the message and when I click on 'OK' only then it beeps but I want to only display the message and then beep or display this message and beep … |
| | Hello there. I am witting a program in vba/access and I have a string coming in. I need to go through the string and look for specific tags and return the rest of the line. So lets say: "I went" "to the" "park" I need to tell the program to … |
| | i simple want progressbar should execute until it becomes 100 after some interval.but it is not working properly.can anyone help me .Any help would be Greately appreciated.Here is the code what i have written. [code] Private Sub Timer1_Timer() For i = 10 To 100 Step 10 ProgressBar1.Value = CInt(i) If … |
| | How can I terminate a full screen game application using VB6? I've created an internet cafe management system for my internet cafe and I want to add a feature on my program wherein I can terminate a running game application. Thanks. |
| | The control is not going to EditGoto,its is coming out of the whole sub part on report click btn Public Sub Create_Report() WordDocument.EditGoto "CurrentDate" WordDocument.Insert Format(Now, "mmm,d,yyyy") End Sub Public Sub EditGoto(inNm As String) owordapp.Selection.Goto What:=wdGoToBookmark, Name:=inNm End Sub Please help me with this:S |
| | Hi, I am redoing a VB6 application. In the print function the app determines which printer to use, I want to change this to let the OS choose which printer to use is this doable? |
 | Hi Guys, I'm getting on odd error on compilation, "Procedure too large to compile". The reason I say it's odd is that I know for a fact the procedure is not too large to compile. We have daily builds and others are able to pull the source down and compile, … |
| | I am writing a program that allows for people to answer simple questions on Capital Cities of the world. The main program works flawlessly, but I decided to add in a new function that records the user's answers to a question if they get it incorrect and posts it in … |
| | i want if requisition no is already there message should come.requistion no is already there .Here is the code what i have written.i don't know why it is not working.any help would be greately appreciated. [code] Private Sub btSave_Click() Dim row As Integer, bEdit As Boolean Dim StrSql As String, … |
| | Hi - I have two MS Access forms - 1) WorkItems 2) MyItems WorkItems is the main form, and MyItems simply runs a query against a list of NT ID's and statuses to provide the user with a list of his/her incomplete workitems. What I'd like to do is have … |
| | all i want is change all the record in my table if the pcarrier="Credit" but my problem is only one data have been changes. . [code] Set rs = New ADODB.Recordset rs.Open "Select * from Soldto where cno='" & Combo1.Text & "'", cn, adOpenKeyset, adLockPessimistic If rs!pcarrier = "Credit" Then … |
| | Can anyone help me how to do this? It will test if it is valid or invalid. Input Output name_123 Valid name123 Valid 123name invalid 123_name invalid this will test if the variable name declared is valid or invalid. |
| | [code=visualbasic] Private Declare Function Function_Name Lib "user32" () As Datatype [/code] I've found such lines used in many VB6 projects and tutorials. What is it? What actually is this used for? Are there more such function? How to find out more such function/properties? A detail explanation will be helpful and … |
| | can anybody tell me why i am getting type mismatch error in checkinput function.Here is the code what i have written.error is generatiing from bold line. [code] Private Function CheckInput() As Boolean Dim row As Integer, itemCode() As Integer 'At first always Test for Empty TextBoxes If Combo1.Text = "Dept … |
The End.