Kamis, 22 September 2011

RE: [MS_AccessPros] How to speed up data entry - entry several rows of data from 1 simple form?

 


Nige,

Based on "shipment of 150 units" and "select part number and enter SDN number and date for each row, when they are all the same!" I would review the table structure where there might be this much repeating information. I don't know what your table structure is but have you considered a shipment header table with the SDN and shipment date and a shipment detail table with the shipment ID and part number?

If you don't want to change your table structure, you can use a main form with SDN and Shipment Date and a subform with your current table. Set the Link Master and Link Child properties to the SDN adn Shipment Date. This will automatically default the values in the subform to the values from the main form.

Duane Hookom
MS Access MVP


From: nigel@pegasusconsulting.co.uk

Thanks Bill and Paul for your help - everything in my simple warranty database is now working as intended!

Now...I have new records added one row at a time...a user clicks 'add new' to get a blank row, enters the serial number, selects the part number from a combo box, enters the SDN (delivery note) number and enters the SDN date.

That's all great, until despatch have a shipment of 150 units, then it's laborious having to select part number and enter SDN number and date for each row, when they are all the same!

So...I'd like to create a new form 'enter shipment' in which the user selects the part number and enters SDN number and date at the top, only once, then in a text or memo field enters all serial numbers on separate rows (by scanning bar codes, so very quick), then hit 'submit' and the database creates rows in the table for each serial number that has been scanned, using the part/sdn/date data for each.

But, as usual, I don't know how to achieve this, so can someone point me in the right direction?

Cheers, Nige



[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar