You may want to rethink your table structure, you appear to be allowing items to be cross-referenced with categories rather then belong to categories. This is only valid if you want an item to belong to more than one category, which hass a huge impact on your queries (an order of magnitude greater).
Normally, your table structure would be
Category
is parent to
Subcategory
...
Mistoffeles
Last Activity: Nov 10 '06, 06:00 PM
Joined: Oct 12 '06
Location:
-
You might try
UPDATE tableB inner join [SELECT tableA.ID, Count(aID as count(tableA.ID ) GROUP BY tableA.ID]
I am not sure you can mix aggregate and non-aggregate fields in a single query in Access, however....Leave a comment:
-
From a theoretical perspective, as I am not a VBA programmer, I would say that using the onChange event of control B you would insert code to change the value of the applicable properties of control A.Leave a comment:
-
Your code needs to go on the table, and be based one the event triggered when focus is changed to a particular record, or a different record. Your code should send the address field data for the selected record to the text box.
I couldn't tell you how to do this in specific code, or I'd be able to solve my own problem posted here 8^D, but that should give you an idea what you need to do.Leave a comment:
-
Dependency autoincrement
I need to make the key field on a subform autoincrement differently dependent on a seletion made in the main form.
On the main form, there is a drop-down with a limited set of values, for example:
Type-A
Type-B
Type-C
Type-D
When a selection is made, I would like to add a new record to the table attached to the subform, look up the highest value in a range dependent on the selection,...
No activity results to display
Leave a comment: