10,991 Topics
 | |
| | I am using this query sql="select * from student" if rs.state=1 then rs.close rs.open sql,strcon,3,3 while not rs.eof datagrid1.datasource=sql datagrid1.refresh wend where as rs is a recordset variable and strcon defines the connection to the data base. please guide me for correction  |
| | Hey people, I have quite a big code and want it to be repeated until the conditions are met. The problem is that every time I try to use Do...Loop statement, my program becomes "hung". Or even when I try to replace that statement with other methods, the program still … |
 | I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find … |
| | Hi, I am trying to find a solution for a problem.. I've got a string but I need to format it in a specific type.... #-0.6|141.443719976486|59.8780753410541|-0.6|140.736613195299|59.1709685598 #534359|59.1356132208082|-0.6|140.821466009042|59.1851106954913| #17|-2.03|141.39422501803|59.828577866371|-2.03|140.78611066998259.2204660345 #9042|59.1851106954913|-2.03|140.821466009042|59.1851106954913|#40.82146600902.03140.786110669982|59.2204660345506|-2.03|140.786110669982| #9042|59.1851106954913|-0.67|141.429577840862|59.7932225273117|-0.67|#140.821466009042|59.185110695491| I am trying to end each line with "|" and move the rest of the characters to the next line.... …  |
| | hello all, my self anil i am doing some timepass work in VB for practice. i am creating a webbrowser and i need some help i am creating it by using some components like microsoft internet controls. now i have created stop,refresh,back,forward,home buttons succsessfuly but i want some help from … |
| | Hello, I have written a program in visual basic 6 for controlling pumps on an addressed rs232 or rs485 network. Currently the names and addresses of these pumps are stored in an excel file which can then be edited by the software at runtime to add/remove pumps from the network. … |
| | Hi Frends, I m creating an access to VB6 connectivity Project. I ahve problem that VB6 Gives not me permition to leave any field NULL so when i save my record it genrate ERROR 94 That is invalid use of null value In my project it is not necessary to … |
| | Is there any way how i could compare arrays like pattern matching or should i write my own code? Thanks. |
 | hi guys, i was trying to sum up all the balances of clients to know which of them has reach their credit limit but my codes are not working. It shows an error and highlights on this code [code] rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & … |
| | Ok. Need some help with a project at my work. Wanting to create a useful map of the windfarm where I work. (Once completed, will be the largest windfarm in Europe :-)) Anyway have created a map of the site showing the locations of each turbine. Using this map as … |
| | hi i'm creating a program with the same effect as the green screen used in the movies and i'm having problem in getting the right value of green colors, but when i uses black or white as a color to be mask it works but not with the green, can … |
| | Hi All, I am new programmer, I have to create list of item which are selected from list box . It should be displayed like " a,b,c,d,e,f " How can I do ? it can be in a string or numeric . only selected Item is required to display displayed" … |
| | Hi Guys, I want to ask about dat file. How can I create a code for read and write dat file with VB ?, eg : string string 0.5000, 40 0.7699, 60 0.8431, 70 1.6754, 50 string string For above example,The code read string value in line 1 and 2 … |
 | Hello Everyone, I'm Uploading this Project for the ones who need Help regarding VB's MSCHART CONTROL!!! This Sample Shows : [B]1) How to Show Data from an Access2003 Database on Chart. 2) How to Print Data from MSChart Control. 3) How to "Save As..." the Chart, as .Bmp file.[/B] Hope … |
| | What is the difference between crystal report and data report in vb. how to create crystal report and data report in vb.  |
| | Hi, I m inserting Record in Access using VB6 SQL statement as follows [code]Dim str As String On Error GoTo solve str = "INSERT INTO [compinfo]([cID],[cname],[address],[add2],[city],[Postno],[mob],[phno],[faxno],[email],[workday],[offtime],[saldate],[duedate],[amount],[paytyp],[web],[type],[expdat],[charge]) values (" & "'" & txtcomid.Text & "'" & _ "," & "'" & txtcomnam.Text & "'" & "," & "'" & txtcomadd.Text & … |
| | i have developed an application which uses TRIM command and MSCOMM command. When i am running the exe file in any other computer, error shows in TRIM command.Error shows some component missing. Then i loaded VB 6.0 in the new computer still error continues. Then i tried my software in … |
| | I have created some subroutines and User Defined functions in Excel's VBA. Internal to them, I have created arrays. I would like to use Excel functions on these arrays, but can not seem to. For example I would like to use the determinant function, which is mdeterm in excel. If … |
| | Hi guys, Hope you will be able to help me with this problem. The problem that I have is that I have two .xsl files that are uploaded to the same specified folder at 4pm everyday. The file names are the same apart from the end digits specifying the date … |
| | I need to copy the data from the top row of a worksheet to all those empty rows underneath it UNTILL you get to a row that has data…then start over and copy that new data into the empty rows….and so on… I have the code that we've written so … |
| | Hi Everyone! Need help in my new Project with Visual Basic 6.. I need to send a 5 volts signal from my pc using a VB6 program to the serial port where I could place a relay... Thanks :) Dexter A. |
| | Ok, I have this code as an ex.: [code] Private Sub Command1_Click() Dim L As Long, L1 L = Label1.UBound L1 = L + 1 Load Label1(L1) Label1(L1).Move Label1(L).Left + Label1(L).Width Label1(L1).Visible = True End Sub [/code] If I press the button two times, it will make two copies of … |
 | Here is some old VBA code inside a Word 2003 document to open and then save a word document: [code] Documents.Open FileName:=docFileName, ConfirmConversions:=True, _ ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", Format:=wdOpenFormatAuto 'do stuff to the opened file here... ActiveDocument.SaveAs _ FileName:=docFileName, _ FileFormat:=wdFormatDocument, _ LockComments:=False, _ Password:="", … |
| | Hi everyone, I have a tiny problem here but just cant handle it, since I'm new to VB6.. I want to put a code into a module which contains a lot of lines with same objects. I have an idea of relating those objects with variables, so instead of, for … |
| | hihi.. how can i upload a folder to the FTP Server instead of uploading file by file. ??? ocw |
| | Hi, How can add 4 rows and 6 columns into MsFlexGrid1 with Command_click event in VB6? Thanks |
| | Hi friends I need some help from VB and Oracle guru's. I am trying to create a dynamic table from VB 6.0 in Oracle (mean I want to create a table whose name is dynamic issue) For this purpose I code as follow and get error table name is not … |
| | Hi everyone! I want to have a coin toss on my program: i have two images (a heads and tails) and i want the user to click on a button which will generate one of these pictures randomly. There's all this code on how to create a random number generators, … |
| | Hi, When i click on a datagrid, the selected row's id is added into a text or combo or listbox. User will see and navigate through the added items but, can't change. What is the best way to do this? I need to disable changeable property of text or combo … |
| | Hi, I populate data from database to datagrid but, cursor focuses on last row. How can i make it focused on to first row? Thanks  |
The End.