Darren DICK
d.dick at uws.edu.au
Mon Jun 9 18:53:27 CDT 2003
No <<From the Help>>> The Requery method updates the data underlying a form or control to reflect records that are new to or have been deleted from the record source since it was last requeried. The Refresh method shows only changes that have been made to the current set of records; it doesn't reflect new records or deleted records in the record source. The Repaint method simply repaints the specified form and its controls. ----- Original Message ----- From: "Reuben Cummings" <reuben at gfconsultants.com> To: <accessd at databaseadvisors.com> Sent: Tuesday, June 10, 2003 5:33 AM Subject: RE: [AccessD] Function Keys - A2K > Thanks for everyone's help. I got it finished. > > Is F9 requery? > > Reuben Cummings > Director of Software Development > GFC, LLC > phone: 812.523.1017 > email: reuben at gfconsultants.com > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman > > Sent: Monday, June 09, 2003 1:42 PM > > To: accessd at databaseadvisors.com > > Subject: RE: [AccessD] Function Keys - A2K > > > > > > Reuben, > > > > <<What's the purpose of "key preview = yes"?>> > > > > It allows a form to preview a keystroke before it's sent to a control. > > > > Also, if you want this app wide, simply use the Autokeys macro. > > > > Jim Dettman > > President, > > Online Computer Services of WNY, Inc. > > (315) 699-3443 > > jimdettman at earthlink.net > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben > > Cummings > > Sent: Monday, June 09, 2003 2:29 PM > > To: accessd at databaseadvisors.com > > Subject: RE: [AccessD] Function Keys - A2K > > > > > > What's the purpose of "key preview = yes"? > > > > Reuben Cummings > > Director of Software Development > > GFC, LLC > > phone: 812.523.1017 > > email: reuben at gfconsultants.com > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David McAFee > > > (Home) > > > Sent: Monday, June 09, 2003 12:06 PM > > > To: accessd at databaseadvisors.com > > > Cc: reuben at gfconsultants.com > > > Subject: RE: [AccessD] Function Keys - A2K > > > > > > > > > In you form's properties, set "key preview" to "yes" and place > > > the following > > > code in the "On Key Up" event: > > > > > > Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) > > > Select Case KeyCode > > > Case 27 'Escape was pressed > > > KeyCode = 0 'Setting a keycode to 0 will "disable" > > that key's > > > function > > > Case 114 'F3 was pressed > > > Call YourFunctionNameHere() > > > Case 116 'F5 was pressed > > > Msgbox "F5 was pressed" > > > Case 117 'F6 was pressed > > > Msgbox "F6 was pressed" > > > Case 119 'F8 was pressed > > > Msgbox "F8 was pressed" > > > Case 120 'F9 was pressed > > > Msgbox "F9 was pressed" > > > Case 121 'F10 was pressed > > > Msgbox "F10 was pressed" > > > 'Case vbKeyF12 'F12 was pressed '<-- Can also call this way > > > 'Msgbox "F12 was pressed" > > > End Select > > > End Sub > > > > > > > > > HTH > > > David McAfee > > > > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben > > > Cummings > > > Sent: Monday, June 09, 2003 9:41 AM > > > To: AccessD > > > Subject: [AccessD] Function Keys - A2K > > > > > > > > > How do I access the powers the function keys in an Access app? > > > > > > I want to use F3 (or whatever) to perform a certain function. How can I > > > call the function using an F3 keypress? > > > > > > Thanks. > > > > > > Reuben Cummings > > > Director of Software Development > > > GFC, LLC > > > phone: 812.523.1017 > > > email: reuben at gfconsultants.com > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com