Hello,
so I have built a table trace log with the attributes modification date, item name and item number. I have a table article which has the attributes article name,quantity and article number. To create a new article there is a form for the article table. I now wanted to track the quantity of items by date. For this I have this SQL
Code
And I put it in the properties sheet of the form under "events" under "before update". The result was that every time I change the quantity of the item, it makes me a new entry in the trace log table with the date. This is the way it should be. One thing is missing though, the current quantity. That's why I tried a little bit, and wanted to add my SQL code under "after update". But nothing happened, neither a result was displayed in the table nor an error code. What could be the reason for this?
so I have built a table trace log with the attributes modification date, item name and item number. I have a table article which has the attributes article name,quantity and article number. To create a new article there is a form for the article table. I now wanted to track the quantity of items by date. For this I have this SQL
Code
Code:
DoCmd.RunSQL "INSERT INTO date log SELECT * FROM article " & "WHERE articlenumber=" & articlenumber.
Last edited: