I would welcome suggestions on the subject of economy, and efficiency, of field-use and VBA coding.
I have a gardening db which is recording all relevant data about plants in my garden.
It has gone well over the years and, with some help from other members of the forum, is improving year on year, but I want to change the way flowering times are recorded and extracted from the table.
I'm thinking along the lines of one field holding a 'binary-like' code with each month being one digit of the 12 digit text code, (one for each month).
The user could enter the data by selecting one or more yes/no boxes indicating in which month(s) a plant flowers.
VBA would create the 12 digit text string and save it to one field.
When a record is subsequently opened, VBA would check each digit of the code and highlight the relevant yes/no boxes on the form.
Does anyone have other methods that might be better?
I'd be interested and grateful for any input.
I have a gardening db which is recording all relevant data about plants in my garden.
It has gone well over the years and, with some help from other members of the forum, is improving year on year, but I want to change the way flowering times are recorded and extracted from the table.
I'm thinking along the lines of one field holding a 'binary-like' code with each month being one digit of the 12 digit text code, (one for each month).
The user could enter the data by selecting one or more yes/no boxes indicating in which month(s) a plant flowers.
VBA would create the 12 digit text string and save it to one field.
When a record is subsequently opened, VBA would check each digit of the code and highlight the relevant yes/no boxes on the form.
Does anyone have other methods that might be better?
I'd be interested and grateful for any input.