[AccessD] A2K ideas on Order Entry

The beauty of unbound forms, with custom classes handling your processes, is
the ability to create your own events.  I have built several projects where
the forms display data based upon Global Class Objects, which interact
through events.  For example, I have an Inventory object, that has an
'inventory changed' event.  Whenever something happens to the inventory
(which is done through this class), it raises that event, and all open forms
that have are using this class receive that event, and thus update
themselves with the new information.

Yes, it takes a little longer to set something like that up, but it is
extraordinarily handy as you build more complex and 'smarter' applications.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Francisco
Tapia
Sent: Saturday, September 04, 2004 1:53 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] A2K ideas on Order Entry


Brainstorming here:

I have a parent form which houses important order entry information
such as Billto/Shipto, PO#, SO#, and Notes... along with that I have a
listbox (but have been working on a readonly subform datasheet view).

Users currently go into a popup window box to add new lineitems to
this order.  However... I'd like to control where the popup box hovers
over... meaning allowing for the subform to be viewable while the
popup form is on the screen.  This allows ME to refresh the subform to
display the newly entered items.

now currently while in the popup mode, I've made it so that as soon as
one line entry is complete, the form display clears out to allow
another entry, and thus all the data entry guy has to do is key in the
new qty etc. for his order.  but once he is done, I use a keypreview
to capture the ESC key to allow them to get out.  I thought about what
if they could just hit ENTER and when the QTY field is null it should
kick him out, but I get a bizzar error on the .OnExit event of the Qty
Field.  thus I can't exit the form while it's processing or something
like that....

any ideas?.. (yeah I realize that its' 12:00am PST but that's when the
mind is wandering :D)

thanks,



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