Recent content by Gazzyy

  1. G

    Method or data member not found

    Decided to go bound form route instead. Thanks all for the help!
  2. G

    Method or data member not found

    Getting syntax error in query expression with the new code.
  3. G

    Method or data member not found

    I have had an issue in the past where it would throw a compile error, but it would end up being a completely different reference from what it was highlighting. I have triple checked all of my references to my form and table however I cannot find anything wrong. Could be just overlooking...
  4. G

    Method or data member not found

    Is it good now?
  5. G

    Method or data member not found

    Keep getting "compile error: Method or data member not found" on this insert into statement. It is highlighting the "Me.txtSM3". The textbox exists and the reference is spelled correctly so I'm not sure where to go from here. sqlStr = "INSERT INTO SavedRecords(Inspector, OrderNum, PCNumber...
  6. G

    Need help with INSERT INTO

    Added brackets to those field names and it seemed to solve the syntax error issue. Now I'm getting "Too few parameters. Expected 2." Any thoughts on that? Thanks for the help so far.
  7. G

    Need help with INSERT INTO

    Not sure how to debug.print. As far as I know, the correct syntax for the FIRST value is VALUES(" & Me.txtID & ",'" & etc.
  8. G

    Need help with INSERT INTO

    I keep getting a syntax error when trying to run this code. I have looked over it a hundred times and cant find the problem. Somebody please help! (Sorry if the code is a little jumbled, had to copy and paste code from phone). CurrentDb.Execute "INSERT INTO ReuseTestResults(FieldName...
See more
Top Bottom