11,868 Topics
![]() | |
Hello. This is a very very basic question about variables in range names. I have quite a few ranges of varying lengths in multiple Excel documents. I want all the ranges standardized and set to the same length, but I don't know what that length will be yet, and it … | |
Hi everyone I have a table with 3 columns pk_itm_code name fk_code The pk_itm_code is taken from another master table. Now my requirement is automatic generation of fk_code fk_code = pk_itm_code + "PT" + random generated no. (startin from 1) If the user selects same pk_itm_code 2 times then the … | |
hi all i want to learn more about DLL and ActiveX control I Want the link of any site which offers learning about dll and active x in vb with Examples and demo to how to create then in step by step process Please Any one can help me in … | |
Hi All I Want To Create Semi Transparent Forms I Had done work on Transparent forms but i need semi transparent form which we can see background text/image through this form in vb please send me the solution for this | |
Good Morning All, I am having a major issue here; for some reason the line of code below works and sometimes does not work. When it desides not to work, it leaves a mess in my excel sheet. [code] Range("A1").Select ' This just goes to the upper left corner of … | |
Good Morning Guys, I am trying to copy a selected range from worksheet (or copying the whole worksheet) from file A, create a new workbook(name it and rename a worksheet in it). Then paste copied worksheet or range into new workbook. Please let me know what code to use, thanks. … | |
erm.. greetings again i have this database system using access and i need to look through another remote computer for files using Remote Administrator 2.2. how do i get started? as in to run the application and searching through folders in remote computer to get a certain txt file.. thats … | |
Hi, A program I am writing has the user entering values into textboxes then clicking an 'Add' button. Once clicked one of the textbox values appears in a list box. e.g Job Number, Data Filename, Unique Code The Unique code is displayed in a listbox. All three values are stored … | |
Would anyone know how, if it's possible, to pass a user defined type through a network connection say using winsock? For example: [CODE] type tExpl name as string address as string phone as string end type dim myExpl as tExpl winsock1.send myExpl [/CODE] As far as i know, winsock only … | |
Have been asked to convert a set of programs from QBASIC to VB6. Any real pitfalls that i should watch out for? FWIW, my BASIC experience is mainly GW-BASIC and earlier. And yes, i WILL be RTFMing. tke | |
Hi there, I am Embeza from ethiopia,Mekele Here i got a problem! It says " file path not found" while i was working on vb 6.0 in my lab on files the following was my code and can you fix plz [CODE]Option Explicit Dim var as string Dim inputFile as … | |
Hi, im having trobles with excel how I can chance the color of the text in a specific cell from vb?? any help?? | |
How can one use a Rt box to display formatted text. Imean to display different texts colors,size location and data from records:?:. Even images. Please help. I mean a texbox like this one | |
Hi All, Please help me in printing Visual Basic 6.0 form directly to the printer. I am using 'PrintForm' method of the form to print a form. I took the height of the form in pixels i.e. 17000 pixels, normally the default size of a form will be 9000 pixels. … | |
:?: Hi, I am wondering how to create a mini-program in visual basic that will place an icon in the task bar(where the startup icons are.) :?: Thanks for the help :!: jchaike | |
Hi There, Can anybody help me with the following: 1. I am trying to open an excel file using adodb connection but i got a run time error on the rs. open. Here is my code Dim cnn As New ADODB.Connection, rs As New ADODB.Recordset cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\XLS.XLS;Extended Properties=Excel 8.0;" … | |
Hi all, I am doing one Hotel Management Project There is one EPBX and all the Telephone calls information regarding roomno and telephone no and call cost will stored in that machine which can be connected to system by parallel port The Concept is When the Customer Is Vacating the … | |
hi. API: StartServiceCtrlDispatcher This API use to run services. but i cant use it in vb6. Please help me. | |
hai all, i have created a vb project in vb6 and reports using crystal report 10. my query is follows. in the project there is a form contains a combobox and in it i load the list of faculties from the faculty tabele at the time of execution. my requirement … | |
dear all, i craeted a Vb6 project and desinged report using crystal report v10. now i want to call the report from VB6. one of the members suggstion he says that "place the crystal report control and select the report name" but where i get the crystal report control? i … | |
Hi, I've been looking for a solution to this all over the web, and although I've found some approaches to it, none of them seem to really answer my question. Basically here it is: I currently have an application with a GUI in VB6. It's a pricelist Inessence, and the … | |
Hello all I need to solve a equation using excel solver from visual basic 6. i did it manually in excel and recorded tha macro. however when i trid to automate excel using vb, an error message is displayed. it highlights the solverok function and says function not valid. can … | |
Hello everybody, how can i import a text from notepad to a text box?:rolleyes: | |
has anyone ever really worked on Cubes i gotta come up with a cube and a number of virtual cubes asap | |
I need a function to draw a park with any other control. I have a database with 25000 which is divide by garden, section, and page with these parameters I make a query to select a number of records. then I need to draw each record with a textbox or … | |
hi there i am trying to write a general formula function in vb6 forexample a = 40 b = 50 c = 60 i need to evaluate the string "A + B + C" which has to return the summation of the string in terms of value can some one … | |
I've never coded in vbscript before in my life, but I need to trim some text with it. So it's basically like this... script sits on a page and if it sees a certain definable text string, it removes it. I.E. IF: "blahblah" = true, then DELETE THE FRIGGIN' CRAP … | |
if i have this text [tex] INPUT STRING: شمس LOOK-UP WORD: $ms SOLUTION 1: ($amasa) [$amas-u_1] $amas/VERB_PERFECT+a/PVSUFF_SUBJ:3MS (GLOSS): + be headstrong + he/it <verb> SOLUTION 2: ($amisa) [$amis-a_1] $amis/VERB_PERFECT+a/PVSUFF_SUBJ:3MS (GLOSS): + be sunny + he/it <verb> SOLUTION 3: ($am~asa) [$am~as_1] $am~as/VERB_PERFECT+a/PVSUFF_SUBJ:3MS (GLOSS): + expose to the sun + he/it <verb> … | |
is it possible to write a vbscript to automate task ? What I mean is recording the keystroke. If it is possible, can anyone please guide me. Thank you. I.E 1.Starts Application, 2.Click on combox, 3.enter date in(dd/mm/yyyy) in a textbox and 4.click on the command button Thanks | |
I really have a[COLOR=Black][B] BIG [/B]problem in making control arrays. The following is what i fed to the PC [COLOR=SandyBrown][COLOR=Blue]sub form_load() const n=15 dim Sam(n) as textbox for n=1 to 15 sam(n).text="SamY" next n end sub It won't work.[/COLOR] [/COLOR][/COLOR] |
The End.