[AccessD] Looking for easy form solution

Rocky Smolin rockysmolin at bchacc.com
Sat Oct 24 09:53:06 CDT 2015


How's this? 

Add a "deselect" flag to the animal record - default False.  

On the form where all the animals are displayed a toggle Show
Deselected/Don't Show Deselected.  Then Don't Show is selected, add a filter
to the form to filter out the deselected animals. 

Any possibilities there?

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of FW
Salato Center
Sent: Saturday, October 24, 2015 7:48 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Looking for easy form solution

Here's the setup - I apologize if I'm giving more information than you guys
really need.

I have a table of individual animals. I have a lookup table of species. Each
animal is identified by a species. I also have tables for medical records
and vaccines, which relate to the individual animals.
Updating medical records and vaccinations for individual animals is easy and
already in place. I spent a full week going through paper records and
inputting records for the last several years.

However, we do have several multi-animal exhibits where the most efficient
input solution for the vet and animal care staff is to pull up a  herd or
flock option that initially selects all of that species and lets them make
the medical or vaccine update for all. Rarely will they need to update an
individual - but that will happen in the case of specific illness or injury.
So, in the case of flocks and herds, we need a multiple-selection action
type form. That form needs to be flexible enough that we can deselect
individual animals because on rare occasionally, one or two of the herd or
flock will not be part of the procedure.

I need a form that displays all the animals of the same species - not
difficult. I can do that.
I want a select/deselect control that lets the user remove an animal from
the group. Not sure about that one.
After deselecting any individual as necessary, the user can then input the
necessary medical or vaccine information - probably via a subform - and
click OK to commit. I already have the forms that we're using to update
these records for individuals. I'm wondering if I could use it as a subform
in the multi-select main form? I'm not sure if this is something that the
main/sub form arrangement can handle or if I'll need to create a Recordset
object to update the  underlying tables.

I'm seriously overthinking it because every time I start in with a solution,
I change my mind. I could use a little strategic discussion on the best way
to accomplish this. I prefer the easiest route and I can't help but think
this should be simpler than I'm making it.

Thanks in advance.

Susan H.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



More information about the AccessD mailing list