Search results

  1. W

    Add button to create record into table based on ID

    Hi, I need to create a button into a form, whereby, when the sub-datasheet form popup, it will display all the records belong to Masterdata and i can add/edit/delete from the datasheet. for e.g. ParentID | ParentName Vic1 | Victor Nic1 | Nicole ParentID | Children Vic1 | Cherisse Nic1 |...
  2. W

    need total storage space for unique server

    [SOLVED] need total storage space for unique server Hi, Having 2 tables tbl_Server Server | ServerID Server1 | S1 Server2 | S2 tbl_Database Database | ServerID | StorageSize_GB DB1 | S1 | 40 DB2 | S2 | 20 Oracle1 | S2 | 20 Oracle2 | S2 | 40 SQL1 | S1 | 40 SQL2 | S1 | 50 How can i have...
  3. W

    add record into a different table, but it must tie to current's table's data

    Hi, I have a form, which main key is the "Family". and in the form already has the data for e.g. Father name, mother name, son name, DOB, etc.... Name | Relationship | Age | Johnny | Father | 45 Jassica | Mother | 40 Victor | Son | 25 Carmen | Daughter| 25 In the form, i can SEARCH and EDIT...
  4. W

    query using LIKE

    I have 2 tables, and each table having different information and i want to link those 2 and grab information from both tables. from below tables, i want to map the Qtree and then grab the rest of the information. for e.g. qtree1 suppose the same as qtree1/a Table 1 Qtree | Mountpoints |...
  5. W

    Calculate number of mountpoints

    Hi, I want to count number of mountpoints appear in the table. As below sample table, - Different mountpoints will appear, based on number of server using it. As you can see, the mountpoints will have repeating name based on number of server using it. - The Count_Mountpoints will calculate...
  6. W

    Yeo yeo everyone!

    Hi all, started my access journey months back after the team want to convert the Excel files, which the team has been using for years. Due to slowness and constant crashing if the file having lots LOTSLOTS of data.... good to know there is a place to learn from awesome ppl here!
Back
Top Bottom