Results 1 to 4 of 4
  1. #1
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481

    Auto Data Record Searching!

    Dears

    May some one help me:

    I had a form (frmcertificates) to print certificates including major fields:
    CertNo. PK (AutoNumber)
    Product:
    ProductionDate:
    Etc

    There is some tests data related to the product and production dates available in the database. Therefore while preparing certificate, i want to run a query to fetch the inspection results of the selected product according to the production date. (Range:+ 5 days from selected date).

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You can use a query criteria that uses Between and DateAdd() to subtract/add 5 days to the date on the form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Sir

    Can you provide any examples which could fit to my required situation.

    Regards

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    DateAdd("d", -5, Forms!FormName.TextboxName)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 9
    Last Post: 03-01-2017, 10:00 AM
  2. Replies: 6
    Last Post: 07-31-2016, 11:49 AM
  3. Searching a record through the subform
    By Ruegen in forum Forms
    Replies: 5
    Last Post: 10-28-2013, 09:46 PM
  4. Replies: 3
    Last Post: 07-26-2012, 03:55 PM
  5. Searching a field on a record [HELP]
    By eduardo in forum Queries
    Replies: 1
    Last Post: 06-26-2012, 07:41 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