Connecting Tech Pros Worldwide Help | Site Map

Compile error: Method or Data Member Not Found

  #1  
Old November 12th, 2005, 07:40 PM
Kenny G
Guest
 
Posts: n/a
Hello,

Got a small problem:

I built a small table and used the following on my laptop this
morning.
This code compiled and worked fine on my laptop but when I compiled
the first Sub on my desktop I get compile error: Method or Data
Member Not Found
The words ProjectCode was highlighted.

Next I replaced the period with a bang just before the words
ProjectCode and it compiled just fine. When I depress the F8 key to
copy the previous record I get Runtime error 2465 Microsoft Access
can't find the field ProjectCode.

I sure would appreciate your help.

Kenny G

1...
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF8 And Me.NewRecord Then
CopyFromLast
Me.ProjectCode.SetFocus
End If
End Sub

2...
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF8 And Me.NewRecord Then
CopyFromLast
Me!ProjectCode.SetFocus
End If
End Sub
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
compile error:Method or data member not found jayjayplane answers 1 October 1st, 2008 06:46 PM
INSERT INTO - method or data member not found almeister9 answers 1 May 30th, 2008 11:38 AM
Compile Error - Method or Data Member Not Found DThreadgill answers 3 October 18th, 2007 10:04 PM
Help! Compile Error: Method or data member not found bradleyp@inspection.gc.ca answers 2 November 13th, 2005 10:17 AM