Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23
  1. #16
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Posts
    1,251
    Quote Originally Posted by xps35 View Post
    I cannot tell how it "exactly" works if you do not provide sufficient information. What is the name and the structure of the table behind the report. What is the code behind command2?
    Are you addressing me or the OP?


    My code is relatively simple as shown above.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  2. #17
    xps35's Avatar
    xps35 is online now Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    97
    Quote Originally Posted by moke123 View Post
    Are you addressing me or the OP?
    Did I quote you?
    Groeten,

    Peter

  3. #18
    Akchayan is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    60
    Quote Originally Posted by xps35 View Post
    I cannot tell how it "exactly" works if you do not provide sufficient information. What is the name and the structure of the table behind the report. What is the code behind command2?

    mslst.accdb
    Here is everything.

  4. #19
    Akchayan is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    60
    mslst.accdb
    This is it.

  5. #20
    Akchayan is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    60
    Is there no way where the user can just choose from here:
    Click image for larger version. 

Name:	Screenshot 2022-10-05 133033.png 
Views:	9 
Size:	21.4 KB 
ID:	48858
    So the User can just choose in the column "JaOderNein" and in the report the Value of "Position 20" of all those selected are displayed.

  6. #21
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Posts
    1,251
    Not a good way to do it, IMO and prior experience, but if you insist, it's just a matter of "Select * from tbl20 where JaOderNein = -1" or in your open report method use "JaOderNein = -1" in your where argument.
    Don't forget to run an update query afterwards to clear all the selections.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  7. #22
    Akchayan is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    60
    Thank you very much it worked!
    But what exactly is the update query or how do i vreate one?

  8. #23
    xps35's Avatar
    xps35 is online now Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    97
    Quote Originally Posted by Akchayan View Post
    Here is everything.
    Here is mine.
    Attached Files Attached Files
    Groeten,

    Peter

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

Similar Threads

  1. How to output data from multiple choice
    By oppoiste0731 in forum Access
    Replies: 3
    Last Post: 12-20-2017, 06:36 PM
  2. Replies: 7
    Last Post: 09-14-2017, 02:24 AM
  3. Replies: 0
    Last Post: 03-19-2017, 01:29 PM
  4. create a table for a multiple choice question
    By Winter1 in forum Database Design
    Replies: 4
    Last Post: 03-31-2015, 10:18 AM
  5. Replies: 7
    Last Post: 10-16-2012, 06:43 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