Results 1 to 3 of 3
  1. #1
    maladoi is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    1

    Print a report without saving it

    Hi everyone, I'm new to access, and I have to deal with a problem. I have a form that loads some data in various inputs from a database. Now, I'm changing something and want to print the form BUT I do not want to save those changes... I have a code for not to save the changing when closing form but not when i hit print... does someone knows how to help me?



    Thank you.

  2. #2
    Mclaren is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    As I understand, the data will have to be saved prior to printing the report. on the close event of the report, insert code to delete you record from the underlying table.

  3. #3
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,085
    Actually that won't work. If he deletes the record he would delete the data that had existed previously. My presumption here is that he doesn't want to change the existing data. The best way to accomplish this is to make those textboxes unbound. Then in the On current Event of the form set each textbox = to the field.

    txtbox1 = field1
    txtbox2 = field2

    then you can change each textbox as you want print the form and the data in the table should not change.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-11-2011, 04:25 AM
  2. Replies: 0
    Last Post: 02-22-2011, 05:04 AM
  3. Print Report from Form ID
    By Brian62 in forum Forms
    Replies: 1
    Last Post: 09-18-2009, 01:50 PM
  4. Saving Print Settings
    By spinny in forum Queries
    Replies: 1
    Last Post: 06-23-2009, 12:58 PM
  5. Replies: 3
    Last Post: 03-24-2006, 08:40 AM

Tags for this Thread

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