Results 1 to 5 of 5
  1. #1
    hugoj is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2014
    Location
    Sweden
    Posts
    6

    Opening form asks for a table's description


    In an Access 2010 db one of the users (only one!) gets an error message "Set Parameter Value" and it asks for tblAMR.Description as the value to be set.
    There is no field with that name. Nor does the VBA-code includes a reference to any description.
    The form is based on a Query and the Query mainly gets it's data from the table tblAMR.

    I have developed the db in an English version and the users are using a Swedish version. In the table I have not entered any text in the Description.
    For the fields I have entered description for some of them. In one memo field I have entered the letter ":". Could this create a problem? The error message doesn't indicate that though.

    Have a nice day

    Hugo

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Check the form query to see if this field exists in the query. remove it.

    check the form to see if there is a field box that is mapped to Description , remove it.

    check the vb code to see if '
    Description ' this is used in it.

  3. #3
    LaughingBull is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    Jul 2015
    Location
    Toledo Ohio
    Posts
    143
    if the form was created with parameters and then changes made the parameters must be removed in all areas as stated by ranman256

  4. #4
    hugoj is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2014
    Location
    Sweden
    Posts
    6
    Thanks for the reply. But In the form Query there is no reference to this field. And in the form there is no object with this name either. And the VB code has no reference to the text Description. I have searhed in the whole Project and nowhere can Description be found as part of text or as a separate word.

  5. #5
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,180
    Have you checked the form's filter and order by properties?

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

Similar Threads

  1. Replies: 4
    Last Post: 04-25-2015, 11:53 AM
  2. Replies: 2
    Last Post: 12-07-2014, 10:03 PM
  3. Replies: 1
    Last Post: 11-18-2014, 02:16 PM
  4. Replies: 13
    Last Post: 07-01-2014, 06:16 AM
  5. Using ADO, entering the table property description
    By crowegreg in forum Programming
    Replies: 1
    Last Post: 08-14-2013, 05:42 PM

Tags for this Thread

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