MS Access Keyboard Shortcuts – Shortcut to Select All SQL Text

keyboard shortcutsms accesswindows

When working in the SQL view in MS Access, is there a shortcut to select all the text in a SQL query.

For example, most text editors in Windows follow the {Ctrl+ a} combination, but this doesn't seem to have any affect within Access. Is there some other combination?

It is useful when copying text from an outside editor into the Access SQL query creator.

Thanks!

Best Answer

MS-Access 2016

Create a new SQL view, write some text and then press F2.

Related Solutions

Ms-access – Microsoft Access constrain view by date in outer query

How about:

SELECT a.orderid,
       a.ocustomerid
FROM   orders AS a
       INNER JOIN (SELECT b.orderid,
                          b.ocustomerid
                          b.opromisedshipdate
                   FROM   orders AS b
                   ) AS c
       ON c.orderid = a.orderid 
WHERE  c.opromisedshipdate = a.opromisedshipdate

MS Access VBA – SQL Update Where Clause Not Working

Its happening because variable name is not correctly placed inside update code and as both column name and variable name are same so according to your current code you are updating all the records.

Try this

sqlcmd = "UPDATE 1_tbl_Memberships SET [1_tbl_Memberships].Member =
No WHERE [1_tbl_Memberships].GroupMembershipID = "& GroupMembershipID &""

http://msdn.microsoft.com/en-us/library/office/aa212163(v=office.11).aspx

Best Answer

Related Solutions

Ms-access – Microsoft Access constrain view by date in outer query

MS Access VBA – SQL Update Where Clause Not Working

Related Question