Access shortcut

Alan Green 0 Reputation points
2023-10-16T11:21:18.06+00:00

I used to be able to copy a field entry from the previous record in a table by Ctl '. It now no longer works. Is there now another way? Copying and pasting takes too many key strokes.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
834 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
600 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Ken Sheridan 2,671 Reputation points
    2023-10-17T11:19:55.0433333+00:00

    You might like to take a look at Defaults.zip in my public databases folder at: 

    https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169 

    This little demo file illustrates how, when a new record is inserted, the contents of a bound control can be set as the default value for that control when further records are inserted.  This done by means of a small check box beside each control.  Two methods are illustrated, one in which the default values are set for the current session only, the other in which the default values are carried forward to subsequent sessions until cancelled. 

    Note that if this is done for a form opened in datasheet view it will be necessary to set the form's detail section's tab order so that each check box appears beside its relevant column.


  2. Albert Kallal 4,971 Reputation points
    2023-10-23T16:09:12.9+00:00

    The shortcut key(s) should still work.

    Some handy ones - been using for 20 years in Access.

    ctrl-; this inserts today's date

    ctrl-: this inserts the current time (12 hour format, with am/pm)

    ctrl-' This enters (copies) the last value you entered in this field.

    I should point out that most of these "near forgotten" shortcuts work in Excel also...

    and as a FYI?

    Ctrl-. no that does not, and did not copy the previous value - that shortcut will in fact rotate from view to design to layout view for a form.

    0 comments No comments