• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

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

0
printmedia
Asked:
printmedia
  • 2
1 Solution
 
peter57rCommented:
I guess the error is saying it doesn't know what me.txtfilename is.
0
 
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?

mx
0
 
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
0
 
printmediaAuthor Commented:
Actually, peter57r I mispelled the field name in the code.

That was it, it should be me.textfilename

Thanks!
0
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now