11,868 Topics

Member Avatar for
Member Avatar for DarkAlex

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 …

Member Avatar for DarkAlex
0
126
Member Avatar for haria_kishore

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 …

Member Avatar for Comatose
0
79
Member Avatar for maheshsayani

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 …

0
55
Member Avatar for maheshsayani

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

Member Avatar for maheshsayani
0
122
Member Avatar for INI

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 …

Member Avatar for Comatose
0
187
Member Avatar for INI

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. …

Member Avatar for INI
0
125
Member Avatar for BombAppetit

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 …

Member Avatar for BombAppetit
0
112
Member Avatar for purplegerbil

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 …

Member Avatar for Comatose
0
137
Member Avatar for agrothe

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 …

Member Avatar for Comatose
0
105
Member Avatar for kthompsn

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

Member Avatar for Comatose
0
309
Member Avatar for Embeza

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 …

Member Avatar for Embeza
0
105
Member Avatar for Zill

Hi, im having trobles with excel how I can chance the color of the text in a specific cell from vb?? any help??

Member Avatar for Comatose
0
142
Member Avatar for SamY

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

Member Avatar for Comatose
0
100
Member Avatar for skpalla

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. …

Member Avatar for Comatose
0
98
Member Avatar for jchaike

:?: 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

Member Avatar for Comatose
-1
142
Member Avatar for NewVBguy

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;" …

Member Avatar for maheshsayani
0
177
Member Avatar for maheshsayani

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 …

0
54
Member Avatar for Payman

hi. API: StartServiceCtrlDispatcher This API use to run services. but i cant use it in vb6. Please help me.

Member Avatar for Payman
0
313
Member Avatar for vjeshemv2000

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 …

0
52
Member Avatar for vjeshemv2000

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 …

Member Avatar for xardoz
0
90
Member Avatar for Lalo1985

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 …

0
59
Member Avatar for Shefali

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 …

Member Avatar for Shefali
0
250
Member Avatar for b.janahi
Member Avatar for Comatose
0
113
Member Avatar for snengos

has anyone ever really worked on Cubes i gotta come up with a cube and a number of virtual cubes asap

Member Avatar for snengos
0
83
Member Avatar for ejp001

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 …

Member Avatar for ejp001
0
96
Member Avatar for Ramabhadran

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 …

Member Avatar for Comatose
0
98
Member Avatar for vtechno42

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 …

Member Avatar for Comatose
0
104
Member Avatar for b.janahi

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> …

Member Avatar for b.janahi
0
108
Member Avatar for racerrunner

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

Member Avatar for stevemckann
0
126
Member Avatar for SamY

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]

Member Avatar for SamY
0
103

The End.