Results 1 to 2 of 2
  1. #1
    newbie is offline Advanced Beginner
    Windows XP Access 97
    Join Date
    May 2009
    Posts
    34

    Best Way to Create Interactive Report Access 2007


    I currently create several different checklists utilizing Access 2007 Reports. These checklists are printed every two weeks to help us make sure all the actions needed for a particular submission take place. The checklists typically have a listing of our clients/contracts and then checkboxes for the different actions we need to perform. I use reports because I need to be able to group data in a particular way and cannot do this via forms. I would like to be able to stop printing these checklists and move to creating an online interactive version that all three members of our team can access. This would be particulary helpful when all three of us are working on the submission together to meet deadlines. Is there a way that this can be done using the checklist report I already have created in Access? I know there are other options for creating forms but the problem I have run into with those is my listing of clients/contracts can change every week so I cannot just create a static one time report in something like InfoPath without having to re-desing it every two weeks. Any suggestions?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Not sure you can do it with a report because a report is a report and not an interactive form. You can however provide all the same information on a form and design a form to look just like your report.

    If you do venture online - you will need to use macro's for your events.

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

Similar Threads

  1. Create line chart in ms access 2007
    By bubu77 in forum Access
    Replies: 1
    Last Post: 02-16-2013, 10:07 AM
  2. Ms Access 2007 report export to excel 2007
    By Stan2man in forum Access
    Replies: 6
    Last Post: 11-23-2011, 01:24 PM
  3. How do I create a list? Access 2007
    By shabbaranks in forum Access
    Replies: 1
    Last Post: 10-14-2011, 06:01 AM
  4. Create a query in VBA, Access 2007
    By laavista in forum Access
    Replies: 3
    Last Post: 06-22-2010, 07:43 PM
  5. Replies: 7
    Last Post: 12-30-2009, 11:03 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