keyboard shortcuts - Short cut to move in sub-mask in MS-Access

06
2014-04
  • Ale

    I have a mask with 3 different sub-masks in this layout

    • main (level 0)
      • submask1 (level 1)
      • submask2 (level 1)
      • submask3 (level 1)

    when I use to entry data I can move the cursor using TAB.

    After the last field of the main mask I use TAB to go in the first field of the sub-mask1.

    If i use TAB after the last field of the sub-mask1, it generate another sub-record in the sub-mask1, while I need to move the cursor in the first field of the sub-mask2 and so on...

    Is there a keybord way to move the cursor as I need without using the mouse?

    • Answers
    Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

    Related Question

    MS Access split database queries
  • Lance Roberts

    When the frontend of a MS Access db queries a MS Access backend on another machine over the network, does it pull in the whole table/database/file, or does it have some way of extracting just what it needs from the backend, thereby lessening network load.


    • Related Answers
  • Doug

    The Access Database engine will only will read what it needs. However, this might mean more data is transferred across the network than you might think.

    For example, if the table is indexed so that a full data scan is not needed to find your record, then it will read the index first, then only those records to satisfy the query results. Minimal data is moved across the network.

    However, if you only return one row from a large table where there is no index, then the full table will be transferred across the network. This is because the query process is running on the client machine, and it needs to read all the data to do a table scan.

    Thus, if you are creating an access app using this method, make sure your tables are appropriately indexed.

  • MrGreen

    It's hard to answer exactly. Do you mean opening the database over a network?

    I'm assuming you mean the frontend and backend are in a single MDB file.

    When a query is performed (depending on the query), it will only grab the data it needs. This is true for most databases. However when the file is opened, the database integrity is checked.

    For more information on the JET database backend, go here: http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine