Search results

  1. S

    Text alignment for queries

    🀯 "?" Works Thanks!
  2. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Thank you guys πŸ™‹β€β™€οΈπŸ§β€β™€οΈ
  3. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Awesome! Trim will remove space Thanks πŸ™‹β€β™€οΈ
  4. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Awesome! Do you have another method with NZ easy to write?
  5. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Hi, I have question realted to this threads My question is What about if I have a query has [SecID] and the criteria refer to 1 combo box [Forms]![MeetF]![CombSecNum] how can I let the query to show all the Recored if the [Forms]![MeetF]![CombSecNum] is Null or ""? I do the following way...
  6. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Thank you guys! πŸ™‹β€β™€οΈ πŸ™‹β€β™€οΈ
  7. S

    Solved Criteria Between two Dates Optional and not Mandatory

    WoW! both ways are works
  8. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Smart! My way to remove filter But I encountered a problem when I remove the filter I get an error message
  9. S

    Solved Criteria Between two Dates Optional and not Mandatory

    Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity). I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only. ------------------------------------------------ I want to make query creteria between two dates based on txtboxes in form, but the...
  10. S

    Solved Current Sunday Day and Current Thurday Day of This Week

    I put +1 And it works Thanks indeed for ur help 😊
  11. S

    Solved Current Sunday Day and Current Thurday Day of This Week

    Hi, I mean I want to know the period of dates for week 6 Start from Sunday end Thursday For example I want Access to write in my Report this Report is for week 6 Starting from Sunday 5th to Thursday 9th, It changes every week automatically πŸ™‡β€β™€οΈ πŸ™
  12. S

    Solved Current Sunday Day and Current Thurday Day of This Week

    Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity). I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only. ------------------------------------------------ Assuming today's date is February 8, it is fall in week 6 I want to know the period for...
  13. S

    Filtering/removing duplicates

    Welcome to AWF Try to use Query Wizared
  14. S

    Solved Count by one Query

    I like it Awesome! Thanks! πŸ™†β€β™€οΈπŸ™‹β€β™€οΈ
  15. S

    Solved Count by one Query

    Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity). I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only. ------------------------------------------------ I have EmployeeT PhoneT SectionT I want to Count How many employee in each Section...
  16. S

    SendKeys Macro Action to run Screen Snip & Sketch in Win10

    I found "RunApplication" Macro Action, can you help me to get the path for "Screen Snip & Sketch" I did not find it in "Program Files (x86)" :(:cautious:πŸ™
  17. S

    SendKeys Macro Action to run Screen Snip & Sketch in Win10

    I did it, but it doesn't take screenshot, how can I open application by macro, instead of SendKeys? πŸ™
  18. S

    SendKeys Macro Action to run Screen Snip & Sketch in Win10

    Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity). I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only. ------------------------------------------------ I want to run Screen Snip & Sketch in Win10 by using SendKey, but he is not responding...
  19. S

    Solved Conditional Formatting Highlight matching fields search result

    Yes Awesome!!! πŸ™†β€β™€οΈ πŸ™‹β€β™€οΈπŸ§β€β™€οΈ Thanks!
Top Bottom