Results 1 to 4 of 4
  1. #1
    urosm993 is offline Novice
    Windows 10 Access 2013
    Join Date
    Nov 2015
    Posts
    11

    Queries, tables, forms problem

    Hello everyone,
    Here is my problem, I have one table with dates and customers. I wrote query to see the last date for every customer. (max grouped by customers).


    I have to represent that with a form customer - maxDate.
    1. When I use only query I cannot connect the textArea with the query field (got the #name? error)
    2. When I make table from query the table doesn't update as the other values change. I have to close everything and make table again.
    Please help me how to make this work.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why are you making a table?

    Not sure what you mean by 'connect the textArea with the query field'. Maybe you should use Max() or DMax() in textbox on form.
    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.

  3. #3
    urosm993 is offline Novice
    Windows 10 Access 2013
    Join Date
    Nov 2015
    Posts
    11
    The idea is to make the textArea change value when field in query changes.
    I was thinking about making a table from query because there's no option to add query field in "Add existing fields".
    And without making the table, I tried to add query field to Control Source of the textArea, but I got #name? in area.


    Click image for larger version. 

Name:	Date.PNG 
Views:	6 
Size:	15.6 KB 
ID:	22759

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Cannot reference tables and queries directly that way. That's what domain aggregate functions are for.
    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.

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

Similar Threads

  1. Replies: 6
    Last Post: 10-16-2014, 12:55 PM
  2. Replies: 9
    Last Post: 08-27-2014, 11:34 AM
  3. From queries and tables to forms?
    By Fidycent in forum Forms
    Replies: 4
    Last Post: 12-16-2011, 01:54 PM
  4. Replies: 10
    Last Post: 07-12-2011, 11:09 PM
  5. Replies: 4
    Last Post: 04-01-2009, 08:49 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