Another free database application from Argeus: Stock Kid 2009. Download and see it for yourself if it can help you track your inventory and costs.
Argeus Solutions is now giving away a free database application: VAT Kid 2009. You can download and use it for free! It is useful for small companies to enter all sales and purchase transactions without any details and get VAT return form quickly and easily. Microsoft Office Access 2003 is required. Please contact me if … Read moreVAT Kid 2009
The problem: When we use formulas on textboxes in the report footers of MS Access reports, such as “=sum(a_field_in_header)”, we get incorrect results because of duplication of same amounts for multiple items in detail section. Here is an example to make it clear: We have two tables one for header and another detail records, for … Read moreMS Access Reports: Sums from distinct group headers
Reading records from the database and instead of using DLookup or querying the database all the time, to improve performance we can read them into a VBA collection object and refer to it in memory. Especially, if the data in particular tables are not changing at all or changing very rarely, we can use this facility and hold the data in memory while the application is running. Beware of the number of records in your table and the amount of memory it may consume.
Microsoft programmers are always very particular on their way of approaching problems. Since they are the “biggest” software developers in the world, they have to set the standards!? Problem: Updating field(s) of a table using a complex (sub) query. Solution: 1. In standard SQL, you can this:
SET A_FIELD = Q.CALCULATED_FIELD
FROM A_COMPLEX_QUERY Q
WHERE TABLE1.ID_FIELD = Q.ID_FIELD;
It makes sense, right? No, not according … Read moreUpdate Query on MS Access