Run-time error 3270: Property not found in Access 2003 form

Hi all I get this error in my Access 2003 form. When I click the debug button it highlights the code listed below

The table does exist and my Excel version is 2003.
Any ideas?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tmpTableA", Me.txtFileName, True, "A:A"

Open in new window

Who is Participating?
peter57rConnect With a Mentor Commented:
I guess the error is saying it doesn't know what me.txtfilename is.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Is this code being executed from within a Form?  If you do Debug>>Compile ... are there any errors?

printmediaAuthor Commented:
peter57r: me.txtfilename stores the path and file when the end user selects the file

DatabaseMX: I do not get any errors when compiling
printmediaAuthor Commented:
Actually, peter57r I mispelled the field name in the code.

That was it, it should be me.textfilename

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.