| | |
Drive List Box Help Please for Error 68
Thread Solved |
•
•
Join Date: Jul 2006
Posts: 19
Reputation:
Solved Threads: 0
Hi to whoever is ready my post and call for help. I am an absolute novice at VB6 and are trying hard to learn this program off my own back from the internet and an old tutorial book i got my hands on. So far ive managed to build a database program, but i am stuck with one bug that is getting on me nerves because i cannot find a fix for it.
The drive list box gives an error message when drive not found. Error 68.
Is there a simple fix to display a message box and have the drive list box return to default after exiting the message box.
It makes my program crash every time no drive is found.
Ive tried for over aweek to suss it any help is much appreciated.
Here is part of my code for my program, a snapshot of the form i need it for is here http://www.andoverhydroponics.co.uk/vb6databasehelp.htm
Thanks Bill
The drive list box gives an error message when drive not found. Error 68.
Is there a simple fix to display a message box and have the drive list box return to default after exiting the message box.
It makes my program crash every time no drive is found.
Ive tried for over aweek to suss it any help is much appreciated.
Here is part of my code for my program, a snapshot of the form i need it for is here http://www.andoverhydroponics.co.uk/vb6databasehelp.htm
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Option Explicit Private Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hWnd As Long, ByVal lpszOp As _ String, ByVal lpszFile As String, ByVal lpszParams As String, _ ByVal lpszDir As String, ByVal FsShowCmd As Long) As Long Private Declare Function GetDesktopWindow Lib "user32" () As Long Const SW_SHOWNORMAL = 1 Const SE_ERR_FNF = 2& Const SE_ERR_PNF = 3& Const SE_ERR_ACCESSDENIED = 5& Const SE_ERR_OOM = 8& Const SE_ERR_DLLNOTFOUND = 32& Const SE_ERR_SHARE = 26& Const SE_ERR_ASSOCINCOMPLETE = 27& Const SE_ERR_DDETIMEOUT = 28& Const SE_ERR_DDEFAIL = 29& Const SE_ERR_DDEBUSY = 30& Const SE_ERR_NOASSOC = 31& Const ERROR_BAD_FORMAT = 11& Function OpenDocument(ByVal DocName As String) As Long Dim Scr_hDC As Long 'Scr_hDC = GetDesktopWindow() OpenDocument = ShellExecute(Me.hWnd, "Open", DocName, _ "", "C:\", SW_SHOWNORMAL) End Function Private Sub cmdExit_Click() Unload Me End Sub Private Sub Dir1_Change() File1.Path = Dir1.Path End Sub Private Sub Drive1_Change() Dir1.Path = Drive1.Drive End Sub Private Sub File1_DblClick() Dim r As Long, msg As String Dim str As String If Right(Dir1.Path, 1) = "\" Then str = Dir1.Path & File1.FileName Else str = Dir1.Path & "\" & File1.FileName End If Me.Caption = str r = OpenDocument(str) 'If there is an error, the return value is 'less than or equal to 32 If r <= 32 Then Select Case r Case SE_ERR_FNF msg = "File not found" Case SE_ERR_PNF msg = "Path not found" Case SE_ERR_ACCESSDENIED msg = "Access denied" Case SE_ERR_OOM msg = "Out of memory" Case SE_ERR_DLLNOTFOUND msg = "DLL not found" Case SE_ERR_SHARE msg = "A sharing violation occurred" Case SE_ERR_ASSOCINCOMPLETE msg = "Incomplete or invalid file association" Case SE_ERR_DDETIMEOUT msg = "DDE Time out" Case SE_ERR_DDEFAIL msg = "DDE transaction failed" Case SE_ERR_DDEBUSY msg = "DDE busy" Case SE_ERR_NOASSOC msg = "No association for file extension" Case ERROR_BAD_FORMAT msg = "Invalid EXE file or error in EXE image" Case Else msg = "Unknown error" End Select MsgBox msg End If End Sub
Thanks Bill
Last edited by Comatose; Aug 19th, 2006 at 11:07 pm.
•
•
Join Date: Jul 2006
Posts: 19
Reputation:
Solved Threads: 0
Thanks to everyone who took the time to read my post and look at the problem. I did mamnage to solve it in the end by adding this simple code.
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Private Sub Drive1_Change() On Error GoTo HandleErrors Dir1.Path = Drive1.Drive frmAssociation.Refresh HandleErrors: frmAssociation.Refresh ExitLine: Exit Sub End Sub
Last edited by Comatose; Aug 19th, 2006 at 11:07 pm.
![]() |
Similar Threads
- Looking for List Box help, please! (VB.NET)
- getting data from a list box. (Visual Basic 4 / 5 / 6)
- problem in listing directories in list box (Java)
- list box --php issue (PHP)
- My list box (Java)
- "Error in linking List box with the VB6.0 database" (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: How do i create a database in vb
- Next Thread: Help Please
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows






