Forms that allows me to enter mutli record before saving to tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SeeKY - 10 Jan 2005 13:59 GMT

To explain further....

I have 1 PO# with 5 items. I only want to save the record after entering all
5 items. Maybe by Using a Button control.
After confirming the PO i wish to clear the field for another PO.

How do i do with this? Using a datasheet form?
Anyone care to explain briefly so that i got a rough item

Reply to this Message

Steve Schapel - 10 Jan 2005 18:05 GMT

SeeKY,

One approach to this would be to have a have your Items subform bound to
a "holding" table, so you enter the items in there, and then when the
entries are confirmed, you run an Append Query to add these records to
the main PO Items table, and delete them from the temporary holding table.

Signature

Steve Schapel, Microsoft Access MVP

> To explain further....
>
[quoted text clipped - 4 lines]
> How do i do with this? Using a datasheet form?
> Anyone care to explain briefly so that i got a rough item

Reply to this Message

PC Datasheet - 10 Jan 2005 20:29 GMT

A downside to this is that frequent adding and deleting records in the temp
table will make the database quickly bloat!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> SeeKY,
>
[quoted text clipped - 14 lines]
> > How do i do with this? Using a datasheet form?
> > Anyone care to explain briefly so that i got a rough item

Reply to this Message

Steve Schapel - 11 Jan 2005 05:15 GMT

Tools|Options|General|Compact On Close.

Signature

Steve Schapel, Microsoft Access MVP

> A downside to this is that frequent adding and deleting records in the temp
> table will make the database quickly bloat!

Reply to this Message