Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Error in Lesson 28

    in Lesson 28 shown here: http://www.functionx.com/access/Lesson28.htm

    It asks one to open the Yugo National Bank1 database. Then to find all of the employees whose last name begins either with
    k, m or y. I put in it datasheet view and in the last name column at the top I typed:

    begins with Like "[k or m or y]"*


    It did not like it. It came back with a command "enter a valid value."



    I have no idea what it is talking about. I think that I did it correctly. I obviously did not.

    What is wrong?

    Thanks in advance.

    Respectfully,


    Lou Reed

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I don't see an error in that article. If you do what it says in the section entitled LIKE a Specific Character, it says you should write your criteria like this:
    Code:
    Like "[k,m,y]*"
    It works for me when I test it.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I copied exactly what you typed and pasted in at the top of the last name column.

    I still got an "Enter a Valid Value".

    I am not sure what is going on. Is there an update to Microsoft Access 2010 that can eliminate

    this error?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Not seeing any instructions for use of: begins with Like "[k or m or y]"*

    I do see instruction for use of: LIKE "[a, h, o, y]*"

    So going by that example, try: LIKE "[k, m, y]*"

    Be sure to put the * within the quote marks.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I copied and pasted the string LIKE "[k, m, y]*":
    from your post including the colon and got a

    Enter Valid Value

    message again.

    Maybe I should post my database?

    Thanks.

    Respectfully,


    Lou Reed

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The colon was a copy/paste typo which I already corrected. It does not belong in the criteria.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, I took the colon out and still got the same error- enter valid value. Now I am in the last name column and in the text filters I chose begins with.

    This time I chose to put it in equals (no reason really just to see if any option took it). The MS Access 2010 took it and gave the right answer.

    Go figure.

    Respectfully,

    Lou Reed

  8. #8
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Correction on my last post the answers it gave when I put it in equals are correct, just incomplete.

    So what am I doing wrong?


    Respectfully,


    Lou Reed

  9. #9
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I tried to upload the database in question "Yugo National Bank". It exceeded the 500 KB limit. The Yugo National Bank database file size
    was 876 KB. I am unsure as to what to do now.

    If you look on the internet this problem is discussed, but no definitive answer to fixing
    it is given. I do not know what to do now.


    Respectfully,


    Lou Reed

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The tutorial uses the LIKE example with Filter by Form method. If you chose 'Begins with' then you are not using Filter by Form - that is an option with right click shortcut search menu. Cannot use that criteria in the right click menu search.

    Different search methods have different capabilities - they are not all interchangeable.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, so what method do I use here?

    I followed the instructions given in the tutorial see link above.

    R,

    Lou Reed

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I challenge that you have followed the instructions.

    The example given used LIKE operator and wildcard with Filter By Form method. I suggest the tutorial expects use of the same method, just changing the letters in the parameter set. From your description you did not use that, you used right click shortcut.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    So I just put the relation shown below at the top of the last name column?

    LIKE "[k, m, y]*"

    Instead of in those Begins with options?


    R,


    Lou Reed

  14. #14
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The instructions are to use table.

    1. open table

    2. click Filter by Form

    3. type criteria

    4. click Toggle Filter
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  15. #15
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, in the context of this tutorial section where does the statement :

    LIKE "[k, m, y]*"

    go. It clearly was being used incorrectly by me. So how do I use it?


    R,


    Lou Reed

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Ambiguity in Lesson 25
    By Lou_Reed in forum Access
    Replies: 8
    Last Post: 08-19-2015, 06:42 AM
  2. I am lost on Lesson 21!
    By Lou_Reed in forum Access
    Replies: 3
    Last Post: 07-30-2015, 01:31 PM
  3. Replies: 3
    Last Post: 01-23-2014, 07:49 AM
  4. Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  5. Replies: 6
    Last Post: 05-30-2012, 12:32 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