Continuous form

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have set up an order processing system and once the order has been
processed and a final button clicked I need to send it to a form which will
refresh itself every 5 seconds or so. The form can be a continuous form.

Where would I start with the form to get the orders pending up on the screen
of a seperate form.

My plan is to have the screen in a seperate area of the office and then have
the delivery drivers confirm the order on screen saving on wasting paper.

Just a starting point is good.

Thanks a lot,

Rob
 
I assume:
- the order is entered in one office ('A');
- the "form that will refresh itself every 5 seconds" is in another office
('B');
- both forms access the same "back end" database containing the actual
tables, and
- when a user enters a new order through the form in office 'A', it should
appear (within 5 seconds) on the form in office 'B' ?

If so, here is one approach.

- Create an "interlock" table for the purpose of communicating between the
two forms.
- When the order form adds a new order, have it add a record to the
interlock table (or set a field in an existing record).
- Have the second form use its Timer event to check, every 5 seconds, for
that record (or field) in the interlock table.
- If *not found*, the second form knows that the first form has not entered
any new records.
- If *found*, the second form knows that the first form *has* entered some
new records.
- The second form would then delete the interlock record (or set the field
back to false), then do a Me.Requery to requery itself, thus displaying the
new order(s).

HTH,
TC
 
Back
Top