09/02 Our Interior Design Project Management Template has been recently
released. This system provides complete management and reporting of
commercial interior design projects.
Specific features include:
Project Setup
Project floors & rooms definition and characterization
Furniture template management
Management of furniture pictures
Assignment of furniture to rooms
Definition of furnishing characteristics such as type, model, cost, finish &
fabric
Cloning of rooms
Comprehensive reports with cost analysis
Presentation reports Read more:
NewAccessTemplate" target="_blank">http://tinyurl.com/ya8ykxz][1])
[1]: http://tinyurl.com/ya8ykxz
- 10 hours 27 minutes ago
- •
- • Share
09/01 Access Histogram query example - you'll be surprised at how easy it is
to do the calculations for a seemingly complex statistical measure using a
single Access query. In this example we have customers who purchased items
from a store.
We want to know the distribution of customer purchases grouped by customer's
age. To start, we have a table called MCustomerPurchases (in reality this
would probably be a query based on a Customer table and a Purchases table).
Read more:
HistogramQuery" target="_blank">http://tinyurl.com/yb6qk7x][1])
[1]: http://tinyurl.com/yb6qk7x
- 1 day 10 hours ago
- •
- • Share
08/31 Here is a fairly simple way to calculate a running sum using a DAO
Recordset operation.
To begin, we have created a temporary table with Absence Dates, and Substitute
Teach ID (SubID) - this table was created via a previous query not shown in
this example.
Our goal is to determine running sum of substitute records based on absence
date (teacher was absent and therefore a sub worked in this day).
In the example we used rst!day_count rather than just counting records because
the sub can work either 1/2 days or full days (1). Here is the VBA code:
Read more:
VisualBasicRunningSums" target="_blank">http://tinyurl.com/ylarylx][1])
[1]: http://tinyurl.com/ylarylx
- 2 days 10 hours ago
- •
- • Share
08/30 To enhance a contact form that contains the individual's e-mail address
you can add a button to automatically launch outlook using that address.
Read more:
LaunchOutlookEmailfromAccessForm" target="_blank">http://tinyurl.com/yl6k9x3][1])
[1]: http://tinyurl.com/yl6k9x3
08/29 No up-front payments are required. You pay as the work is delivered and
accepted by you. Read more:
[http://blueclaw-db.com/][1]
[1]: http://blueclaw-db.com/
