Run Time Error...

[ChiTownDiva]

Happy Friday All...

I have some code that I'm getting a run time '3270' "Property Not Found" error on it. Does anyone have a clue as to why...


Function Import()


With Application.FileSearch
.NewSearch
.LookIn = "S:\SALESUP\Yasu\AprilVI"
.SearchSubFolders = True
.filename = "*.txt"
.MatchTextExactly = True


End With

With Application.FileSearch
If .Execute() > 0 Then

For I = 1 To .FoundFiles.Count
DoCmd.TransferText acImportDelim, "Carbonation Import Specification", Right(.FoundFiles(I), Len(.FoundFiles(I)) - InStrRev(.FoundFiles(I), "\")), .FoundFiles(I), True



Next I
End If
End With
End Function

When I copy and paste this code into another persons' database, they get the 3270 error though it works fine in all of my databases.

Thanks in advance.

ChiTownDiva

 

[bubba100]

Have you looked to see if the references between the databases are set the same?

 

[ChiTownDiva]

Thanks Bubba100 for responding....

I'm not sure what you mean by "references between the databases are set the same"...could you explain/

Thanks.


ChiTownDiva

 

[PHV]

Does "Carbonation Import Specification" exists in the other persons' database ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bubba100]

From the db window goto the Modules tab and select New. Then goto Tools>References. Look to see what is checked they should match between the two db's AND different computers. Next look at the location of what is checked.

If what is checked is the same but the location is different that could be your problem. Different versions of Access/Office put the ActiveX controld in different places, but alot of the time they will have the same name.

Its important to see what is checked And the location of that file.

I spent a lot of time trying to figure out why one day some of our computers starting have a problem that turned out to be with the Common Dialog 5.0 control. It turned out that another person used version 6.0 of the same control they put theirs in the same location as mine and registered it. It didn't replace the file but Access tried to use the newer version.