Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. S

    Solved Conditional Formatting Highlight matching fields search result

    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 Conditional Formatting to Highlight matching fields search result, I typed this...
  6. S

    Solved Show the value without opening the DropDown List

    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 Show the value without opening the DropDown List, I put the syntax on Default...
  7. S

    Solved Dcount on 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 and PhoneT I make Query to show me How many phones does the employee...
  8. S

    OnClose Event Macro Action error

    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. ---------------------------------------------------------------------------- If the user want to close the frmPhone Form if he click Yes...
  9. S

    Solved TempVar

    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 TempVar to Read text, from textbox but I got errors, I mark them by red color With...
  10. S

    Solved Search in Sub Form by SetFilter Macro Action

    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 advanced Search by using SetFilter Macro Action I have [UserName] as text...
  11. S

    Solved Forms: Conditional formatting for multiple fields

    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 select multiple fields, I want to say in the Conditional formatting expression If any of...
  12. S

    Solved Create Blinking Control backcolor

    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 [Code1] txtbox control to be blinked (Flashing) if the value is more than...
  13. S

    Solved ComboBox Dropdown List Problem

    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. ------------------------------------------------ User 1 Join to Level 1 and Level 2 and Level 1 has frm1 and frm2 Level 2 has frm3 and...
  14. S

    Solved Best ERD Design Approach

    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 tblOrganization, tblManagement and tblDepartment for each of them has Positions...
  15. S

    Solved Expression builder Form Object Frame

    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. ------------------------------------------------ How can I tell that this is a Report or a Form through the expression builder?, Because...
  16. S

    Solved Update Query to Select only filtered records

    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 am trying to make checkbox to run Update Query to Select only filtered records and...
  17. S

    SQL is very important

    Hi, During the journey of trying to learn Microsoft Access, it became clear to me that the query language is very important, as I am facing so much difficulty in it o_O:cautious:. Would you suggest to me sites on the Internet that explain MS SQL to start a language learning journey, spicialy iif...
  18. S

    IIf Function in query criteria

    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. ------------------------------------------------ IIf ( expr , truepart , falsepart ) I want to say if the condition is False do nothing...
  19. S

    Solved Determine SetTempVar On / Off

    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. ------------------------------------------------ FilterOn property to specify or determine whether the Filter property for a form or...
  20. S

    Solved SetTempVar Macro Action not working

    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. ------------------------------------------------ At home I have Office 365 apps school version. SetTempVar Macro Action not working with...
Top Bottom