Results 1 to 7 of 7

Printing forms problem and help

  1. #1
    mrbob24 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2018
    Posts
    4

    Printing forms problem and help


    Hi, I just let my purchasing person go so i'm in a bit of a bind. We have a Access database that we use for making purchase requisitions. I use the print button on the bottom of the form page and it only prints a blank page. We have some macros for printing and they print like 20 pages of code.
    I have found a second database on the computer that is not used and it prints the the one page form. The print preview is filled in. I went to design view and looked at the two buttons (old database verses new) and could not see any difference.
    i need to know where to go to get this one to work. Is it in the VB code.
    Can i make a new button or new macro just to print the last file.
    i have a macro that ask for a PO or PR number i enter that but i don't get a print preview i get the 20 pages of junk.
    Thanks, Robert

  2. #2
    ridders52's Avatar
    ridders52 is offline Long time standing
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    1,883
    Whatever the reason for your situation, forms are for data entry/editing/viewing. They are not designed to be printed.
    Use a report instead to print output
    Colin (Mendip Data Systems), Website, email

    If this has helped, please click the star button and leave a comment

  3. #3
    mrbob24 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2018
    Posts
    4
    No that does not work either. The reports or the macros or the print buttons don't print the completed PR out.
    Thanks for your help

  4. #4
    mrbob24 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2018
    Posts
    4
    Ok i just found out that i can print any from with this button that was created last week but nothing created this week i can print.

  5. #5
    mrbob24 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2018
    Posts
    4
    Found the problem. Was not putting the users name in one of the fields. Put my name in was not registered in the DB. Basic stuff that i forgot from not using access for some time.
    Thanks for your help.
    PS it does print the form from the button at the bottom of the form.

  6. #6
    Beetle is online now Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    193
    Quote Originally Posted by mrbob24 View Post
    ...PS it does print the form from the button at the bottom of the form.
    Colin wasn't saying that you can't print a form, he was saying that you shouldn't. Although you can print a form, that is not their purpose. They usually look rather poor when printed, plus you don't have the sorting, grouping and formatting capabilities that you have with a report.
    Sean Bailey

    Dim Thirsty As String
    Thirsty = "Insert Into Glass (Select Beer From Fridge)"
    DoCmd.Execute Thirsty, dbPourAnotherOnError

  7. #7
    ridders52's Avatar
    ridders52 is offline Long time standing
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    1,883
    Thanks Sean
    You explained EXACTLY what I meant!
    Colin (Mendip Data Systems), Website, email

    If this has helped, please click the star button and leave a comment

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

Similar Threads

  1. Printing Forms
    By jimbo1283 in forum Forms
    Replies: 3
    Last Post: 07-21-2016, 05:34 AM
  2. printing out forms
    By Lou_Reed in forum Access
    Replies: 4
    Last Post: 04-18-2016, 07:30 AM
  3. Printing on pre-printed forms
    By GodBlessNY in forum Reports
    Replies: 8
    Last Post: 02-04-2016, 07:22 PM
  4. Forms Printing Quotations?
    By lbtaylor1984 in forum Forms
    Replies: 8
    Last Post: 10-31-2013, 08:06 AM
  5. Another Question on Printing Forms
    By MJeanBap in forum Forms
    Replies: 7
    Last Post: 01-05-2012, 06:52 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
  •  
Tech Forums: Microsoft Office Forums