12,425 Topics
 | |
| | what's wrong with the code, it doesn's display the data based on the SQL query: Private Sub cmdSearch_Click() On Error GoTo Notfound squery = "": squery = "Select * from tblStation where Station like " & txtStation.Text & "" Call ExecuteCommand With Me .txtStation = rs!Station .cboCluster = rs!Cluster .txtArea … |
| | I am running the following Update Query in my program and I am encountering the following Error: Run-time error '2147217900 (80040e14)': Syntax error in UPDATE statement Here is the code i am running My module contains the following code: Public UserName As String Public UpdatePassword As String Public rsUpdateUserQuery As … |
| | hi all, I have one problem with resizing forms. I am developing our application in vb and i gave code for resizing forms in resize event of form. First i save the sizes of all controls in forms in form load event and then in resize event i resizes all … |
| | Where should I get the declaration ADODB.Stream Object? as far as i know, ADODB library has only 4 objects: Command, Connection, Recordset & Parameter. I need this object for the Image DB. thanks |
| | Hi, im working on a Computing A Level project, it involves making a virtual Ballot Box. One of the things the Ballot Box is required to do is to choose the winner by determining which candidate has received the highest number of votes. Has anyone got ANY IDEA how i … |
| | [COLOR="Red"]URGENT[/COLOR] Hi, Ive found that earlier when i used DataControl in any of my Forms it did not give any problem worked fine. But after sometime when i started to run those Forms it gave me an error message (to debug) of "Visual Studio 2008" (Just-In-Time Debugger). I felt that … |
| | Hello, I created command object in DataEnvironment. Now I wish to change to command object's Sql Text since table name gets changed depending upon year of working. |
| | i'm doing the eigenvector and eigenvalue calculator system. i don't know how to find eigenvector from a corresponding eigenvalue!! help!!  |
| | hello, i have a problem i am trying to encrypte an xml file and decryte the file. what am doing for a comapny in canterbury kent is to create a mobile banking application in visaul basic so customer could downlaod it onto their pda using microsft ce ...which i have … |
| | good day! I want to pass the value that contains tha table name and load its data.But my sql turns error.Below is my code. [code=vb] Combo2.Text = "first_year" sql = "select * from " & Combo2.Text & "'" rs.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText [/code] Im using mysql as backend … |
| | Good day.! Thank you for all of you in this forum in helping me in all my post. I just got one last problem with my project.!Please help me on how to back up and restore my mysql database that when i click backup my mysql database named (onlineenrolement) will … |
| | Hi I'm trying to creat a numeric pyramid. I have created th code for one side but can't seem to figure out how to do the other side this is what I have so far. size = Val(txtsize.Text) Picout.Cls ' For loop to iterate over every column Dim row As … |
| | I have 2 tables Details,Mstr. Mstr table contains(PSNO,NAME,DOB,DOJ)=>PSNO- PK Details(PSNO,NAME,PH,SAL_ACC,ADV,DT_PREP)PSNO-FK In Grid i need to display SAL_ACC NAME ADV DT_PREP 12345 abc 150 5/25/2009 12345 abc 300 5/30/2009 12345 abc 200 6/11/2009 how do i do ths,please help  |
| | Hi there. I am writing a program in Access 2003 and I trying to update a forum with new strings. To explain better. The forum window is already up and I hit a button to process a command. Now I need the fields in the forum to update without saving … |
| | I have been asked to use data grid in my proj,bt i dnt knw hw to use this,please help... On click of search btn,the data should be displayed in the grid and textbox,I know how to display in the text box,but dnt knw anything abt this grid........ PLEASE HELP:S |
| | Hi All, Can anyone tell me , how to create subreport in Crystal report XI? Please give step by step procedure with example. Thanks, Shrini |
| | Hi, I have a working vb.net application that gets information from a database and writes it to an excell worksheet. So far, so good. Now when I install this application on a machine on which windows xp runs in any other language but english And a non-English version of Office … |
| | im making a hangman project in vb6 and i need some serious help with it! my prob is with my loop which is having issues - this is my code: Dim guess As String, x As Integer, word As String word = wordBank(stage) guess = Text1.Text For x = 1 … |
| | Helloo iam building vb chat application using winsock, work on LAN but problem that face me that iam tring to connect to a computer in a network this computer in a network of three computers "192.168.2.1" and "192.168.2.2" and "192.168.2.3" local Ip's and with only one internet IP, so the … |
 | If I click a button how my computer will be open? I want I click a button then my computer will be open. help me with my computer, control panel |
| | [B]Convert Case To Random In Vb6[/B] I've only 1 Textbox & 1 Button... can anyone help my? Thanks |
| | I been searching for days for a sulotion but can't seem to find one. The coed that I have does not give me an error but it does not save anything on the table either ' Can someone help me find what I'm missing? this is my coed [CODE] Dim … |
| | [i] Name: The name of this question is: carbon_copy [/i] [icode] Hello and Thank you in advance for any assistance. [/icode] [u] [b] Purpose: [/b] [/u] [b] The purpose of this code is create a desktop app and web app. The web app has the destop apps library. Create a … |
| | well i have been trying to get this thing to store in a database i created in mircosoft db any help would be appreciated. Thank you in advance Private Sub cmdadd_Click() optftime.Value = False optptime.Value = False optict.Value = False optassessmentprogramme.Value = False optdbt.Value = False opttvet.Value = False optcarrerdev.Value … |
| | Can anybody tell me .how should i print serialno of materialrequistiondetail table of matching requisition no.in descending order.here is the code what i have written. [code] Private Sub btPrint_Click() Dim sqlQuery As String sqlQuery = "SELECT MaterialRequisitionOrder.requsition_no, MaterialRequisitionOrder.job_no, " & _ "MaterialRequisitionOrder.delivery_point, MaterialRequisitionOrder.delivery_date, " & _ "MaterialRequisitionOrder.delivery_time, MaterialRequisitionOrder.suggested_supplierID, " & … |
| | 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 … |
| | I am trying to select data from a database in the based on a condition....Its just a simple select SQL query [CODE]SELECT playerid FROM player WHERE username = 'John'[/CODE] Therefore, from this I would like to store John's playerid to a variable and then use this variable. Below is my … |
| | 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 … |
| | Hi, i could really do with some help. I am trying to connect a simple button in Visual Basic 2008 Express Edidtion, to an access database in which i can get an item from the database to show in a text box. Like a till does when a product is … |
| | 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 not a professional programmer so maybe you can help me out please… I am using Visual Studio 2005, Visual Basic and a SQL 2005 Database. Everything seems to be going ok but I do need 2 things. 1. How do I “Find” a record. Let’s say there’s … |
The End.