I have a Project form with a subform that store items for each project. For various reasons the query for the subform is made from two tables with a one to one relationship linked on ItemNumber.
I want to be able to copy and append all the current project's subform data into the same tables. I have all the code for appending the project but I need code/query to say copy and append all of the current data in (subform) table 1 and table 2 maintaining a link between the two tables. The link fields are Table 1 ItemNumber (Incremental Number) and ItemNumber (Long Integer) in table 2.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…