Results 1 to 8 of 8
  1. #1
    tihmir is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    18

    Creat Search Form By Date, Access 2016

    Hello friends, In my search form I try to make search with two text boxes (short dates) to lookup between dates in the Qry witch is my split form. how to do that? Could you help me please?


    Click image for larger version. 

Name:	fm.jpg 
Views:	48 
Size:	197.9 KB 
ID:	33822

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    tihmir is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    18
    Quote Originally Posted by June7 View Post
    Thank you! I will try it now.
    I am doing something wrong. I can't make it.
    Help somebody please....
    Last edited by tihmir; 05-01-2018 at 05:53 AM.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    What have you done? What happens - error message, wrong results, nothing? Will have to at least provide code for analysis. If you want to provide db, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    tihmir is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    18
    Quote Originally Posted by June7 View Post
    What have you done? What happens - error message, wrong results, nothing? Will have to at least provide code for analysis. If you want to provide db, follow instructions at bottom of my post.
    You have Pm

  6. #6
    tihmir is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    18
    June7, Here is my db. Can you see it, please?
    Attached Files Attached Files

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Sorry, not able to run your code because of language so cannot debug.

    You should run Debug Compile.

    The Search procedure is missing End Sub line.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    tihmir is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    18
    Quote Originally Posted by June7 View Post
    Sorry, not able to run your code because of language so cannot debug.

    You should run Debug Compile.

    The Search procedure is missing End Sub line.
    Thank you about your answer!

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

Similar Threads

  1. How to creat a custom roundup function in Access
    By nagiese in forum Programming
    Replies: 2
    Last Post: 04-26-2018, 06:23 PM
  2. Replies: 6
    Last Post: 01-23-2018, 10:06 AM
  3. Automating Outlook 2016 from Access 2016
    By jcc285 in forum Programming
    Replies: 10
    Last Post: 09-30-2017, 01:53 PM
  4. Replies: 1
    Last Post: 07-31-2016, 03:13 AM
  5. need help to creat a Query for Futre date?
    By YaseenIskaf in forum Queries
    Replies: 7
    Last Post: 08-21-2012, 10:57 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