[AccessD] Load fromtext

Martin Reid mwp.reid at qub.ac.uk
Mon Oct 16 15:38:32 CDT 2006


anyone see anyhting wrong with this. Keeps erroring out at the Case Form. 
 
Here is a form name Form_Customer Orders Subform.txt
 
Public Sub loadup()
On Error GoTo Err_loadup
Dim strTemp As String
strTemp = Dir("C:\Forms\*.txt")
Do Until strTemp = ""
        Select Case UCase(Left(strTemp, 4))
                Case "FORM"
                Application.LoadFromText acForm, Mid(strTemp, InStr(1, strTemp, "_", vbTextCompare) + 1), "C:\forms\" & strTemp
                Case "REPO"
                Application.LoadFromText acReport, "test", "C:\Forms\" & strTemp
        End Select
        strTemp = Dir
Loop
Exit_loadup:
Exit Sub
Err_loadup:
        MsgBox Err.Description, Err.Number
        Resume Exit_loadup
    Resume 0    '.FOR TROUBLESHOOTING
End Sub
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 


More information about the AccessD mailing list