Tuesday, August 18, 2009

Create Folder Through Visual basic

Private Sub CreateFolders()
Dim rsData As New ADODB.Recordset
If fsys.FolderExists("" & App.Path & "\HTML") = False Then
fsys.CreateFolder("" & App.Path & "\HTML")
end if
MsgBox "Done"
End Sub

Tuesday, August 4, 2009

Check File :- It's is Exists or Not

Public Function CheckFile(FlNm As String) As Boolean
Dim fsys As New Scripting.FileSystemObject
If fsys.FileExists(App.Path + "\" + FlNm) = False Then
CheckFile = True
Else
CheckFile = False
End If
End Function
Pass the file name in function and it return you True & False

Saturday, August 1, 2009

Connect Access Databse Through ADODB

Public cnAccount As New adodb.Connection
Public Sub OpenCn()
Set cnAccount = New adodb.Connection
cnAccount.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\Data.mdb;Persist
Security Info=False"
End Sub
Write this function in module and Call MDI Form Load

Monday, July 27, 2009

Welcome Visual basic Solution

Visual Basic (VB) is an ideal programming language for developing sophisticated professional applications for Microsoft Windows. It makes use of Graphical User Interface for creating robust and powerful applications

Visual Basic (VB) was developed from the BASIC programming language. In the 1970s, Microsoft started developing ROM-based interpreted BASIC for the early microprocessor-based computers. In 1982, Microsoft QuickBasic revolutionized Basic and was legitimized as a serious development language for MS-DOS environment. Later on, Microsoft Corporation created the enhanced version of BASIC called Visual Basic for Windows
Important Features of Visual Basic (VB)
1. Full set of objects - you 'draw' the application
2. Lots of icons and pictures for your use
3. Response to mouse and keyboard actions
4. Clipboard and printer access
5. Full array of mathematical, string handling, and graphics functions
6. Can handle fixed and dynamic variable and control arrays
7. Sequential and random access file support
8. Useful debugger and error-handling facilities
9. Powerful database access tools
10. ActiveX support
11. Package & Deployment Wizard makes distributing your applications simple