Results 1 to 2 of 2
  1. #1
    helal is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2016
    Location
    Dhaka, Bangladesh
    Posts
    1

    Unhappy How to print only selected records in a page by Access "Report"?

    I've made a database for my employee containing Name,Department, Designation,Date of Join, Blood Group etc.

    1. I want to print ID card following that database and print only those "ID Cards which I need", or "from ID no LTC-050 to LTC-080" or "LTC-015, LTC-068 & LTC-048" like this. I've already designed the Report format but can't print following way.



    2. I want to make a "Upload button" or "Insert" for insert image how can I make this?

    3. When I am inserting image manually the image uploading in database sheet I want to upload only image at different path but connect with database.

    Click image for larger version. 

Name:	sample.jpg 
Views:	9 
Size:	84.7 KB 
ID:	25969

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in your 'report' form,
    put 2 boxes to print the range of records, txtStart and txtEnd
    (use ID, or Dates, etc)
    then the button would

    Code:
    sub btnRangeRpt_click()
    if isnull(txtStart) then
      sWhere = ""
    else
      sWhere = " [id] between " & txtStart & " and " & txtEnd
    endif
    
    docmd.OpenReport "reportName",acViewPreview,,sWhere

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

Similar Threads

  1. "page Header" not showing on Sub/Report
    By cottonland in forum Reports
    Replies: 1
    Last Post: 06-24-2016, 11:09 AM
  2. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  3. Replies: 10
    Last Post: 09-03-2015, 01:31 PM
  4. Replies: 3
    Last Post: 08-09-2014, 04:30 AM
  5. Replies: 3
    Last Post: 04-22-2013, 06:08 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