Recent content by MvdBergh
-
M
Append Query - Student Placements
JHB, you are super!!!!! Thanks a million. My problem is solved. -
M
Append Query - Student Placements
I am working on a simple concept database that has as aim to place enrolled students to the next year’s intake. (See attached db) There are three tables: 1. tblStudent StudID (Autonumber) StudName (Short Text) 2. tblIntake IntakeID (AutoNumber) Intake (Short TexT 3. tblPlacements ID... -
M
Refering to a MVF from within a query
jdraw. Thank you. I have realised the issues the more and more I have searched for an answer and found that is not advised. I'll address future development with subtables as you have suggested. Thank you for the link provided. I'll investigate accordingly.- MvdBergh
- Post #4
- Forum: Modules & VBA
-
M
Refering to a MVF from within a query
I’m working in the higher education environment. I have created a database (MS Access 2016) with access control for multiple users all over different faculties. The table I use is “AfterStartup” of which I’m using a multivalued field (MVF) “School” from where access to different schools are...- MvdBergh
- Thread
- Replies: 4
- Forum: Modules & VBA
-
M
Copy last records from subform as new entries in subform
I have developed a small db (MS Acess 2007) handling Patient Filing and Invoicing. As with db’s, it is never complete as users' needs always change for more functionality, felxibility and ease of use. The invoicing is setup as follow: I have two tables: 1 - Main Table: Invoice (InvoiceID =...