| Subject | Date Asked |
|
| 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 ...
|
