Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 31
  1. #16
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272

    Code:
     hello code

  2. #17
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    I think I have gotten it now
    Thanks so much for this assistance.
    This thing has been a headache since I started posting on this page

  3. #18
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    So about my issue
    Has anyone been able to find a fix for me?

  4. #19
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by Emmanuel View Post
    So about my issue
    Has anyone been able to find a fix for me?
    Have you taken the steps I have offered?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #20
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Now crossposted at https://www.access-programmers.co.uk.../#post-1824055 without any acknowledgement to responses here.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #21
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Quote Originally Posted by Welshgasman View Post
    Now crossposted at https://www.access-programmers.co.uk.../#post-1824055 without any acknowledgement to responses here.
    Honestly, I don’t understand this debug print process so that’s making it difficult to find a solution.

    And since the help isn’t coming as expected, had to cross post because I need urgent help with this.

  7. #22
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Quote Originally Posted by Welshgasman View Post
    Have you taken the steps I have offered?
    Also, am I finding difficulty using the code you suggested since am not unable to apply it to mine

  8. #23
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    All I am suggesting is debug the code.
    See the link in my signature. A video is worth a thousand words.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  9. #24
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by Emmanuel View Post
    And since the help isn’t coming as expected, had to cross post because I need urgent help with this.
    You do realise that the members here help out in their free time?, they have other things to do in their life, and also have to sleep sometime?

    You cannot expect to post on a forum and get an immediate answer all the time. Sometimes you will get lucky, but most times members have to extract information from the O/P to be able to focus on the problme. like pulling hen's teeth.
    Not saying that you do not know how to debug or walk through the code does not help? You joined here over 2 years ago. I would have expected you to have to use debug and F8 by now.? It is invaluablefor find out what you actually have NOT what you think you have. it is also brilliant for finding what I call silly errors, that elude people, myself included, that is why I promote it all the time.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  10. #25
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Quote Originally Posted by Welshgasman View Post
    All I am suggesting is debug the code.
    See the link in my signature. A video is worth a thousand words.
    Noted
    I will check through the video

  11. #26
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Changed a few things in tables and form to make it workable. Feel free to change your form properties back to what they were.
    You should have Option Explicit in the declarations of all your modules.
    Dont use special characters in field and object names.
    No need for the IIf's since your validation does not allow nulls.

    you should probably have tables for payment form and payment mode and store the PKeys.


    Code:
        strCriteria = "[dteDATE] between #" & Me.OrderDateFrom & "# And # " & Me.OrderDateTo & "# And [PAYMENT_FORM] LIKE """ & Me.cboIncomeType1 & _
        """ And[PAYMENT_MODE] LIKE """ & Me.cboIncomeType & """"
                      
    Debug.Print strCriteria
    
    
        
    Me.Filter = strCriteria
    Me.FilterOn = True
    Attached Files Attached Files
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  12. #27
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Managed to get a code that worked

    Code:
    Else    strCriteria = "[DATE] >= " & Format(Me.OrderDateFrom, "\#mm\/dd\/yyyy\#") & _
                      " And [DATE] <= " & Format(Me.OrderDateTo, "\#mm\/dd\/yyyy\#") & _
                      " And [PAYMENT_FORM] = '" & Me.cboIncomeType1 & "'" & _                   " And [PAYMENT_MODE] = '" & Me.cboIncomeType & "'"

  13. #28
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Sorry, I do not see anything that has changed with that code?

    Quote Originally Posted by Emmanuel View Post
    Managed to get a code that worked

    Code:
    Else    strCriteria = "[DATE] >= " & Format(Me.OrderDateFrom, "\#mm\/dd\/yyyy\#") & _
                      " And [DATE] <= " & Format(Me.OrderDateTo, "\#mm\/dd\/yyyy\#") & _
                      " And [PAYMENT_FORM] = '" & Me.cboIncomeType1 & "'" & _                   " And [PAYMENT_MODE] = '" & Me.cboIncomeType & "'"
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  14. #29
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Quote Originally Posted by Welshgasman View Post
    Sorry, I do not see anything that has changed with that code?
    Especially with the reserved word still in it.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  15. #30
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Quote Originally Posted by Welshgasman View Post
    Sorry, I do not see anything that has changed with that code?
    There was a slight change
    The “like” condition was taken off
    Same with the “Task” line of the code

Page 2 of 3 FirstFirst 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Me.Move not taking effect
    By GraeagleBill in forum Programming
    Replies: 4
    Last Post: 09-18-2021, 12:24 PM
  2. OrderBy specified in OnOpen event not taking effect
    By GraeagleBill in forum Reports
    Replies: 4
    Last Post: 03-21-2016, 11:53 AM
  3. Mouse-Over Button Effect Issue
    By McArthurGDM in forum Forms
    Replies: 4
    Last Post: 08-07-2014, 03:10 PM
  4. Shape Effect on Toggle Buttons
    By dimoc in forum Access
    Replies: 5
    Last Post: 04-10-2014, 09:28 AM
  5. Calculations Per Row Effect
    By gatsby in forum Access
    Replies: 29
    Last Post: 05-26-2013, 07:33 PM

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