| | |
|
|
|
Data entry short cuts? (Auto range) |
|---|
| message from =?Utf-8?B?U2Vhbk0=?= on 17 May 2004 |
I want to populate a subform that simply lists job numbers, operation, numbers and part description. If I have 10 consecutively numbered jobs to enter, is there a mechanism to enter the range of jobs (J1001 through 1012J as opposed to enetring a record for each?
Thanks,
Sean
|
| Michelle replied to =?Utf-8?B?U2Vhbk0=?= on 17 May 2004 |
I would think you could just use some type of coding on your form to do
this; many ways to do it, but here's one way.
You could have the user enter the first subform record (Job Number,
Operation, Number, Part Desc), then have a button called "btnDuplicate"
that, when clicked, would popup a form that asks the user for the ending job
number, then use code to duplicate the original subform record in the
recordset, replacing the Job Number with the next Job Number in sequence.
Your post lists jobs J1001 through 1012J, which wouldn't work, your job
numbers would have to be something more like J1001 through J1010, with no
gaps.
"SeanM" <anonymous@discussions.microsoft.com> wrote in message
news:B66CFDC9-EB6C-4693-B694-703AB5DB605A@microsoft.com...
numbers and part description. If I have 10 consecutively numbered jobs to
enter, is there a mechanism to enter the range of jobs (J1001 through 1012J
as opposed to enetring a record for each?
|
|
Archived message: Data entry short cuts? (Auto range) (MS Access Database)
