My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Vba To Open Date Picker On Focus, Office 2007
|
|
 Apr 17 2012, 07:57 AM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 88  |
Good morning!
What I want to be able to do is when I tab into a field that is for a date, I want the date picker to automatically appear so I don't have to use the mouse to click on it. I couldn't find anything as a macro, and I'm not at the level yet to write VBA to make it work. Any help would be great. Thanks |
 |
 
|
|
Apr 17 2012, 08:58 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 9,430 From: Wisconsin |
Kattracks,
Open the form in Design View. Select the textbox that will store the date. Open the Properties box. Under the Events tab, select the On Got Focus event. A small button with three buttons will appear to the right of where you clicked. Click this button, and you'll be taken to the Visual Basic Editor, with a header and footer defined for that control's On Got Focus event. Something along these lines: CODE Private Sub dteTestDate_GotFocus() End Sub Add the following line of code between the header and footer: CODE Application.RunCommand (acCmdShowDatePicker) This should open the date picker every time you tab into that textbox, or click on the textbox. Hope this helps, Dennis |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th June 2013 - 07:28 PM |
Tag cloud:
ms access vba open date picker, access 2007 vba to show the date picker, access code to toggle date picker, access 2007 open calender, microsoft access vba expand date picker, access vba show date picker button, datapicker msaccess, how to show date picker vba, access 2007 unbound form date picker, Show DatePicker vba, microsoft access vba open date picker, ms access date picker, vba date selection, access 2007 datapicker control vba form