| Subject | Date Asked | Expert |
|
| Reading text file | 11/15/2008 | Mangesh Deshmane |
Q: I am trying to write a simple piece of code that collects two numbers from a line in a text file. ...
A: here we expect you have only one line in your text file. Now we need separate this data into array, ...
|
| Multiple listboxes | 11/15/2008 | Mangesh Deshmane |
Q: I have two list boxes and what i want to do is when i press a button the first LB will display "10" ...
A: If both the list box having values in sequence / by index , then when you click on first LB i.e. 10, ...
|
| VB | 11/13/2008 | Mangesh Deshmane |
Q: I am new user of VB ,i want to devlop the small project using vb and oracle ,can i get the sample ...
A: To use more than 1 transaction from 1 record set In VB we have to use loop. i.e. do while loop ...
|
| removing blanks in listbox | 11/13/2008 | Mangesh Deshmane |
Q: im using this command to add a item in the listbox with one command button. List1.AddItem ...
A: Dim i As Integer 'counter Dim isaAdd As Boolean 'control on existing item from list 1 isaAdd = True ...
|
| creating popup window | 11/11/2008 | Mr Basic |
Q: Respected Sir, i am developing a LIBRARY project, i took two textboxes one for student ...
A: You will need to place code behind the Key like so: Private Sub txtStudentName_KeyUp(KeyCode As ...
|
| Help in VB | 11/11/2008 | Mangesh Deshmane |
Q: Can you help me with this in VB or Excel? I have these data in excel (please note: column # is ...
A: --------------------------------------- A B C D E --------------------------------------- ...
|
| vb excel | 11/10/2008 | Mangesh Deshmane |
Q: I am a beginner in VB Excel. Is it possible to create a Macro to perform data entry onto a VB form? ...
A: To passing a loop over blank cells is more risky, because in such case u has to know where to store ...
|
| Centralized Path | 11/10/2008 | Mangesh Deshmane |
Q: I have prepared a project in VB6 and prepared its database in Access 97.In this project i have fixed ...
A: while define a Connection use following code and always try to keep a Path in application path range ...
|
| check box | 11/8/2008 | Mr Basic |
Q: I want to insert the selected check boxes value in access database i have multiple check box ...
A: What is your question? Do you have your tables set up or are you wanting advice on table structure? ...
|
| vb excel | 11/6/2008 | Mangesh Deshmane |
Q: I am a beginner in VB Excel. Is it possible to create a Macro to perform data entry onto a VB form? ...
A: As you mentioned you have Form in VBA,1 Button and 2 Text Boxes. So Add a code on Buttons Click ...
|
| Creating a variable for saving a file in EXCEL VB | 11/4/2008 | Mangesh Deshmane |
Q: I have a macro-heavy file that at the moment, saves the various files it opens with the name: ...
A: there is one option in macro is Auto_Open . use this, while u open ur file it will copy ur cell ...
|
| Hi | 11/4/2008 | Frank G. Dahncke |
Q: I'm new to VB and I have created a text box to hold total value. I wana restrict this text box to ...
A: You can't do that with a textbox control, but you can do it with a control named either MaskEdit ...
|
| VBA and time operations | 11/4/2008 | Richard Rost |
Q: I would like to know if MS Access has the ability (some function) to fill the time and then ...
A: Yes, MS Access can do this relatively easily with the Now() or Date() functions. There are some ...
|
| vb and access | 11/4/2008 | Mr Basic |
Q: i want to add a search button to VB interface which gives the whole data that about 1 machine that ...
A: Hopefully I've understood your question correctly. You have inputted a record containing the details ...
|
| Copy | 11/4/2008 | Mangesh Deshmane |
Q: I am developing one application, I am unable to the copy the contents of a textbox. Please let me ...
A: I explain you one easy method for copy. As u r not mentioned here ur size of data. So u do one thing ...
|
| Editing list box items | 11/3/2008 | Mr Basic |
Q: Private Sub lstClasses_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As ...
A: If you have the code I have provided behind the listbox's click event and no code anywhere else ...
|
| Press key to pause or exit macro | 10/31/2008 | Mangesh Deshmane |
Q: I currently have a macro that takes a set of data from a test and plots each line on a graph using a ...
A: In do loop it is very difficult to get value from outside - subject to excel macro. Laso the excel ...
|
| Editing list box items | 10/30/2008 | Mr Basic |
Q: Private Sub lstClasses_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As ...
A: Try coding behind the click event of the listbox instead. 'Module level track of last selected ...
|
| change the direction of backspace | 10/29/2008 | Richard Rost |
Q: I want to change the direction of backspace in richtextbox.The backspace deletes character which is ...
A: Use the DELETE key instead of the BACKSPACE key. Anything beyond that would involve customizing the ...
|
| Do While Loop | 10/29/2008 | Frank G. Dahncke |
Q: How do I calculate a total after the Do While Loop has been activated?
A: You will have to break out of the loop. You can do this in two ways: a) By setting a terminating ...
|
| coding | 10/28/2008 | Mr Basic |
Q: How to Open,read,write,close a file ?
A: Give this a try: Dim intFil As Integer intFil = FreeFile Open "C:\test.txt" For Output As ...
|
| system registry settings | 10/28/2008 | Mr Basic |
Q: how to read write a string into system registry during installation time in vb 6.o
A: Sorry about the delay in getting back to you. You can use the SaveSetting and GetSetting functions ...
|
| compute standard deviation | 10/27/2008 | Mr Basic |
Q: I need to write a program in which the user can compute the standard deviation of a group of ...
A: The code below should work. Create a proj with a form named form1. Add 3 command buttons named ...
|
| access and vb connection | 10/26/2008 | Mr Basic |
Q: i am creating an application using access 2003 as database.And all the forms i designed to satisfies ...
A: Yes you will need a connection string to identify your database. Make a reference to Microsoft ...
|
| For...Next Loop | 10/25/2008 | Mr Basic |
Q: I have a question about For...Next Loops in VB.NET. I have to create a small program using the ...
A: I'm not at a machine with VB so excuse if this is not 100% but the following should be very close to ...
|
| Strip space delimited strings | 10/24/2008 | Richard Rost |
Q: I am able to import strings into a visual basic 6 program, but I need to strip the string into ...
A: There is a SPLIT function which you can use to break this up into an array on any character - in ...
|
| VB5 and VB05 | 10/23/2008 | Mr Basic |
Q: In VB5 I used to work on access databases like this: Set Ws = DBEngine.Workspaces(0) Set Db = ...
A: I'm not a .NET developer really. In the little I have done it went something like this.....: ...
|
| C++ Compiler using vb.net | 10/23/2008 | Frank G. Dahncke |
Q: i am making a c++ compiler using vb.net i have managed to do most of the job. i am sending the file ...
A: Yes, it is possible - by using a technique called "threading". However, threading is generally very ...
|
| How to use drivelistbox & filelistbox | 10/23/2008 | Richard Rost |
Q: I am trying to use a drive list box on a form to select a specific drive like (c) drive @ run time ...
A: Brian, explaining how to use these in detail here would take much more time than I can spend. ...
|
| VB Dates | 10/22/2008 | Mr Basic |
Q: I have a input form which takes an arrival date in a textbox and similarly the number of nights to ...
A: What locale is your machine set up for en-us/en-uk etc..? Are the columns you are sending the dates ...
|
| Date formatting | 10/22/2008 | Richard Rost |
Q: I have a input form which takes an arrival date in a textbox and similarly the number of nights to ...
A: It seems like an International Date setting problem. Check your Windows time/date settings and make ...
|
| VBA | 10/21/2008 | Richard Rost |
Q: This is NOT a homework question!!! I am working on a project using MS Access 2003 and I need to ...
A: If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You ...
|
| How to select a particular string from List Box VB 6 | 10/21/2008 | Mr Basic |
Q: I am new with VB6. Now I am learning list box properties. Can anybody solve my problem? I have a ...
A: Create a project with a form. On the form add a listbox and a command button and paste the following ...
|
| SQL - retrieving data from the database | 10/20/2008 | Mr Basic |
Q: Hey!!! IM STUCKKK :( lol Do you know the code to retrieving data from the database? We are using ...
A: You need a reference to Microsoft Activex Data Objects library. In your code you will need to place ...
|
| Passing a value from one form to another | 10/20/2008 | Richard Rost |
Q: I have two forms both with a field named 'Change Control Number' (both set as primary key in the ...
A: Just put it in your button that does the form open: FormName.Show FormName.TextBox = Value I'm ...
|
| VB6 and Access Database | 10/17/2008 | Mr Basic |
Q: Are you familiar with creating a database programmatically with VB6? I have a problem, and ...
A: Sorry for delay, been away from machine. I've tried your code and found the following issues: 1) You ...
|
| Importing from Other Excel File | 10/16/2008 | Mr Basic |
Q: We have a process where our internal customers submit a request for work, and we export that request ...
A: VBA is not my area but from what you have told me it sounds like you need to know how to get the ...
|
| vb.....adodc.............. | 10/16/2008 | Mr Basic |
Q: this is shweta again.............u hav told me to be a bit more clear...........ok fine......... i ...
A: You need a rererence to Microsoft Activex Data Objects library(I have 2.6) Option Explicit Private ...
|
| regarding combobox in vb.net | 10/15/2008 | Richard Rost |
Q: i am fetching data into comobox from a column of a table but i only want unique values to be ...
A: Use an aggregate query to show unique values. To do this, use an Aggregate Query... also called a ...
|
| save txt file as current time | 10/14/2008 | Mr Basic |
Q: txt file but the file name will be the current system time how can i do this?
A: Try this Dim intFil As Integer Dim strTime As String intFil = FreeFile strTime = ...
|
