Results 1 to 4 of 4
  1. #1
    jimbo1283 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    6

    Printing Forms

    Hi,



    please bear with me for daft questions. I'm trying to muddle my way through this.

    I'm trying to create a form that we will use to request samples. There will be 5-6 users of the form. It will work through Sharepoint.

    The idea being that we fill in a form, called Sample request, we then submit this form, it saves a record of the form but then emails the form with all the submitted data in it to a set person to action.

    I've got the form laid out, and I'm struggling from there. I can't get the form to open a report with only he data that has just been submitted. It doesn't seem to pull through the ID?

    I've attached the database if it helps give an idea of where I've gone wrong.

    any help greatly appreciated.

    Many thanksSample Request Forms.zip

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    sorry I don't look at attachments.

    In general when one is involved with sending emails - you are going to send a report rather than a form. The embedded send email features can be looked up. It really depends on automation versus semi - manual. If you make a report you can export it to PDF or you can email it just by right clicking on the report when it is on screen. Or one can automate those same type features if one uses VBA code.

  3. #3
    jimbo1283 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    6
    THanks for the reply.


    I've created a report with the same layout as the form, however I'm struggling to get the report to open with the data of the form I've just saved. It opens a report which contains details of all the records.

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    If RecID is a Number

    Code:
    Private Sub PrintButtonName_Click()
    
      If Me.Dirty Then Me.Dirty = False
    
      DoCmd.OpenReport "ReportName", acPreview, , "[RecID]=" & me.RecID
    
    End Sub


    If RecID is Text/String

    Code:
    Private Sub PrintButtonName_Click()
    
      If Me.Dirty Then Me.Dirty = False
    
      DoCmd.OpenReport "ReportName", acPreview, , "[RecID]='" & me.RecID & "'"
    
    End Sub

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. printing out forms
    By Lou_Reed in forum Access
    Replies: 4
    Last Post: 04-18-2016, 08:30 AM
  2. Printing on pre-printed forms
    By GodBlessNY in forum Reports
    Replies: 8
    Last Post: 02-04-2016, 08:22 PM
  3. Forms Printing Quotations?
    By lbtaylor1984 in forum Forms
    Replies: 8
    Last Post: 10-31-2013, 09:06 AM
  4. Another Question on Printing Forms
    By MJeanBap in forum Forms
    Replies: 7
    Last Post: 01-05-2012, 07:52 AM
  5. Printing a single Report from two forms
    By cvolkers in forum Programming
    Replies: 4
    Last Post: 03-06-2011, 11:27 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