R
R
Rudolf Ignatiev2018-12-05 14:11:46
Visual Basic
Rudolf Ignatiev, 2018-12-05 14:11:46

Why does MS Access reload after selecting a date in a field?

The essence of the code is that after updating the date in the "Execution Date" field of the "Custom IP Order Card" form, only those journalists who are free from writing IP * will be shown in the next combo box of this form. The period when a journalist is busy writing IP lies between the "StartDate" and "EndDate" fields of the "Approved Topics" table. And if "ExecutionDate" > "EndDate", then the names of the journalists in the combo box "JournalistID" (on the form it is "JournalistName") appear on the form. It is worth noting that I throw the codes and names of journalists that satisfy the condition into the clipboard (the table that is cleared and re-created when the due date is selected), which is the source of the rows of the combo box.
But the file is restarted due to the termination of its work. There are only assumptions that there are problems either in the Access program itself, or in my file (it is possible that because of the code).
*IP - information product
*IA - information agent

Student Coursework
5c07b05060438817485623.gif5c07b19abc4f0642734321.gif5c07b1b2a4c83040861858.gif5c07b1baa21eb145634419.gif

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question