Results 1 to 5 of 5
  1. #1
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94

    Displaying records in Forms command field value

    I want WPQueryF to find out records based on wpQuery or tables .


    A
    1. Tenent Name i want to enter first three character of the tenent name field
    2. From Date
    3. To date


    Result: pull record based on above condition.


    B. Only level / unit no (any three character match alphanumeric) then display the the record
    C If remarks field is not null.then display the record.
    rgds,
    aligahk06
    Attached Files Attached Files

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    With the multiple criteria required you would be best using Query By Form to display the required data.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by aligahk06 View Post
    I want WPQueryF to find out records based on wpQuery or tables .
    A
    1. Tenent Name i want to enter first three character of the tenent name field
    2. From Date
    3. To date


    Result: pull record based on above condition.


    B. Only level / unit no (any three character match alphanumeric) then display the the record
    C If remarks field is not null.then display the record.
    rgds,
    aligahk06
    I think the attached db fulfills the requirements of A. If not post back.
    I don't understand the requirements of B and C but perhaps you can use what I've done to fulfill the requirements of A to find a solution for B and C
    Attached Files Attached Files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94
    Sir,
    Thank u for ur precious time.
    it fulfill the requirements and i will change acordingly.but i want a clear button on the same form that clear the input fields for next query.

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by aligahk06 View Post
    Sir,
    Thank u for ur precious time.
    it fulfill the requirements and i will change acordingly.but i want a clear button on the same form that clear the input fields for next query.
    Create a button. In its On Click event use:
    Code:
    Me.TenentName = Null
    Me.DateFrom = Null
    Add a line of code for each of the controls
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 2
    Last Post: 08-07-2017, 02:58 PM
  2. Issue with Displaying sub-forms.
    By lynthel in forum Forms
    Replies: 6
    Last Post: 04-28-2014, 09:00 AM
  3. Replies: 5
    Last Post: 01-16-2013, 03:48 PM
  4. Replies: 1
    Last Post: 05-10-2011, 12:06 PM
  5. Replies: 5
    Last Post: 08-06-2009, 11:47 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