Vba ошибка 2465

Answers

• Nick —

  OK…we know the issue is with that line of code.  The reason your ideas didn’t work is that at this point in the code, you are just trying to build the WHERE clause BEFORE you open the report.  So it makes sense that it was bombing on that code
  you mentioned.

  The next question I would ask is — is it bombing in the code where I build strWhere or when I am opening the report.  One way to troubleshoot this is to try

  strWhere = «PlanID = » & 6  (obviously 6 would have to be a valid planID…use something valid from your tables.

  If the code doesn’t work here, then you know the issue is in the report — when it tries to set the filter, it cannot. So you need to troubleshoot there.   You might try

  strWhere = «Reports!Contact!PlanID=» & me.PlanID or something like that.

  If the code does work here, then you know that the issue is that your form code cannot find Me.PlanID on the form.  In that case you need to check on the form and make sure there is still a text box or somethign called PlanID and that you can get to
  it (can you even do MsgBox me.[planID] and get a value?  What if you remove the brackets? I hate brackets and avoid at all cost).

  Last q if this doesn’t work — what kind of structure change did you make? Did it affect PlanID at all?

  Hope this is helpful. check back and let us know what you find!

  ---

  Joy Eakins CDD, Inc.

  • Proposed as answer by

    Tuesday, May 1, 2012 5:50 PM

  • Marked as answer by
    Nick Vittum
    Tuesday, May 1, 2012 6:55 PM

• Exactly which line generates the error?
  the line strWhere =
  «[PlanID] = « &
  Me.[PlanID] generates the error.

  Since the error is on that line, the problem has nothing to do with the report, or the query the report is based on. It has to do with the form.

  Maybe there is no field or control on the form named PlanID, or there is a control named PlanID but not bound to the PlanID field, yet there is a PlanID field in the form’s recordsource, or PlanID appears more than once in the select statement of the recordsource.

  • Marked as answer by
    Nick Vittum
    Tuesday, May 1, 2012 6:54 PM

I keep getting a run time error ‘2465’ when running a query via VBA in Access.

Error: Microsoft Access can’t find the field ‘|1’ referred to in your expression

I can’t seem to find where this issue is occuring. Below is the VBA code that I’m currently using to requery a form.

Dim Test As String
Test = "*" & Combo161.Value

Dim strSQL As String
Dim strWhere As String
strWhere = (Chr(34) + Test + (Chr(34)))

'MsgBox (strWhere)

strSQL = "SELECT * FROM Test_Query WHERE TestID " & strWhere

'MsgBox (strSQL)
[Form_Test (subform)].RecordSource = strSQL
[Form_Test (subform)].Requery

The TestID had a field formatting of text, rather than a number. Does this matter at all?

0

I had the same error. What I missing was the double quotes around a string. This error is a bit misleading. Check the syntax etc and you will find the issue was related to comma or double quotes etc.

Dim Test As String
Test = "*" & Combo161.Value

Dim strSQL As String
Dim strWhere As String
strWhere = (Chr(34) & Test & (Chr(34)))

'MsgBox (strWhere)

strSQL = "SELECT * FROM Test_Query WHERE TestID Like " & strWhere

'To test
'Debug.print strSQL

Me.[Form_Test (subform)].Form.RecordSource = strSQL
''Not needed when changing record source
''Me.[Form_Test (subform)].Form.Requery

TestID Like "*something"

8