Visual Basic 4 / 5 / 6 Forum

Im trying to take only alphabetical characters out of what the users input to the text field (txtinput.text).. So if i put in "The yellow man had 32 teeth!" then im trying to get results like" Theyellowmanhadteeth" anything besides characters should be stripped out of the inputed field. this is in visual basic

HI all, I wanted to monitor changes made in any excel file of each and every cell by various users in networking system. kindly provide some guidelines how to create the software. Regards Anup kumar

This is a shot in the dark, but I'm pretty sure VB can do this. I'll give some background on the problem first. I work at a casino and we use embossers to print cards for players. We currently 3 different embossers that can be switched to in order to print different cards. We have a program that is run that asks a simple A, B or C to switch it....

Hi all, I'm doing a little project (big for me because I'm pretty much a noob). I have this soltaire game and when a card is captured. I want that card to be colored with a blue background. In other words, that its been played. How would you go about comparing 1 card say the ace of spades to that same card in another picturebox? Meaning The...

Ok well this is the script that i am using to save a normal textbox. Private Sub CmdAdd_Click() Dim strNameScript As String strNameScript = "RuneScapePalScript" + FrmScripts2.TxtScriptName.Text Open strNameScript For Output As #1 Print #1, FrmScripts2.TxtScripty.Text Close #1 ErrHandler: End Sub

HI All! I am developing a V.B application. in this application, user is able to drag and drop a picture(user control) at run time also. for this purpose, i used form's "dragdrop" event. we know that to move a picture from one place to another place, it's property "dragmode" is set to automatic. Now the problem started, as my...

Hey everyone many thanks for help with my last post. This one I hope is an easy one for folks here I am opened a record set and at the begining of the do loop to begin iterating through the set the EOF value is already "true" so all my code is skipped. I check the local window and tested the sql statement in access by creating a blank query...

Hi, I'm trying to do a series of data extraction from all the sheets(Sheets A to Z) in a workbook and put the results into the first worksheet(sheet1) of this workbook. I've nested a sub within a sub. The first sub does all the extraction and the nested sub does the pasting into various cells in the first sheet(Sheet1). How do I pass the...

I'm trying to read the color information from a given pixel anywhere on the screen. I've tried it with GetPixel(h, x, y), but the result is always white. Is there another way, or how can I make it work (or already a topic about it that I missed?). I'm using Visual Studio 2008 bèta 2.

Hi all, I'm a newbie in VB.Net Programming.. Hope that some of you can help me to solve this.. I'm working out to read,parse and save textfile into SQL Server. The textfile contains thousands of rows with about 50 coloums every row.. Everythings goes well until I found one textfile with some strange character...seems to be Japanese...

The data is transferred from one table to another when user clicks on a button on the screen. The transfer takes approax 10-15 seconds. During this time I am able to move the mouse but not able to click on any buutons on the screen. It gives me a feeling as if system is hanged. Is it possible to show some processing icon during this 10-15...

hello i'm tryin to figure out how to make an animation w/o the timer loading up a separate pic every .1 of a second or watever...is there a way how to upload one image with multiple pics on it and have it only show certain parts of the pic? (like a pic that's 128X32, show the first 32X32 square, then the second starting at 64, 96, 128 then 0...

Please could some one provide me the code to validate the user name and password fields using Vb for MS access. Fields :: User name :: text box Password :: text box Login :: button The form should accept the user name and password from the text box , validate the same against a table on MS access if successful should allow the user to...

Hi, In my vb2005-project I have a x by x array as type double. To visualise what's in it, I connected each index to a label. When I run the programm, the initial array is empty, so each label contains a zero. The problem I have is, I don't wanna see all the zero's initially (on runtime). I only want to see the labels if I put a zero (or...

Hello, I made a change to an Access file this way. Dim myData As New DataSet() 'Dim mySelectQuery As String = _ '"SELECT * FROM D WHERE postoffice like ',MIHAI%'" Dim myConnection As New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\mihai.mdb") Dim strSelect As String = "update D set...

I have a form that I want to use an input box to enter an item in a combo box. How would I go about doing this so if a person has an item that isn't in the list he could click a button then the inputbox would appear and the person would enter the item in the inputbox then click OK and the item would be in the list? Could this be done? lee123

Hello everyone Am having this error an just dont know what to do. Am using vb 6 and access database This is my code code vb: Public db As Database Public rs As Recordset

I want to pause for a value < of 1 sec this is my routine for 1 sec Sub Macro1() Range("C15").Select ActiveCell.FormulaR1C1 = "12" Range("E26").Select Application.Wait (Now + TimeValue("0:00:01")) End Sub

Hello everyone Am using a For Loop to access records from my database but the code opens instead of a specific record base on values passed by the user. These values a fields in the database which i want to make keys. This a bit of the code Vb 6 and Microsof Access code Vb: If rs.RecordCount = 0 Then Exit Sub

can any one help by providing the method inserting the records in excel file because i created it all it works fine but i have no idea about how to insert new records in the existing excel file. e.g my excel sheet has filled first 20 rows and then i want to insert the new records in the excel sheet starts from 21st row is any idea about...

Since this is now a discontinued and unsupported product from Microsoft, is it ok to develop and sell software made with it now? I still have my old copy from back in my college days.

Hello World I have a problem in detecting the conflict schedule (Day and Time). Day 1. M 2. T 3. W 4. TH 5. F

Hello all I have these records on my Day Table for my complete database table please click here 1. M 2. T 3. W 4. TH 5. F 6. S

Hello expert. I made a program in which the data from an SQL table is transferred to an Excel sheet. When the data type of a field is Integer it works fine, but when the data type of a field is "numeric" it produces the error "APPLICATION ERROR OR OBJECT DEFINED ERROR" but I can't change the data type of the table from Numeric to Integer....

Follow the code: code:vb If mesge = vbOK Then rs.Open "select * from empdetail where name = '" & mName & "'", conn, adOpenStatic, adLockOptimistic txtid.Text = rs!id txtid.Enabled = False Else txtid.Text = ""