Search results

Suppose I have two tables and a query: tblCompanies tblClients These are related via a query: qrySortContacts I have a form to add orders. In this form both a customer and a client need to be chosen. I would like to restrict the options for Clients on the basis of the choice for...

I have developed a form from which I would like to export the data to Excel. Of course, this could simply be done by clicking External data > Export > Excel, but then the whole table will be exported. What I would like is that only the data of the current record, so the record I have selected...

Hi, I've created two related tables, that have a one-on-one relationship: Now I would like that when I create a new record in tblProductions, that automatically a new record with the same ID will be created in tblPlanning. Till now, this does not happen, and I guess it is because mostly...

Hi, I've designed a form to add companies to a list of companies. Now I would like to have a button on the form "Add contact", so that a new contact person for the added company can be added. The button opens the frmAddContact, in which the person's details can be inserted. However I would...

Hello all, I'm relatively new to MS Access and currently I'm working on a database project. I have no experience in working with VBA, but I have little experience in programming in Python since I'm studying Biomedical Engineering at Eindhoven University of Technology. I was hoping to find...