Page 1 of 4 123 ... LastLast
Results 1 to 15 of 58
  1. #1
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  2. #2
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  3. #3
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  4. #4
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  5. #5
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  6. #6
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  7. #7
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  8. #8
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using Access 2003

    A form has a list box, "lstRetirementHomes" which includes the names of 20 Retirement Homes in which members of a church might live.

    I have established the ability for the church secretary to select an individual Retirement Home from the list and print a list of residents in that Home.

    However, the church secretary would like to be able to click one command button, and print a list for the minsters which shows each retirement home, the residents, etc.

    One of the problems is that some of the Retirement Homes might have no residents from the church living in them.

    What I need to be able to do is, when the command button "Preview All" is pressed have a routine that will cycle through and prepare the reports for those Retirement Homes in which people from the church reside.

    Any pushes in the right direction would be appreciated.

    Thanks.

    Tom

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  11. #11
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  12. #12
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  13. #13
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  14. #14
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  15. #15
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I'd have two buttons on the form
    One to report on an individual home.
    One to report on all homes.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Page 1 of 4 123 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •