Recent content by tihmir

  1. T

    Solved Query to return objects without inspections in the year

    It's done! Solved! Thank you very much guys - arnelgp, June7, CJ_London, Gasman. Private Sub cboYear_AfterUpdate() Dim SQL As String Dim Cancel As Integer If cboYear > Year(Now()) Then MsgBox "Attention...............", vbInformation, "Attention!" cboYear...
  2. T

    Solved Query to return objects without inspections in the year

    It send me Run-time Error 3075 in Query expression (missing operator) in query 'year([inspection_date]) = '.
  3. T

    Solved Query to return objects without inspections in the year

    The query works perfect, but I want to use that queryin my form (SplitForm) with 2 text boxes (txtDateFrom and txtDateTo) to filter the period for which the objects are without checks. How to do it in vba? I usually use this code Dim strWhere As String Dim lngLen As Long Const...
  4. T

    Solved Query to return objects without inspections in the year

    I reference a txtDate (Short Date) as you advised me, but in send me error "Syntax error in query expression YEAR (inspection_date)= Forms!FormName.txtDate
  5. T

    Solved Query to return objects without inspections in the year

    Thanks! Works perfectly. I just added "FROM" into the nested SELECT. And now how can I replace that hardcord value for example '2021' with function to use that query in filter form?
  6. T

    Solved Query to return objects without inspections in the year

    Hi, I have 2 tables - tblObjects and tblInspections tblObjects has object_id (primary key) and object_name. tblInspections has inspection_id(INT primary key), inspection_name, inspection_date(Date/Time) and object_id (INT foreign key) I need to build query to show me all objects that DO NOT have...
  7. T

    Solved Move records (last, first, etc.) on subform with buttons on main form

    Тhanks for the help oleronesoftwares! The picture shows Split form! This is also an option but I want to achieve it through subform! I appreciate your help!
  8. T

    Solved Move records (last, first, etc.) on subform with buttons on main form

    I think what you showed in the picture is exactly Link Master Fields and Chaild Fieldsis (main form/ subform). But as I said in this way you can only see this record which is in main form, NOT not all records in the table.
  9. T

    Solved Move records (last, first, etc.) on subform with buttons on main form

    Exactly! This is the effect I want to achieve, BUT through subform. Is it possible to do this with subform?
  10. T

    Solved Move records (last, first, etc.) on subform with buttons on main form

    Hi, I have main form (Single Form - View) with unbound subform (Datasheet View). Тhese two forms are created with the same table. On the main form I have control buttons - "first", "last", "next", etc.. So, I need on the subform be show all entries and when I move previews or next record on the...
  11. T

    Disable only "paste" in excel

    Hello, how to disable only "paste" in excel?
  12. T

    Solved UNION query in VBA

    I'm sorry I missed a few quotes :)
  13. T

    Solved UNION query in VBA

    HI all, I need to create UNION query in VBA like this: SELECT [Inspector] FROM qryInspectors UNION SELECT Top 1 "- Department DZK -" FROM qryInspectors; Do I have to declare a variable like Dim sSQL As String sSQL = SELECT ....... Then I need to match with combobox like this...
  14. T

    Solved Change Row Source combobox depend of function "GetAccessLevel"

    @isladogs, Your code works perfectly! It's my a silly mistake! I just have forgotten to add users with AccessLevel 2!
  15. T

    Solved Change Row Source combobox depend of function "GetAccessLevel"

    I fixed things! Now everything works perfectly!
Top Bottom