Go Back   Access World Forums > Microsoft Access Reference > Code Repository

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 01-15-2018, 09:59 AM   #1
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,380
Thanks: 115
Thanked 3,112 Times in 2,830 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
TIP: How to fill down in Access tables, queries and forms

As is widely known Excel has a very useful autofill feature.

AFAIK much less well known is the Access 'equivalent' which allows you to copy the value from the same field in the previous record to the current record

To do so use the keyboard shortcut Ctrl+' (apostrophe)
This works both to fill an empty field or to replace an existing value
It works in tables, queries & continuous / datasheet forms

Of course you can also do this using copy & paste but that needs more clicks ...

A complete(?) list of keyboard shortcuts can be found here:
https://support.office.com/en-gb/art...5-3320fa6606e2
I'd be amazed if anyone here knows & uses all of them ....!

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline  
The Following 2 Users Say Thank You to isladogs For This Useful Post:
abanard (08-16-2018), Tera (11-11-2019)
Old 01-15-2018, 02:27 PM   #2
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,821
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Re: TIP: How to fill down in Access tables, queries and forms

Thanks for the tip Colin.
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline  
Old 01-15-2018, 02:31 PM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,376
Thanks: 556
Thanked 949 Times in 898 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: TIP: How to fill down in Access tables, queries and forms

I demonstrate a method of doing similar within a subform with VBA code:- http://www.niftyaccess.com/subform-record-duplicator/ - there's a paid for and free option...

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline  
Old 11-11-2019, 10:15 AM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,380
Thanks: 115
Thanked 3,112 Times in 2,830 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: TIP: How to fill down in Access tables, queries and forms

UPDATE 11/11/2019:
If you need to duplicate the contents of several fields at once, you may be interested in an example application by AWF member APR Pillai.

He uses the Tag property to Duplicate Multiple Fields in a record to the next record with conditional formatting

This is part of his Learn MS Access Tips & Tricks website which I recommend strongly.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline  
The Following User Says Thank You to isladogs For This Useful Post:
Tera (11-11-2019)
Closed Thread

Tags
fill down shortcut

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tables, Queries or Forms dichotomous General 22 05-07-2013 01:26 PM
Word/pdf forms to fill in with data from access tables nayaz Tables 0 12-23-2009 07:26 AM
Forms, better to be based on queries than tables? Chaz Forms 10 07-02-2009 07:45 AM
Using Access VBA code to count all forms, tables, queries, reports, vba modules, etc. kdnichols General 10 11-20-2008 03:24 PM
Auto-Fill Forms with Data from Multiple Tables hitpoint Forms 12 07-14-2008 10:47 AM




All times are GMT -8. The time now is 12:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World