You are here:
- Home
- Computing/Technology
- Basic
- Visual Basic
Visual Basic/Questions Answered by Expert Jonathan D Roach
| Subject | Date Asked |
| IF function convert to VB in Excel | 5/21/2007 |
| Q: I am a beginner at VB in Excel and wondering if you could let me know what the script would be for ... A: Emma, The following is one way of achieving this. Open the visual basic editor in excel select the ... | |
| ranking records | 5/1/2007 |
| Q: I was wondering if you can give me some tips on how to do this. I have an access database and it ... A: Sue, I am quite a busy person so doing something like this from the ground up would be too time ... | |
| ranking records | 4/29/2007 |
| Q: I was wondering if you can give me some tips on how to do this. I have an access database and it ... A: Sue, One approach to doing this (in general) would be to create a 'Second' table that will keep ... | |
| Saving a text value to a file | 4/28/2007 |
| Q: I'm writing a small program where I would like to save a text box value to the hard drive so that ... A: Larry, Here is a simple way to achieve this. In order to save a textbox value to a file: 'Begin ... | |
| Cannot concatenate | 4/23/2007 |
| Q: This is my code: For i = 101 To 400 DoCmd.GoToRecord , , acFirst Select Case ... A: Dioshy, If you are using VB6 or earlier you need to create a control array, this is done by placing ... | |
| hex coding mystery | 4/16/2007 |
| Q: Not a basic coding question per se.... --But I have several hex editor programs which I tryout ... A: Max, You can find a boat load of info via a google search for Hex Editing Tutorials. I have listed ... | |
| VBA Variables help | 4/6/2007 |
| Q: I want to know how to refer to a worksheet with known address. For example, I made a variable ... A: Charmaine, You will need to create a variable to reference the excel object by then you will need ... | |
| Is there an easier way to save/load data? | 3/23/2007 |
| Q: Right now I am trying to make a simple spreadsheet. Is there an easier way to save approximately ... A: Donny, What would probably work best is to create a control array for your text boxes. Then in a ... | |
| Program & Data Exporting | 3/22/2007 |
| Q: I have written a number of programs using VB5. I have successfully exported some of these to other ... A: Don, I would highly recommend using the free setup creation tool InnoSetup. It easily allows you to ... | |
| the basics in MSVB | 2/25/2007 |
| Q: I am trying to write some code in access useind MVB 6.4. I am great in access but have been very ... A: Matthew, Please find below some tutorial websites for VBA in Access and general Visual Basic. ... | |
| VB Installation Package | 2/16/2007 |
| Q: Sir I had setup the application using Inno Setup. But am getting an error message while running it. ... A: Ambili, As I said, you need to create the DSN connection in your vb code, the error is quite self ... | |
| VB Installation Package | 2/16/2007 |
| Q: Sir, First of all thanks for the perfect solution given me through inno setup. 95% Percentage of ... A: Ambili, You will need to create the DSN connection from your code on any new machine it is ... | |
| Ado to read file from server | 2/15/2007 |
| Q: Think I did not word the question right, I can retreive the the zip from the blob field no problem, ... A: Darren, No problem... for this it would probably be best to use the internet transfer control to ... | |
| Ado to read file from server | 2/15/2007 |
| Q: Ive looked all over the net and cant find the answer to this one. I have a website that can download ... A: Darren, The following uses ADO to download and save images from a blob field on a remote MySQL ... | |
| hi.. | 2/14/2007 |
| Q: what is the abbrevation or meaning of EOF and BOF and thier functions? A: Aristy, These are file operation related, EOF stands for 'E'nd 'O'f 'F'ile and BOF stands for ... | |
| Storing Records from a Form | 1/30/2007 |
| Q: Jonathan, I've got a form and subform that engineers will have to go into and enter information to ... A: Aaron, Having some knowledge of the language you wish to use to accomplish this task would be good ... | |
| VB 6 & Access | 1/26/2007 |
| Q: I am practicing on VB 6. I want to know that is it possible to set time bound property to expire our ... A: Jayachandra, Have a look here: ... | |
| activating a conditional formatting macro on data entry | 1/20/2007 |
| Q: I am a complete VBA novice but have worked with Excel for a long time. I need to apply ... A: Walter, In code view choose the following procedure for the worksheet you desire this effect on: ... | |
| Error in Accounts Distribution | 1/13/2007 |
| Q: There are two list box.In the listbox name lstOpenAccounts there are three hundred values. In ... A: Kathy, This is simply going to be a matter of a count error either in a Do While Statement or an ... | |
| Word macro Save As file name | 1/11/2007 |
| Q: I really appreciate your help, but that didn't work either. Perhaps this cannot be done?Thanks for ... A: Cory, Here is what I have come up with I hope it will suffice... ' Call this first... With ... | |
| Word macro Save As file name | 1/9/2007 |
| Q: I have a macro that will save the values that are input into a form. I was wondering if it would be ... A: Cory, Have you tried setting the value of the savefilename variable? ie: change this code; With ... | |
| print datagrid | 1/2/2007 |
| Q: Good day! What codes are used to print the entire datagrid in VB6? Happy New Year and More Power! A: Paolo, Unfortunately there is no built in way to print the datagrid control from the datagrid ... | |
| different pictures in datareport | 1/1/2007 |
| Q: I AM MAKING A PROJECT OF EMPLOYEES AND I AM USING ADO CONNECTION AND BACKEND AS MS-ACCESS I WANT TO ... A: Monika, Link the data report image to a file or reference to a file that is contained in the user ... | |
| comparing functions | 12/31/2006 |
| Q: I am trying to get VB 6 to identify whether or not a word entered into a text box is a palindrome or ... A: Nicola, Start a new project add a textbox and command button, drop this code in and you should get ... | |
| VB6 inquiry | 12/22/2006 |
| Q: however after i included the userform2.Setfocus still it does opens behind the current window. Pls ... A: hamz, if you are calling the form from another form simply use the following, for example if I had ... | |
| System modal applications | 12/22/2006 |
| Q: I want to make a system modal application. I mean an application that when we run that, the user ... A: Mohsen, You will need to make your main user form modal and then you will also need to capture ... | |
| 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: Kc, An alternative to handle the clicking twice is to disable the next button when the end of file ... | |
Visual Basic
Answers by Expert:
Jonathan D Roach
Top Expert on this page
Expertise
Visual Basic Programming in virtually all areas.
Experience
I have been programming for quite some time, a huge portion of my past work has been with Visual Basic.
Publications
Planet Source Code - Visual Basic World
Education/Credentials
Computer Science Eq
Microcomputer Electronics
Networking Administration - Diploma
Grade 12
©2012 About.com, a part of The New York Times Company. All rights reserved.