Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2021
    Posts
    14

    Question Buttons to filter records and make a report

    Hello,
    I created 5 buttons: 1) "set true record (only record selected)"
    2) "set false record (only record selecter)"
    3) "set all records false (only record filtred by cbo)"
    4) "set all records true (only record filtred by cbo)
    5) "set all false record (all records, filtred and not filtred)



    Have any advice to make vba comands?
    Is it possible to select different reports with shift or ctrl key to change yes/not?

    file:
    https://1drv.ms/u/s!AjFLWnkU3pswhJM9...cT9Ag?e=wyyCAU

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,405
    Quote Originally Posted by Giulio Benvenuti View Post
    Hello,
    I created 5 buttons: 1) "set true record (only record selected)"
    2) "set false record (only record selecter)"
    3) "set all records false (only record filtred by cbo)"
    4) "set all records true (only record filtred by cbo)
    5) "set all false record (all records, filtred and not filtred)

    Have any advice to make vba comands?
    Is it possible to select different reports with shift or ctrl key to change yes/not?
    It's unclear what the desired results are.
    1) Print only the currently displayed record
    2) What does this mean?
    3) Print records filtered by cbo selection
    4) What does this mean?
    5) What does this mean?

  3. #3
    Join Date
    Mar 2021
    Posts
    14
    rptProvolone yes/not criteria "True"
    I want print only records where i selected "True". To select records to print i created 5 buttons:
    1) no print / just set yes/not.value = true only current selected record - i want add only selected record in frmProvolone to rptProvolone
    2) // = false only current selected records - i want clear only selected record in frmProvolone to rptProvolone
    3) // = false all records only displayed - i want clear only current displayed records in frmProvolone to rptProvolone
    4) // = true all records only displayed - i want add all current displayed records in frmProvolone to rptProvolone
    5) // = false all records (displayed and not filtred) i want clear all records in frmProvolone to rptProvolone = no records in rptProvolone

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,405
    Quote Originally Posted by Giulio Benvenuti View Post
    rptProvolone yes/not criteria "True"
    I want print only records where i selected "True". To select records to print i created 5 buttons:
    1) no print / just set yes/not.value = true only current selected record - i want add only selected record in frmProvolone to rptProvolone
    2) // = false only current selected records - i want clear only selected record in frmProvolone to rptProvolone
    3) // = false all records only displayed - i want clear only current displayed records in frmProvolone to rptProvolone
    4) // = true all records only displayed - i want add all current displayed records in frmProvolone to rptProvolone
    5) // = false all records (displayed and not filtred) i want clear all records in frmProvolone to rptProvolone = no records in rptProvolone
    Sorry, I still don't understand. Anyone else want to take this on??

  5. #5
    Join Date
    Mar 2021
    Posts
    14
    Quote Originally Posted by davegri View Post
    Sorry, I still don't understand. Anyone else want to take this on??
    EXAMPLE:

    1) "set true (record selected)"
    Private Sub Comando35_Click() Me.[yes/not] = "vero"
    End Sub

    2) "set false (unselect record)"
    Private Sub Comando36_Click()
    Me.[yes/not] = "falso"
    End Sub



    I would like have:

    3) "set all false (records filtred)" : me.[yes/not] = "falso" to all records i have filtred in frmProvolone4) "set all true (records filtred)" : me.[yes/not] = "vero" to all records i have filtred in frmProvolone5) "set all false (all records)" : me.[yes/not] = "false" to all records i have in tblProvolone

  6. #6
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,563
    Hi Giulio

    You have 10 records in tblProvolone

    When you click each of the Command Buttons shown:-

    1) "set true record (only record selected)"
    2) "set false record (only record selecter)"
    3) "set all records false (only record filtred by cbo)"
    4) "set all records true (only record filtred by cbo)
    5) "set all false record (all records, filtred and not filtred)

    What do you want to display for Each Command Button ?

    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 1
    Last Post: 09-15-2020, 10:17 AM
  2. Replies: 4
    Last Post: 01-11-2018, 09:16 PM
  3. Filter By Form and Apply Filter Buttons
    By JustLearning in forum Forms
    Replies: 13
    Last Post: 02-18-2015, 01:01 PM
  4. Replies: 1
    Last Post: 08-14-2012, 02:43 PM
  5. Make command buttons unique to a record
    By timmy in forum Forms
    Replies: 26
    Last Post: 03-09-2011, 09:51 AM

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