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