12,155 Topics
i have three arrays below [code] l = 0 For k = LBound(Tstk) To UBound(Tstk) Tstk(k) = stk(l) l = l + 1 Next k [/code] [code] z = 0 For x = LBound(qty) To UBound(qty) qty(x) = Text5(z).Text z = z + 1 'Tstk(x) = stk(z) - Text5(z).Text 'Print …
Hello everybody, my program have been working and today I'm getting run time error 1004 - invalid number of arguments on this line of code: [code]mystr = "Comments:" & "'" & xlApp.Clean(Trim(rsin![Comments]))[/code] Also, I am getting a "Runtime error 1004 - unable to set the RowHeight Property of the range …
hi! i m nu to VB pl.explain how to connect VB to Access data basic using ADO control, if any other way, pl do help me. than u.
HOw are you all. Can i ask about vb 6.0 in creating a progress bar. please let me know on how to create a progress bar. plz plz plz
I want to use the chart control. I have the data in a recordset which i need to show in Chart. can anybody help me
I am developing a program in Visual Basic .Net 2005 to launch an external program, using the Process Control. I am trying to use FindWindow to retrieve the handle of a top-level window. Declare Auto Function FindWindow Lib "USER32.DLL" (ByVal lpClassName As String, ByVal lpWindowName As String) As IntPtr However, …
In the code below I get a runtime error 13 or error 2036 or error 2007. The program uses Solver in excel to find best fit solutions for a matrix of i and j values by minimising error values (Val8a). the run time error message occurs at 1 of 2 …
i have a search program that when searched i will make a receipt, a reciept form will be displayed, the 1st item searched will be displayed on text1(0).text and the quantity also will be displayed in text5(0).text my problem is how to subtract the stock items minus the quantity text5(0).text(its …
I am using the VB editor in Microsoft Excel and have come upon a slight problem. Basically, I wrote a macro that allows me to copy an array of data from one worksheet, and then paste it into another worksheet. (So by using the macro, I can automatically update the …
when i convert a program into an application it brings database error
I am trying to write a simple CRC calculator in VB6 I am converting a C code(listed below) I need to use a bitwise & operator. I have read that the Imp operator is what I should use, but it does not give the correct results Here is the code …
[B][/B] Hi Members, please can anyone show me how I can write a blank line after writing each records? My intension is to space out the data in the spreadsheet for readability. So far the code I'm using is not doing it. Seem my module below: [code] i = 5 …
[B][/B] Hello everyone, I have a spreadsheet that has data in a report format. The last column "Description", has long text value which are all bunched up inside one cell. My intension is to merge(expand) the text to fill other cells (G, H, I) and make it readable. [B]See spreadsheet …
I have successfully created a command button on a form to do a search on a primary table for a key, entered data on the form and saved it into a second table. However the key for that second table does NOT get saved (but does show on the form). …
Hi guys, Is is possible to pass the parameter to autocad thru VB6 and generate drawing. Or already developed design in Autocad and is it possible to modify thru VB6. If you have any information abt it. Plz suggest me. Regards kishor Mungelwar
Dear helpful members I would like to know how to make a batch of files--> save data into them--> close them For simplicity I was planning to call each file "i j"(i space j), where i=1 to 30, 1 and j=0 to 90, 10 so there would be a total …
I am currently developing audio player project in vb6. i have downloaded a dll file named "WinampPluginWrapper.dll" i make this dll file methods inherit from vb class. But i try to execute the file i got error that " WinampPluginWrapper.dll" not found. Then i Placed this dll file available to …
Hi, can anyone tell me from where can I download and install the crystal reports to use in vb6? I need the site url. Help please... Thanks in advance
Is it possible to get the color of the character under the mouse cursor in richtextbox?
I have written my code in VB6. I would like the code to pause when variable x = 1, and the program will continue when I hit a key or something of that sort. Could you give me a hand on this? ThanX
Good people, Please can someone show me how I can add a permanent comment to the end (footer) of my spreadsheet. I want this comment to be visible when the spreadsheet is printed. I know how to add the comment on the spreadsheet that is visible only when you hover …
Hi. First i want to say taht I'm relly glad I found site like this. I LIKE IT!:) I'm noob in vb. I'm trying to work in vb6.0. i have some ideas like: creating some picture catalog, or making a game, i'm intersted in animcion...But my cnolege in vb is …
i have a question..I have a problem of rotating a 6 pointed star or a star david.. What codes do i need to rotate it?? it rotated in every angle and it somewhat like in 1 revolution around 32rotation..and how do i animate it??can u help me please..thank you very …
i want to make a program that you can add some product details later in and you can then type the product code of a product and it is added to a report that you can print as a receipt to a customer showing the price of each product and …
[code] Set Worksh = Worksheets("SampleWorksheet") Set myRange = Worksh.Range("F1") msgbox myRange.Value, , "" 'WORKS: current value in "F1" cell is displayed myRange.Value = 100 'DOESNT WORK! : value in cell DOES NOT change [/code] I have no idea - it was supposed to work. Any ideas? Thanks
Hi. This is my first post and i'm a newbie. I'm learning to use VB6 and i'm trying to create a simple alarm clock but having a type mismatch error. It seems that the input time does not match the clock time. i have here the code. Hope u can …
I am trying to reference a LOGO (the LOGO was inserted in the document as a picture) so that I can set its visible property to true or false as required. However I havent been able to find out how to reference the inserted picture file. Can anyone help me …
I try to open excel file in visual basic 6. Somebody gave me this code to open excel file. But when i create a my new form and type this code. An error occured for this code Private Sub Form_Load() Dim x_app As Excel.Application Dim x_wbk As Excel.Workbook Dim x_wsh …
Hello,friends.. im a new gurl here.. i want to ask, how to transparent the background of the image on PDA/Mobile Simulator. Actually,im using Pocket Mobile at Microsoft Visual Studio 2005. now im using .gif image format. if i built it at windows application, i can get the transparent background image,but …
Hi, can any one tell me how to create variables during runtime. This what we generally do when we need to create string of fixed length like - [B]dim x as string * 5[/B] now i also need to do it dynamically. suppose i need to declare two individual variables …
If Anyone can help am trying to build a Web proxy server it works on most sites but it does not want to work with Secure web sites that uses the CONNECT [url]www.domain.com:443[/url] String can anyone tell me where i can get info on howto use that command and is …
Hello everyone, I am having a display problem within my spreadsheet. The data in the spreadsheet row is hidden. Looking at the spreadsheet, you will see that the row that contains the "comments" is hidden, but when you manually expand the cells, you see the data. I have a code …
[code] Private Sub CommandButton7_Click() 'UAD_FLG Dim sValue1 As String Dim sValue2 As String Dim sValue3 As String Dim sValue4 As String Dim sValuex As String Dim sscript As String Dim sscript2 As String Dim sscript3 As String Dim x As String Dim finalstring As String Dim temp1 As Integer Dim …
I've built a Datatable that reads in a text file does some manipulation on it and then It's just sitting there. I've only been doing This for a few weeks and have been Stumbling through it at best. A friend of mine sent me this and said that this should …
Hi friends, I designed a simple application based on MCQ's with Access as Database and DAO as the method to connect to the database. The problem is that the application is working fine on my system but on any other system it is giving an error "ActiveX object can't create …
Hello. I have recently started receiving the above error message that pops up periodically, but enough to be completely annoying. I believe it must be some kind of virus. The full error is as follows: Titled "Project 1. Run-time error '384.' A form can't be moved or sized while minimized …
Hi.I don't know where to post this ... please help. I'm trying to put each character in a string into an array. Private Sub cmdNameslow_Click() Dim username As String Dim index As Integer Dim myArray() ReDim myArray(Len(username)) 'prompt username username = InputBox("Enter your name", "NAME") 'display username one charachter at …
Please tell me the necessary code to read a first table for information then search a second table. If no match, add a new record to the second table. Thanks!
dim a as checkbox dim b as string b= "check1" a=b this code give me error. is ther any fuction to convert string into an object ? like cstr(). or what is the procedure to convert a string into an object ? plz help me. i need help
Hello all, I have this program where I look through all the rows in the excel file I use... Cells(1, 1).Select Set rngTPT = .Range("A1:A650") but I dont want to have a range limitation. How can I go through the file but not give it a limitation? I was trying …
how i can browse More than file from my pc to my program *More than file not one file ex: when we need to listen to music in windows media player we can selcet alot of music
I am started a new with VB6 Access project. I am connected database with ADODB, DSN Method that Code Given below. '================In module ============== '============ Connection With Database =============== '============================================= Public CNN As New ADODB.Connection Public RS As New ADODB.Recordset Public cString As String Public Sub Main() Set CNN = …
Hi ... I am totally new to vb programming.I have to do something like this for this i am not having any idea,kindly help me. I have two excel files-- file one has data like thi--- 601A 600 580 780 48 300 33 601B 600 580 780 48 300 601C …
I am a beginner in programming and has got the flur to write an application that will pick human voice and assign the correct instrumental pitches and tones to it. The component to use and the necessary code is beating me up. Help me out ! Lizo.
Hi, I have a report desigend in Crystal Report 11. The report has 2 sections which is divided in between by a simple dark line. The report's left side has the fields of TABLE A and will be used to show records from TABLE A only. And the report's right …
I'm a school guy from Sri Lanka.Still im not following any course.I'm very interesting in doing programming with VB6 and using some books referenced VB6 .I'm a apprentice. My question is * How to disable the Close Button? *Can we have links with external softweres like WinZip etc through VB6?If …
Can someone provide me with VB code of International Data Encryption Algo IDEA. I will be using it for cryptanalysis.
Does visual basic work with autocad? Is it possible 2 use datas 4m autocad drawing in vb? Does anybody know anything like stated above? Please let me know.
Hi All I'm new to posting in forums so forgive me is this is in the wrong layout. I have a small problem with a project I'm working on for myself. I need to graph some data in a simple curved graph the x axis is constant 0 to 60 …
The End.