Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Unhappy Sigh, having used Access in 5 years and stuck..

    I am using Access 97 and I am trying to print a report using a macro. The macro pulls from a query that checks to see what report to print by looking at a combo box when a button is pressed. The combo box pulls it's list from the same table that the report is trying to print. How do I solve this because the list that the user selects from must contain up to the most entered data in the table.



    I haven't used access in a while...I used to do this in my sleep now I can't do it with 8 cups of coffee.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So what problem are you having? Are you using queries instead of directly to the table? Do you save the record before printing?

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    I was having the problem I was linking to the table for the data instead of a query. I found a option to turn of the report for checking that and it worked. However, does the setting for Record Lock put the data at risk?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I think the answer to your question is no. Reports do not alter tables.

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

Similar Threads

  1. Newbie Here & Stuck
    By FOZILD in forum Access
    Replies: 5
    Last Post: 09-24-2009, 08:26 AM
  2. Newb stuck on Normalization
    By dave_wilford in forum Database Design
    Replies: 6
    Last Post: 05-19-2008, 02:39 PM
  3. query date that is five years older than today
    By cpsummer in forum Queries
    Replies: 2
    Last Post: 09-26-2007, 02:31 PM
  4. Replies: 1
    Last Post: 03-15-2007, 03:38 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