Search results

  1. D

    Solved How to sort values (the highest first)? If duplicates values found, the sorting is based on the saved table for those values

    How do I sort the values in descending order? Also, if two or more values are duplicates, the order depends on another table. The table below is not saved in the database. The VBA code calculates and brings values for the member_credits column for each member ID. member_id member_credits 1...
  2. D

    How do I combine multiple 1D arrays and create a table (rows, columns) like a 2D array using a loop?

    How do I combine multiple 1D arrays and create a table (rows, columns) like a 2D array using a loop? Public Function GetCombineArray() As Variant Dim ColA() As Variant, Row1() As Variant, Row2() As Variant, Row3() As Variant Dim NewTable() As Variant, RowInputs() As Variant Dim iC As Integer...
  3. D

    Solved Attendance report based on ideal timeframe table for clcok-in information. SQL queries.

    Three tables for the clock-in application at the hotel. emp_clock has employees clock in and clock out information. dept_mast is the master department with the primary key. It has departments like Breakfast, Housekeeping, Laundry, etc. dept_shift_times has all departments and their ideal...
  4. D

    Exclude Subform Records From Combobox Already Selected Access Datasheet, Access 2016

    I have database for housekeeping for hotel. Main table: tbl_hkeeping_Mast date houkeeping_no (primary key) housekeeper_No child table: Tbl_hkeeping_Detail housekeeping_no (ref. key) room_no (combo box on datasheet subform) room_status service in a subform, I have room_no as combobox, which...
Top Bottom