Date format in Microsoft Excel 2002
In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as … Exl.Range(“A1″).NumberFormat = “dd-mm-yyyy” and Exl.Range(Rng).NumberFormat = [...]

Answer Question   |  January 9, 2009  11:51 AM
Excel 2002, Excel Cell Formats, Microsoft Excel, VB, VB 6, Visual Basic, Visual Basic 6

Visual Basic If Then Statement
HELP! I normally don’t write code or develop databases but I am trying to build a MS access database. I have one table (departments) with a list of departments and one table (112) with department, question text and question answer columns. I am trying to build a form where user selects department from drop down, [...]

Answer Question   |  January 8, 2009  9:53 PM
IF statement, IF Then Else, Visual Basic, Visual Basic for Applications

Database connectivity using Data Control
Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

Answer Question   |  January 6, 2009  1:07 PM
DAO, DAO 6, Data Access Object, Database connectivity, SQL Server 2000, VB 6, Visual Basic, Visual Basic 6

Database connectivity using ActiveX control
Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

Answer Question   |  January 6, 2009  1:04 PM
ActiveX, ActiveX Data Objects, ADO, Database connectivity, SQL Server 2000, VB 6, Visual Basic, Visual Basic 6

How to create the number of images appeared where we put the quantity of images?
I create a form (browse image buttom model) using vb 6.0. I want to create the quantity field, and when I entered the image quantity the number of images appeared(where I select the browse option). Is this possible. Help me…. Thank You

Answer Question   |  January 5, 2009  6:39 AM
VB, VB 6, Visual Basic, Visual Basic 6

How to convert DBGrid database information to text files with VB 6
how to convert dbgrid database information in to text files (vb 6.0)

Answer Question   |  January 7, 2009  3:12 PM
Data conversion, Database programming, DBGrid, VB 6, Visual Basic, Visual Basic 6

Part of program on external monitor
How can I display my main program on the laptop monitor and results (for the public)on a external monitor in visual basic 2008?

Answer Question   |  January 5, 2009  11:45 AM
Dual monitors, external monitor, Multiple monitors, Visual Basic, Visual Basic 2008

Checkboxes with INSERT and DELETE actions
I’m fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:

Answer Question   |  December 31, 2008  3:13 PM
Access 2003, Access forms, Microsoft Access, Visual Basic

Visual basic60 code
How create a database with this problem like there is a faimly and its have a number like 1 (Anil Father) we have create a method to entere members of faimly i.e. 1.1 Member Name Age etc

Answer Question   |  December 31, 2008  9:32 AM
Visual Basic, Visual Basic 6.0

Spoolersp.exe Error occuring frequrently in Windows 2003 environment running a VB application.
We are running a VB Application in Windows 2003 environment. The database Server is SQL 2005. The Application runs in a separate server and the database in another. Remote Users connect to the application through the Remote Desktop facility. Users can go for direct print as well as save to PDF and print. Whenever more [...]

Answer Question   |  January 1, 2009  4:05 AM
disables printer services., PDF, priting or exporting to pdf, spoolsvc.exe Error, SQL Server 2005, Visual Basic, Windows Server 2003

Visual basic 6.0 varible completion with user defined types not working
If I have the following code… Type xyz V1 as byte V2 as byte End Type Dim myVar as xyz It used to be that when I typed: myVar. in the VB 6.0 editor, I would get a pop up menu with V1 and V2 as my choices. I’ve done something to disable that and [...]

Answer Question   |  December 26, 2008  9:16 PM
VB 6, Visual Basic

VB Data Report number format
I want number field in Data Report to be formatted like 12,90,565 or 89,675 How to do it Please Help me

Answer Question   |  December 22, 2008  6:14 AM
VB, VB Data Report, VB Data Report designer, VB Data Report formatting, Visual Basic

Visual Basic
What would be the code (using regular expression) to match the page , whos title changes during runtime, but we know that it will contain the string “Welcome” in the begining of the title?

Answer Question   |  December 19, 2008  5:05 PM
VB, VB Code, Visual Basic

Microsoft Visual Studio 2008 Express edition
Hello everybody, i recently downloaded the Microsoft Visual Studio 2008 Express Edition. It has Visual Basic 2008, Visual C# 2008, Visual C++ 2008 and Visual Web Developer 2008 (all Express editions). The problem is i dont know where to start. I have programming background. i have programmed in C++ and Visual Basic 6.0 (at university). [...]

Answer Question   |  February 24, 2010  1:23 PM
C#, SQL Server 2005, Visual Basic, Visual C# 2008, Visual C++ 2008, Visual Studio 2008, Visual Studio 2008 Express Edition, Visual Web Developer 2008

How do I find the file path to write my file to?
Here is my code and then my question. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim objfile As New System.IO.StreamWriter(“C:Documents and SettingsJOHNDOEMy DocumentsTHETARGETFOLDERMYFILE.TXT”) objfile.WriteLine(“just a test”) objfile.Close() end sub This code will write to my target folder, however if i build my project and make it available for other people [...]

Answer Question   |  December 15, 2008  11:51 PM
%HOMEPATH% variable, Relative references, System.IO.StreamWriter, Visual Basic, Visual Basic 2008

How do I open files through Visual Basic 6?
HOW I CAN OPEN A FILE (DOC, PPT, XLS, MDB ETC) BY CALLING FROM VISULA BASIC 6.0

Answer Question   |  November 13, 2009  9:58 AM
App.Path, OPEN statement, VB 6, Visual Basic, Visual Basic 6

Sample code for DataEnvironment VB 6
Provide code sample for using of DataEnviornment VB 6.0

Answer Question   |  December 11, 2008  9:57 AM
DataEnvironment, Source code, VB 6, Visual Basic, Visual Basic 6

How to output a text file and separate the data into different fields using VB 2005
i am new at this. This is an example of the data (in notepad) it looks like this.. 1,ABC,12/12/2008 2,DEF,13/12/2008 3,GHI,14/12/2008 4,JKL,15/12/2008 i would like to read only the first line and have each field dim as varchar. The output should be in this form: Field 1 = 1 Field 2 = ABC Field 3 [...]

Answer Question   |  December 14, 2008  9:33 AM
Comma-delimited, String manipulation, Text manipulation, VB, VB 2005, Visual Basic, Visual Basic 2005

VB6 and Crystal Reports – Error 20599 SQL not found
Sir, I have a VB 6 base software and when I click for showing Crystal base Report by package, I seem to be getting the message error 20599 SQL not found. Please help me.

Answer Question   |  May 9, 2013  9:00 AM
Crystal Reports, Error 20599, VB 6, Visual Basic, Visual Basic 6

Export from Visual Basic 6 to Microsoft Excel file
how to export visual basic6 to excel file

Answer Question   |  April 7, 2010  1:54 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, VB 6, Visual Basic, Visual Basic 6