You are here:
- Home
- Computing/Technology
- Basic
- Visual Basic
Visual Basic/Questions Answered by Expert Kevin Watkins
| Subject | Date Asked |
| Storing Data | 12/16/2011 |
| Q: i am new to VB programming.i have created form for updating my business details.with this form how i ... A: I apologize it took me so long to get back to you. What you need to do is a bit more complicated ... | |
| UPDATE command Syntax Error | 12/3/2011 |
| Q: R\Sir i want to UPDATE the previous stored values with new values i write code for this is: ... A: For starters you for loops are going in the wrong direction. For on thing: For j = 1 To ... | |
| vb6 | 11/22/2011 |
| Q: i have an application developed in vb6 with access as my database which runs perfectly in the m/c ... A: The path is not the file name the path includes the drive and folders were the files can be found. ... | |
| VB.net split | 11/16/2011 |
| Q: first of all...thanks 4 ur time.how could i split a text file like "name;category;salary"(5 lines ... A: You would need something similar to this: Try REM Test that File Exist and/or file was ... | |
| Merging Excel and Word | 11/3/2011 |
| Q: I am by all accounts a rookie in programming, and I feel like this is a fairly advanced question so ... A: It sounds like you have already started writing a program with MS Office integrated. That being ... | |
| program no fitting on some PC's | 1/3/2008 |
| Q: I was wondering why it is when I create a VB6 program it looks great on my laptop, but when I run it ... A: In VB their is the form layout window. By default it should be at the lower right of the larger VB ... | |
| Access to Excel Integration | 1/1/2008 |
| Q: Happy New Year Kevin, This seemed like a simple thing but can't get it to work. I have an Access ... A: What I have in one of my programs is as follows You will also need to declare a variable for the ... | |
| Access to Excel Integration | 1/1/2008 |
| Q: Happy New Year Kevin, This seemed like a simple thing but can't get it to work. I have an Access ... A: The only problem I see is Change the following: With xlwkbk 'xlwkbk.ActiveCell(8, 3) = ... | |
| VB integration with Access DB 2000 | 8/3/2007 |
| Q: I have used the Microsoft Jet OLEDB.4.0 to connect to a access DB through VB. It runs only on my ... A: Is the drive X mapped on both computers or is drive X: mapped to the system that has VB on it? If X ... | |
| Automatically delete columns with certain values | 8/1/2007 |
| Q: Is there a way to delete every column that has any cell in it with the value '2004' in an entire ... A: I do not know of an easy way of doing what you want. The only I can think of doing this is to set ... | |
| Unrecognized database format | 8/1/2007 |
| Q: On my old system, VB6 runs fine in Windows 2000, including linking to an Access database with ... A: The only thing I can think of is that the version of Microsoft Jet OLEDB will not support the ... | |
| qn on VB6 | 7/30/2007 |
| Q: I have a file which is saved as notepad. how to open the file in vb and display it in my listbox. A: To open a text file use the following code. Dim FF as Integer FF = FreeFile open "Textfile.txt" ... | |
| Adding items to combo box during run time | 7/26/2007 |
| Q: I am using VB6.0 I have two combo boxes , namely combo1 and combo2. For E.g, I say Combo1.AddItem ... A: You can do this one of two way. You can add them at design time by entering them in the list field ... | |
| Access to notepad via VB 5 | 7/11/2007 |
| Q: Good afternoon. I was wondering if you would be able to help me write the appropriate code to make ... A: First you need to set some references, go to Project > References and check the "Microsoft Word 9.0 ... | |
| Vb6-Read text files and compare the data in it... | 3/30/2007 |
| Q: Below is the example of data for text file "text1.txt". Daily totals Rain mm Day Jan Feb Mar ... A: What type of file are you using Random or Sequential? I have only used random files once and did ... | |
| Password Coding | 3/24/2007 |
| Q: I have created a login form, only the password needs to be inputted. I am trying to link a password ... A: The best way to handle a database, with MS Access at least is to use a ADO (Access Data Object) You ... | |
| Visual Basic(vb+MSaccess), Iam an Inter | 3/15/2007 |
| Q: How to access each item from the list in DataCombo control. I used Combo box to fill the data from a ... A: When you say Data Combo are you referring to a Data Control? This looks like a Text box with two ... | |
| Encrypting a password file | 3/12/2007 |
| Q: I have a password file and I can currently check logins against the file, but the file is in plain ... A: Unfortunetly Visual Basic does not support encrypting files. I wish it did several times I have ... | |
| When VB program executed in XP it gives Data access error | 2/27/2007 |
| Q: I have written an app which uses the ms data control for Excel file (dao350.dll). This runs fine on ... A: I have not used any of my programs written on XP on a 98 machine. I am guessing that you are using ... | |
| VB6 - DataGrid | 2/23/2007 |
| Q: I have few questions in Vb6. 1. How to grab particular record in text fields by double click on ... A: For your first question use the dblclick sub. Their should be two pull down menus at the top of the ... | |
| How to show 10th record in textboxes | 2/20/2007 |
| Q: I have table with three fields date,product,quantity. and file name product.mdb,how to display ... A: I am not exactly sure how you can do this. The first thing I try is as follows. Keep in mind that ... | |
| saving data | 1/31/2007 |
| Q: i have question about saving data.Do you think that if saving data to excel with takes more time ... A: I have saved data to text files, Excel spreadsheet and Access Data base. I have not saved data ini ... | |
| Opening HTML files | 1/16/2007 |
| Q: The application's help feature is in the form of a web page and I do not know how to open the file ... A: Copy and paste the following line of code under your Option Explicit at the top of the form code ... | |
| VB code and excel sheet | 12/29/2006 |
| Q: I wrote a VB code in excel and it work fine (if the sheet that have the macro is the first sheet on ... A: The first thing I would do is get rid of all the If then else. This: If . . . Then . . ElseIf . . ... | |
| VB6 and Access | 12/28/2006 |
| Q: I have a data base in access and a list box in vb6. The list box gets data from a record set (one ... A: You need to set up a connection from your VB program and the access file. Add an ADO data control ... | |
| Adding a new record | 12/27/2006 |
| Q: Good day! I am new to Visual Basic 6 Programming. Using ADO control, I can connect VB6 to MS Access. ... A: I am not sure what you are doing with the following code Do While adoBooks.Recordset.EOF = False ... | |
| Visual Basic | 12/21/2006 |
| Q: i have this button that has the function of previous and next... the problem is when it reached the ... A: You have the right idea but try this: Dim INTResponse as integer If adodc1.recordset.eof = true ... | |
| Master/Detail Form | 12/19/2006 |
| Q: I have VB 6/Sql Server 7/Win XP. I want to create a Master/Detail form using Article_master table ... A: This site is were you can get questions answered with problems you may have are unable to figure out ... | |
| help me with this please! | 12/19/2006 |
| Q: would you please help me with this programme? I want to write a programme in VB6 which give me 2 ... A: This site is were you can get questions answered with problems you may have are unable to figure out ... | |
| Visual Basic .net | 12/14/2006 |
| Q: Can u send me a code to make a calculator program in VB.net A: This site is were you can get questions answered with problems you may have are unable to figure out ... | |
| vb6 | 12/13/2006 |
| Q: I just want to open a mp3 file. I thought that maybe a command like open.strPath would work (not) ... A: Copy and paste the Private Declare function in the public declarations of your form. Private ... | |
| Data Report | 12/12/2006 |
| Q: I workout Data Report in Visual Basic 6.0. The following error is occured. ... A: I will need more information then what you have provided. If possible copy a paste a minimum of the ... | |
| Empty row cannot be inserted. Row must have at least one column value set. | 12/11/2006 |
| Q: I have some action buttons which I wanted to use for adding, cancelling and updating recordset. I ... A: Databases are different from spreadsheets in many ways one of which is that spreadsheets will allow ... | |
| vb | 12/11/2006 |
| Q: sir, allow me to ask about visual basic,i have a problem about what codes can i use,im using visual ... A: It depends on what type of data you want to send or receive. You can use database, text files and ... | |
| Create folder & copy folder/file during Installation | 12/8/2006 |
| Q: I have a big problem which I feel is small to you. I am a beginner in VB6 teaching myself with some ... A: You can create folders with the FileSystemObject. You will need to add a reference to RunTime ... | |
| Visual Basic | 12/8/2006 |
| Q: I have three existing files that were created in notepad. They are the following: C:\test.txt, ... A: In VB 6 you do not need to open notepad. You can access or create text files in the following way. ... | |
| How does a sub or Event access its own name or calling Control | 12/6/2006 |
| Q: I have Forms with a Lot of controls, each with unique names (i.e. no Control arrays). Now I want to ... A: You can access controls, text boxes, check boxes etc on a form from another form by preseeding the ... | |
| about active x pop ups | 12/4/2006 |
| Q: OK I HAVE NEVER HEARD OF ACTIVE X.BUT I HAVE A MYSPACE AN EVERYTIME I CLICK MY FRIENDS PROFILE TO ... A: Active X is how Internet Explorer interacts with non web programs. Open Internet Explorer, on the ... | |
| Winword.exe application error while inserting data in Word | 12/2/2006 |
| Q: I’m using Visual Basic 6.0 Enterprise Edition and MS Word 2000. I have created an application that ... A: The way I work with word in my vb programs is as follows. On the Project Menu click References and ... | |
| Record Already Exists | 11/29/2006 |
| Q: Am back with a new problem. I stack , i dont know what to write and were the code should be(i just ... A: I am not sure what you want because none of the code you have in your last message makes any sense. ... | |
| VB 6.0 App.Path gives run-time error when ran from CD-Rom | 10/9/2006 |
| Q: I want to run my .exe file from a CD but when I do I get a “Run-Time error ‘5’: Invalid procedure ... A: Are you trying to write to the App.Path? That is the only reason I can think of that would cause ... | |
| VB6 textbox to msword report doc | 10/9/2006 |
| Q: i am a beginner in using MSWord as a report tool, what i am trying to do is to capture text in a ... A: Dim DOCWord As New Word.Application DOCWord.Documents.Add DOCWord.Visible = True You can use With ... | |
| Word Form Fields | 9/22/2006 |
| Q: I have a Word Form that contains 175 form fields. I need to export the data in the form fields into ... A: The way I work with text files is as follows Dim FF as Interger Dim STRTextFile as String FF = ... | |
| Combobox dropdown list from MS Access | 9/17/2006 |
| Q: I asked this question here before, but I simply can't get an answer...that actually works... So here ... A: If you send me your code I would be more than willing to make the necesary changes to accomplish ... | |
| Selecting and printing multiple pages in Excel using VB Script | 9/17/2006 |
| Q: Kevin: I'm fairly competent at the advanced features of Excel, but somewhat a newbie at the VB ... A: Sorry I have not responded sooner I have been working 16 hours daysthis week. Try this. Just copy ... | |
| Dbase | 9/11/2006 |
| Q: I am beginner user of Visual Basic. How can I retrieve database from dbase format through Visual ... A: You will need to add a ADODC toyour form, then create a connection string to the database file. ... | |
| vb winsocks | 9/9/2006 |
| Q: my question is: when i create programs with wincocks, later on i can run these .EXEs only on PCs ... A: You may need to install the VB 6 run time Libraries on the systems with out VB 6. You can find more ... | |
| MS Access 2000 and Check boxes | 9/7/2006 |
| Q: I have tried using that code and it still skips over the If statement as if it doesnt recognize the ... A: What code is above the if statement. Their may be something before the If statement that cases the ... | |
| Couple of Questions | 9/7/2006 |
| Q: AnotherQuestion 1 - When choosing the Employee ID nothing is filling it is just coming up blank. I ... A: Q #1 Your Employee number may not be filled in for any number of reasons. Q #2 I need to know how ... | |
| Couple of Questions | 9/6/2006 |
| Q: FirstI am trying to fill three fields when an Employee ID is choosen, EmployeeName, Phonenumber, and ... A: First queation Your information is to broad. What error number or message are you getting or what ... | |
| Listbox and Adodc | 9/5/2006 |
| Q: i have a listbox where i add attachments to go with my added records.the contents of these lstbx r ... A: If you do not mind send me the project files in a zip file. That way I can run the project and see ... | |
| Creating folder and copying file or another folder in to it. | 8/30/2006 |
| Q: I have developed a program using the VB6.0 Enterprises Edition Package & Development Wizard. On the ... A: You can use File System Object (FSO) to create and manipulate files and folders. You will need to ... | |
| Link list box in Access/Excel | 8/26/2006 |
| Q: Kevin, Thank you for your responce, i havn't started writing the code yet as i am not sure how best ... A: What I am thinking is using text files. One text file is a called ‘Company.txt’ the others are ... | |
| Link list box in Access/Excel | 8/25/2006 |
| Q: I am trying to link together combo boxes so that one box determines the data displayed in the other. ... A: I know exactly what you want to do, however I need to take a couple of days to think about the best ... | |
| zero length string error | 8/25/2006 |
| Q: I am creating a databse program and part of it is a DAO data control. When I click on the "move ... A: I di not ever recall getting th error message that you are describeing. I am not sure if the ... | |
| how can I trap the change event of these controls which were added at runtime in Excel 2000? | 8/11/2006 |
| Q: I have a User form with a frame. In that frame, I add TextBox controls during run time using VBA of ... A: It depends on what you what to happen when the user presses the tab key. The following code for ... | |
| Reading a sequential file | 8/6/2006 |
| Q: I am translating a quickbasic file to visual basic. I need to read and write to sequential files ... A: Although I have used Quick Basic a ways back, I never used Text files with it. However in VB6 the ... | |
Visual Basic
Answers by Expert:
Kevin Watkins
Top Expert on this page
Expertise
I have written several programs integrating with MS Office including Access, Excel, and Word. I have used control arrays as well as data arrays, text files. I have an associates degree in programming. Please do not ask questions about VBA or dot net. I can only answer questions about Visual Basic 6.
Experience
I have written several programs integrating with MS Office including Access, Excel, and Word. I have used control arrays as well as data arrays, text files. I have an associates degree in programming.
Education/Credentials
I have an associates degree in computer programming.
©2012 About.com, a part of The New York Times Company. All rights reserved.