Search results

  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!
  16. T

    Solved Change Row Source combobox depend of function "GetAccessLevel"

    Thank you very much for the help and advice you gave me, Ranman256, isladog! With the code of Ranman256 it works. But by the method of isladogs the code does not work. I think the function does not want to start. I don't know why? My combobox remains blank. I will try to find out what is the...
  17. T

    Solved Change Row Source combobox depend of function "GetAccessLevel"

    Hi all. I need some help please. I am trying to change Row Source of ombobox depend of function "GetAccessLevel" I have Public Function GetAccessLevel() GetAccessLevel = Nz(DLookup("AccessLevel", "tblUsers", "UserName='" & GetUserName & "'"), 0) End Function and I have...
  18. T

    Solved Column summation calculations

    These are data for performed inspections per person in different objects. Тhe purpose of column 6 (Joint Inspection) is to show in what kind of object the inspection was joint with other people Еach day there may be a different number of inspections, ie. different number of rows in the table...
  19. T

    Solved Column summation calculations

    I need help to calculate a few columns, but I don't know how to do it. So: I have a workbook with 8 sheets - day1, day2, day3, day4, day5, day6, day7 and totalDay. In each sheet I have same table with 6 columns - column1, column2, column3, column4, column5, column6 Cell in each column is List...
  20. T

    Solved How to refer Exit button onClick event

    Many, many, many thanks again, @arnelgp. This is really a very simple and smart solution! I had not thought of such a decision - first to change the focus to the Tab and then to open Pop up form! Аbsolutely smart decision! Sometimes really have to think "out of the box". To look for the right...
Top Bottom