Search results

I worked out to get value of selected record in subform. It's Me.Parent!control = Forms!parentform!subform.Form!control Thank you for your advice.

I have a main form and a subform. I want that a selection in a subform will put the selected record's fields values to the controls in the main form for editing. What can I do for this? Appreciate any suggestions.

Thank you for the suggestions. I managed to work out the pass of a SQL to a subform with the help of real examples from (Advanced Programming In Access 2013) Filtering Sub-Forms Using VBA https://www.youtube.com/watch?v=M1J1rHXR4JY&t=116s. Thank you again.

Hi, I built a lstTutor in a form and would like to list the selected tutor with its appointment history in sbfApptHistory (subform). I have no idea of creating fields for it with VBA codes and just created a blank subform. tblTutor = tutor's table for peronsal particulars tblTAppt = tutor's...

I dont want to rank them, i just need to list the field (Rank) value with Tutor's primary key(PK) and the date which is the nearest to Today.

The "Rank" is a code, it represents job titles (e.g. Assistant Professor, Associate Professor, Professor, etc.). The Rank code will be linked to "tblRank" to look up its job title. The query output needs to report the job titles based on the Rank code.

qryApptT_NearestToday SELECT tblTAppt.TRef, Max(tblTAppt.ApptEnd_Dt) AS Nearest_Dt FROM tblTAppt GROUP BY tblTAppt.TRef; qryTutor_Rank_NearestToday SELECT qryApptT_NearestToday.TRef, qryApptT_NearestToday.Nearest_Dt, tblTutor.LastName, tblTutor.FirstName, tblTRank.HDesc, tblTAppt.ApptEnd_Dt...

I have another question that i want to get the rest columns like 'Rank' below with the nearest today script provided. PK E_date, Rank 3 1/10/2013, 3 3 4/15/2017, 4 3 7/01/2018, 4 9 3/6/2015, 2 9 5/22/2018, 3 11 11/21/2017,5 How do I get RANK's values as well?

Perfect work!

Sorry for my careless mistake. "PK" is a foreign key in this table.

Yes, it's.

PK means primary key

No, The query is just for getting the past dates which nearest to today.

Hi, I intend to build a query to get the records with the dates nearest today. Below is the table with a few samples PK E_date 3 1/10/2018 3 4/15/2018 3 7/01/2018 9 3/6/2018 9 5/22/2018 11 11/21/2017 The query output should be 3 7/01/2018 9 5/22/2018 11 11/21/2017...

Use of Dlookup is what I did before. I wonder if I can make use of query parameters in VBA. I've skimmed querydef but don't know how to apply it. I would be appreciated if any hints are suggested.

I need to build a VBA script to pass value of TRef (e.g. 2) to the query parameter to get the count for that TRef. It's 2 in this case.

Hi, I've a table containing a number of records with duplicated keys like that shown below TRef TTID 1 11 1 24 1 6 2 9 2 14 3 8 I would like to count each TRef in that table and write them into another table as summaried...

I'll. I'm a novice, what relationship tools you would suggest to use for the work? Thanks in advance.

Thank you for your idea. It seems that I worked out the method. I redesigned the tables and relationships. Now, the query doesn't produce duplicate records. As a matter of efficient tables structure, are my tables design appropriate? I brief describe the tables and their relationships as...

I have reduced the database size and uploaded as attached for tests. The tables were signed to meet the business rules. I hope to reduce the redundant incurred. More suggestions on the tables design and query for the report are appreciated.