Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

database+courses+london - microsoft access

Forum home » Delegate support and help forum » Microsoft Access Training and help » database+courses+london - Microsoft Access

database+courses+london - Microsoft Access

ResolvedVersion Standard

Samantha has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Microsoft Access

When entering details onto a form is there any way to duplicate more than one field from the previous answers already entered. (I know you can go to design view, then properties, then event and by pressing the button with '...') this keeps records the same as prevoiusly entered, but you have to do this every time you enter the form. Is There any other way of doing this?

RE: Microsoft Access

Hi Samantha,
Thanks for your post, to duplicate the field above in a table you can press the keyboard combination CTRL+' (apostrophy)

RE: Microsoft Access

If you have more than one field in a form that needs to be kept the same as previous entry (In form) is there anyway to duplicate the same infomation from prevoius form enrty without keep pressing CTRL+' in each field?

RE: Microsoft Access

Hi again Samantha, Well after much searching the only way I can come up with is to copy the entire record, open a new record and paste the details, sorry if this is not what you want to accomplish, please come back if you have any more to add, regards Pete

RE: Microsoft Access

Thank-you Pete!

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.