Surjer
10-03-2001, 02:04 PM
I am trying to transfer a text file into a table using a Form...
When I hit the command button I get an error "Invalid or unqualified reference"
Here is my code:
Public ASF_path As String
Private Sub Command0_Click()
With CM1
.DialogTitle = "Choose Your As-Stake file to Import"
.CancelError = False
.Filter = "Ascii File (*.asc)|*.asc"
.ShowOpen
If Len(.FileName) = 0 Then
Exit Sub
End If
ASF_path = .FileName
End With
.DoCmd.TransferText , "textIMP", "As_Stake", ASF_path
End Sub
When I hit the command button I get an error "Invalid or unqualified reference"
Here is my code:
Public ASF_path As String
Private Sub Command0_Click()
With CM1
.DialogTitle = "Choose Your As-Stake file to Import"
.CancelError = False
.Filter = "Ascii File (*.asc)|*.asc"
.ShowOpen
If Len(.FileName) = 0 Then
Exit Sub
End If
ASF_path = .FileName
End With
.DoCmd.TransferText , "textIMP", "As_Stake", ASF_path
End Sub