Results 1 to 3 of 3
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Changing a Record title

    http://www.functionx.com/access/Lesson23.htm



    In the tutorial at the position shown above when I get to the point after building
    a macro



    1. Click the Print Invoice
    2. If you have a printer (or your computer is connected to a printer), on the Ribbon, click Print. On the Print dialog box, click Print.
      If you don't have access to a printer, click Cancel
    3. Click the Close button to close the form

    Now when I click on Print as stated in step 2. a dialogue box pops up asking for a value AutoreapirID. This is clearly a typo.

    I want to correct the error, but I cannot find the misspelled word. How do I find it?

    Thanks in advance.

    Respectfully,


    Lou Reed

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    It may not be a mispelled field, but rather, it exists in the report somewhere and the report cant use it, so...

    check if the field is on the report somewhere, delete it.
    check if it exists in any group sorts
    check if there is any VB code using it.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I found it. It was in the statement:


    ="[AutoRepairID]=" & [AutoRepairID]

    the second AutoRepairID was misspelled in the above evaluation.
    I changed it and that took care of it.

    Thanks.


    Respectfully,


    Lou_Reed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Changing a title on a form
    By Lou_Reed in forum Access
    Replies: 6
    Last Post: 04-17-2015, 12:31 PM
  2. Changing a record all at once
    By GeorgeJ in forum Programming
    Replies: 1
    Last Post: 03-23-2015, 12:22 PM
  3. Replies: 2
    Last Post: 03-20-2015, 06:30 AM
  4. Replies: 15
    Last Post: 04-06-2014, 10:29 AM
  5. Replies: 1
    Last Post: 02-20-2013, 01:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums