[AccessD] Looking for easy form solution

[James Button]

I don't remember you posting anything indicating that you have an ID and
timestamp on each entry, but that makes it a lot easier to 'extract' a set of
changes in order to review and change them, and also to go through as an audit
trail -
Who did what to the database (and by implication the animals) in what order, and
when.
Also facilitates things like checking waiting periods before other actions can
be performed -

Re confirmation actions - 
Well, I just spent an hour entering that, and now I have to check each and every
part of the entry - 
Oh! yes of course I did it all correctly!

Followed the day after by Ah! - Only 12 doses gone from the cupboard and I seem
to remember making a 14 entry set!

JimB   

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of FW
Salato Center
Sent: Wednesday, October 28, 2015 4:33 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Looking for easy form solution

This route is working well. I'm wondering though, if I should go to the trouble
of displaying the records "to be" committed beforehand and giving the user a
last chance to remove an animal? If the user makes a mistake, it's no big deal
to pull up the medical records and delete an individual record, but they'd have
to remember to do so. I'm inclined not to do this and add it later if they ask
for it.

It seems like a lot of work to me. 

Susan H. 

A list box is something I started considering yesterday afternoon. I'm glad you
mentioned it -- it kind of confirms for me the direction I think I'll go on
Tuesday. Thank you!

Susan H.

>
> > I've done similar on many occassions:
> >
> > 4.  User clicks "Go" button.
> > Step through selected items in listbox and record the treatment 
> > details about each one in turn.

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