Recent content by weretiger

Here are some screenshot.. testDB_1 showing the subform that i used.... i will auto add the ServerDB so that when i add new record, it ties to the ServerDB testDB_2..... it does not do the auto-populate the ServerDB .... when i add new record, it will add to a "BLANK" serverDB

My initial design was a subform in a form, but user want to have a TOTAL count in the form, which i do not know how to have the calculation field in the form as the form is direct link to Table and not Query. I tried use display using the Control Source to replay the Total from the query within...

Private Sub cmdAddQtreeForm_Click() Dim sWHERE As String sWHERE = "[ServerDB] = '" & Me.ServerDB & "'" 'Open the form DoCmd.OpenForm "xfrm_Qtrees", acFormDS, , sWHERE End Sub I had it work and display only the data belong to the server.... However, when i add record, it does not...

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 |...

[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...

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...

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 |...

SELECT [Query_HostDetails].Mountpoints, Count([Query_HostDetails].HostName) AS Usedby_Num_Hosts FROM (SELECT DISTINCT Mountpoints, HostName FROM Query_HostDetails) AS [%$##@_Alias] GROUP BY [Query_HostDetails].Mountpoints; the above solved it.... Thank you for the kind help!! :)

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...

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!