Visual Basic 4 / 5 / 6 Forum

I know very little about excel and if anyone has looked through the Access forum i am just gettting my feet wet with VB coding. Is it possible to do VB code in Excel that will look at a column F in all four of my tabs, and if a cell in the column F says "completed" it will be moved to another Tab Called "completed" in my work book?

HI, What i trying to do is when a user try to add new item that already in the table (example try to add a "name" that already in the "Name_Table") msgbox pops up and tell the user that the name is already in the table is there anyway to do this in Visual basic 2005 Thanks (Any help)

Hello to all, can anyone please help in how to import the excel file into Access through VB Code. I have written a prog. but i m getting error as "Sntax Error in From Clause"

I'm looking to add custom menu bars to a VB program. It was actually written in VBA with Access, and I have a custom menu on the access menu bar, but I want to hide the access window, so I need to move the menu bar onto the VB form, how do I do this? Thank-you in advance.

Hello everybody. I have a problem in fso.copyfiles in vb6.0.Please help me in copying files and how to rename them. Thanks

I want to be able to have someone click a command button, then have a directory form show, that part is complete. Now i need help adding all the files in this directory to a list with the extensions ".mp3, .wav, and .mid". this is what i have so far. Private Sub cmdAddDir_Click() Dim di As New IO .DirectoryInfo ("c:\") Dim diar1 As IO...

Hello, i want to write an array to a text file using visual basic. the output should look like this for a 5X5 sized array. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0

Hi all. I'm new here and also new in VB programming. Just need a little help from you all. My question is how VB can read data in calendar form. The coding that I create is like this. For Day = 1 To 31 Line Input #2, strLineDataED 'intMonth = 0 'Np = 1 'For Month = 1 To 12 'strMonthP(intMonth) = Format(Mid(strLineDataED, 1, 7),...

Hi, Can anyone tell me how I can generate a tone in VB6 I need to be able to set the frequency and duration in ms it also needs to go to the line out or speaker out of the sound card. I have limited programming experience, so a detailed explanation is appreciated Thanks..

HI...Im researching for how to auto filter the text box while im typing inside it (ex. I type A in the VB textbox and all records that have letter A will appear dropdown and as I proceed typing Am all records that have Am will appear dropdown) plzzzzzzzzzzzzzz..... any one can give me some code how to do this in my VB 6.0 project....Im using sql...

Hi There, I have written a little script that should splitt FirstName, Mr.Ms.Miss and LastName. However, the raw data I received with which I will have to use my VB script, is a bit more complicated, and I can't solve that challenge yet. I need some tips from experts. :-) 'Uses the Excel VBA split function Sub MyExcelSplitCells() Dim...

hi i would like to open a document template (saved as a regular .doc), replace a couple of instances of "XXXX" with a user-specified number. i imported the library "microsoft word 11.0 object library" and tried playing around a little with the syntax help in vb6, but didn't find anything helpful. is there an easy way to open a document, run...

Hi pals.. i hav developed an application in vb nd am tryin to connect using oracle.. it gives the following error using ADODC and ODBC "test connection failure because of an error in initializing provider.driver for oracle]" please help..

Hi everyone, I have 4 textboxes on form1. On runtime the user will be asked to fill in names. After that, I want these names placed RANDOMLY on 4 labels (form2). How should I do that? I am trying it for ages but I still don't have a clue to get them random. Please help me. Cindy

Hi. I am very new to VB. Using VB 2005. I have worked for 25 years with procedural progamming, but never object or event driven. I have a form with a tab control and 10 tabs. Each tab has a tree. Each branch of the tree is a menu selection. The parameter for a generic subroutine is contained in the node tag. I would like to capture ANY...

Hi. Does anyone know how to implement queue in VB6.0 ? I just need the push function to push end of queue and pop to remove an item from top of the queue.

hi everyone, I want to make a quick access to the first button in the tool bar.To start a transation on press Enter Key from the Enter pad. or you can assume that I want to set a default selection on one menu option.I can't program fro keypress or keydown evern for the mdiform.What I should do ? thanks in advance farhana

Hello, I'm doing a vb project which contains some data in flexgrid the data in the flexgrid can change upon each and every execution . Now each data in the grid correspond to one particular icon in the form so when the user clicks on the grid i want that particular icon to start blinking .I'm not able to achieve it .Plz can someone help me out...

Hi... How to add 4+6 when you use two textbox, the first textbox is for the input and the other one if for the output..

Hi all, We all have seen a close button on right side of title bar on any form in vb6.0 I want that if i click on that button form doesn't terminate a timer control will enabled. Suppose if i click on close button a msgwill appear or a timer control will enabled true. But form will not terminated. Thanx

Ok thanks to venna I now have a timer working on my login form which when I go to another form the counter still ticks over. Now I've been working on a way of detecting when the mouse has been moved so that I can set a value, say to 1 when it is moved and then the timer gets to 60x5 (5 mins) it sets a value to 1 and then if they're both one...

Hi All I have a menu bar in vb6 project. I want to set default control to the first option. If the menu bar has following (File Edit Purchase Report...) I want to set default control on first option of File. So that user may press Alt button to do that. Can someone help?

I have created a keyboard program i am using a textbox as the output and buttons for the input. is there anyone who knows hw i could use the caps lock feature i am currently tryin 2 use a check box however the problem arises after i uncheck the box because if i pres another button the letters still apear in CAPITALS

Hi everyone Please help me in getting any other colors, which are not available in the VB 6 Color Pallette. Can we get any dll for that?

Hi. I want the user to input a password on an inputbox. How do I make this without showing the actual password? In textboxes you can set the view to all ********. How do I do this in inputboxes?