I could look for the answer but...

S

Steven Sutton

....lets face it, there are a LOT of postings here. So I hope someone will
read this and take pity on this lazy soul.

I work for a commercial printer and would like to enter the data from our
press runs into a database. My question has to do with the actual data entry.
Let's use as an example two press runs Run1 and Run2. They are identical in
their configuration (ie - number of pages, which pages have color, etc.) and
only vary in the specifics of the press run itself - number of copies
ordered, number of copies printed, etc. So my question is, after entering all
of eh data for Run1, how do I create a new record for Run2 which copies
certain fields from Run1's record? Thanks for any assistance.
 
G

G. Vaught

Help in Access is another excellent start. See Duplicating records.

one of the quickest ways is to use the Ctrl " which will copy the previous
fields value to the current field.

The way to do it completely is to copy the row and paste it down to the new
row. This works best if the form is in datasheet view.

Or you can write code behind a button to 'clone' the previous record to the
new record.
 
D

doco

Use ctrl ' not ctrl "

doco


G. Vaught said:
Help in Access is another excellent start. See Duplicating records.

one of the quickest ways is to use the Ctrl " which will copy the previous
fields value to the current field.

The way to do it completely is to copy the row and paste it down to the
new row. This works best if the form is in datasheet view.

Or you can write code behind a button to 'clone' the previous record to
the new record.
Click to expand...
 
M

M.L. Sco Scofield

Actually both work.

Whether you're holding down the shift key or not, it's <Ctl>+ the <" '> key.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
B

Brendan Reynolds

Perhaps I might be able to clear up a little misunderstanding here.

On a US keyboard, the apostrophe and double quote share the same key. But in
other keyboard layouts, even other English language keyboard layouts, that
is not always so. In the UK and Ireland, for example, the apostrophe shares
a key with the @ symbol, the double quote shares a key with the digit 2.

So Sco and doco are *both* right! :)

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
M

M.L. Sco Scofield

Brendan,

Great point.

Us U.S. people. How arrogant...

So tell me, with the apostrophe and quote on different keys, do both work on
a non-US keyboard?

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
B

Brendan Reynolds

I never thought to try that, and when I did, I was amazed to find that yes,
Ctrl+2 does actually function the same as Ctrl+', with or without the Shift
key held down at the same time. Looks like someone at Microsoft really
covered all the bases on this one! :)
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
M

M.L. Sco Scofield

Cool! Thanks for checking this out Brendan. You're a good man.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top