Results 1 to 5 of 5
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    Access Runtime and multitextbox search forms - "enter parameter value"

    Hi,

    I have Access 2010 full on my computer and users have Access runtime on theirs.

    I have multisearch textboxes form.
    So On main form i have unbound textboxes controls for example with Unique_ID (Txb_Pesel control) and I have subform which is filtered based on user's input (using criteria like
    Click image for larger version. 

Name:	screen.png 
Views:	8 
Size:	5.7 KB 
ID:	31735


    On my computer everything is working fine.



    On users' computers there is a warning: "enter parameter value" (for Txb_Pesel and others).

    First of all i added trusted location into registry on user computer:

    Code:
    [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location1]"Path"="C:\\Users\\ljar01\\Desktop\\"
    "AllowSubfolders"=dword:00000001
    "Description"="My Files"
    "Date"="29/06/2017 17:50"
    Warning about trusting locations dissappeared and it is no more annoying.
    Still i have problem with "Enter parameter value".

    I read here that i can change in registry Path value,
    https://answers.microsoft.com/en-us/...4-de10eb2db045

    pplications in the Office 2010 cannot recognize environment variables that are stored as String Value (REG_SZ) value types. For applications to recognize environment variables, you must change the value type of the Path entry so that it is an Expandable String Value (REG_EXPAND_SZ) value type.
    Unofrtunately this is not working also...

    Please help,
    it is very urgent matter for me,

    Best wishes,
    Jacek

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Your criteria from your picture makes no sense. You are effectively saying
    WHERE Pesel Like "*" & YourtxtPesel & "*" OR Pesel Like "" & YourtxtPesel & ""

    Which equates to the same thing, if your criteria matches exactly then the * is not required, if it only partially matches the second criteria become redundant . Remove one of them.

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    thank you Minty very much!

    You have right! (As always;-)

    But problem was different... Access runtime 2010 was in english.
    I had to reinstall it for Polish language and problems with queries dissappeared!!!

    Wow this is very strange. I do not understand it....

    Thank you for helping,
    Jacek

  4. #4
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Glad you sorted it - install language issue would not be something I would have thought of.

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    I was digging all day trying to finding it and i had good luck

    Jacek

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

Similar Threads

  1. Replies: 5
    Last Post: 06-24-2015, 11:46 AM
  2. Replies: 2
    Last Post: 05-20-2015, 08:26 AM
  3. Replies: 8
    Last Post: 07-15-2014, 05:56 PM
  4. "Enter Parameter Value" for in Access 2010
    By rooflesh in forum Access
    Replies: 5
    Last Post: 01-28-2012, 12:49 PM
  5. Replies: 7
    Last Post: 01-23-2011, 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