Hi all,
I’m brand new to Access, so have been teaching myself as I go along. Actually enjoying this a lot!
Currently, I have a Database containing:
1 table (‘Contacts’)
2 forms (‘New Entry’ and ‘Start Here’)
2 Macros (‘FollowupFilter’ and ‘ShowAll’)
I’m struggling to figure out how to do a few things:
The ‘Start Here’ form has ten attributes, with new records added through the ‘New Entry’ form. One of the attributes is ‘Country’ and I’d like to have an option so I can filter all records in the ‘Start Here’ form by a particular country (similar to how you can do this in Excel through filtering and selecting the checkboxes). I want to make this user-friendly, so ideally without having to use the filter system built into Access. I thought about doing this through a Macro (which I’ve done with the above macros for other fields), but the ‘Country’ field has 20+ options so having a range of buttons wouldn’t really be a good system. If there’s an option to filter by multiple values that would be great too.
On the New Entry form, one of the fields is ‘Product’, and there is currently a combo box list of 10 products. I want users to be able to select multiple products. I’ve found out about ‘Multivalued fields’, but it doesn’t appear that these can be used in a Form. Is this the case? What other solutions are there?
Finally, when a new record is added (through the New Entry form, appearing in the Start Here form), it goes to the bottom of the list. How can I change the default sort options so that the most recent record created appears first? I want this to be the default so that users don’t have to change it when opening the file.
Hopefully I’ve explained that well enough! Any guidance/advice/suggestions would be really appreciated.
Andrew
I’m brand new to Access, so have been teaching myself as I go along. Actually enjoying this a lot!
Currently, I have a Database containing:
1 table (‘Contacts’)
2 forms (‘New Entry’ and ‘Start Here’)
2 Macros (‘FollowupFilter’ and ‘ShowAll’)
I’m struggling to figure out how to do a few things:
The ‘Start Here’ form has ten attributes, with new records added through the ‘New Entry’ form. One of the attributes is ‘Country’ and I’d like to have an option so I can filter all records in the ‘Start Here’ form by a particular country (similar to how you can do this in Excel through filtering and selecting the checkboxes). I want to make this user-friendly, so ideally without having to use the filter system built into Access. I thought about doing this through a Macro (which I’ve done with the above macros for other fields), but the ‘Country’ field has 20+ options so having a range of buttons wouldn’t really be a good system. If there’s an option to filter by multiple values that would be great too.
On the New Entry form, one of the fields is ‘Product’, and there is currently a combo box list of 10 products. I want users to be able to select multiple products. I’ve found out about ‘Multivalued fields’, but it doesn’t appear that these can be used in a Form. Is this the case? What other solutions are there?
Finally, when a new record is added (through the New Entry form, appearing in the Start Here form), it goes to the bottom of the list. How can I change the default sort options so that the most recent record created appears first? I want this to be the default so that users don’t have to change it when opening the file.
Hopefully I’ve explained that well enough! Any guidance/advice/suggestions would be really appreciated.
Andrew