Consulting

Results 1 to 3 of 3

Thread: Possible VB syntax error after comverting Access 97 to v2003.

  1. #1

    Possible VB syntax error after comverting Access 97 to v2003.

    I converted a database file from Access 97 to v2003 and it seems to be working except it flags one statement. With a breakpoint on the statement:

    Public Function FindWithSQL()
    execution does not stop at the breakpoint but flags the statement:

    Forms!frm1FindOpt!ListFiltered = myRS.[LN]
    That statement works correctly in Access 97.

    Q1: Why doesn't it work in 2003 and how should I correct?

    Q2: If the problem involves VB syntax, is the a link to a list of similar changes?

  2. #2
    More information:
    I retyped the line and now when try to run, an error message says "Method or member not found."
    The ".[LN]" is highlighted

    Correction: "Method or data member not found."
    Last edited by stanhilliard; 02-16-2021 at 12:05 AM.

  3. #3
    Never mind. I fixed the problem myself by changing ".[LN]" to "![LN]" .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •