If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Picker
The in-built date picker is a great function in Access 2007, but anyone know
how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
#2
|
|||
|
|||
Date Picker
Haven't worked with ACC2007, but I'm assuming the date is assigned to the
given field in the DP's AfterUpdate event. Go into the code editor, find this event and place your refresh/requery code after the date's been inserted. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200708/1 |
#3
|
|||
|
|||
Date Picker
This is one of the reasons I use my own Access form as a calendar. The
calling event can also run other code.: http://www.datastrat.com/Download/Calendar2K.zip The calendar is written in VBA and will run in 2007 as is or converted to the 2007 format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "spike_h" wrote in message ... The in-built date picker is a great function in Access 2007, but anyone know how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
#4
|
|||
|
|||
Date Picker
Many thanks - great. It is just a pity that MS havent given the datepicker
its own property sheet... "Arvin Meyer [MVP]" wrote: This is one of the reasons I use my own Access form as a calendar. The calling event can also run other code.: http://www.datastrat.com/Download/Calendar2K.zip The calendar is written in VBA and will run in 2007 as is or converted to the 2007 format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "spike_h" wrote in message ... The in-built date picker is a great function in Access 2007, but anyone know how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
#5
|
|||
|
|||
Date Picker
Sorry, but as far as I can see, the datepicker has no property sheet to
configure events - hence the problem. "missinglinq via AccessMonster.com" wrote: Haven't worked with ACC2007, but I'm assuming the date is assigned to the given field in the DP's AfterUpdate event. Go into the code editor, find this event and place your refresh/requery code after the date's been inserted. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200708/1 |
#6
|
|||
|
|||
Date Picker
This must be something new in 2007. In previous versions ActiveX items, such
as DatePicker only had limited Property Box items, but their full properties were available thru the VB Editor, you just had to know to look for them. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200708/1 |
#7
|
|||
|
|||
Date Picker
I too have always provided a custom date picker in every application I've
developed and now Vista has caused me great grief in the the picker icon happens to be in the same place as my "Open Calendar Dialog" button. Is there an Option I can set to stop that picker appearing? "Arvin Meyer [MVP]" wrote: This is one of the reasons I use my own Access form as a calendar. The calling event can also run other code.: http://www.datastrat.com/Download/Calendar2K.zip The calendar is written in VBA and will run in 2007 as is or converted to the 2007 format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "spike_h" wrote in message ... The in-built date picker is a great function in Access 2007, but anyone know how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
#8
|
|||
|
|||
Date Picker
Sorry, let me rephase that.
I have a custom date picker dialog form. I put the button to open that form next to text boxes where the user enters the date. Because I set the format to "Date/Time", in VISTA an icon appears over the top of my button. How do I stop the default Vista date picker icon from appearing when the user enters my text box? "Dom" wrote: I too have always provided a custom date picker in every application I've developed and now Vista has caused me great grief in the the picker icon happens to be in the same place as my "Open Calendar Dialog" button. Is there an Option I can set to stop that picker appearing? "Arvin Meyer [MVP]" wrote: This is one of the reasons I use my own Access form as a calendar. The calling event can also run other code.: http://www.datastrat.com/Download/Calendar2K.zip The calendar is written in VBA and will run in 2007 as is or converted to the 2007 format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "spike_h" wrote in message ... The in-built date picker is a great function in Access 2007, but anyone know how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
#9
|
|||
|
|||
Date Picker
I think you can delete it. If you have a 2003 or earlier version, it should
run fine in 2007. Until I get fully used to 2007, I work in 2002 or 2003 (or sometimes even in Access 97), and then test on a 2007 machine. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Dom" wrote in message ... I too have always provided a custom date picker in every application I've developed and now Vista has caused me great grief in the the picker icon happens to be in the same place as my "Open Calendar Dialog" button. Is there an Option I can set to stop that picker appearing? "Arvin Meyer [MVP]" wrote: This is one of the reasons I use my own Access form as a calendar. The calling event can also run other code.: http://www.datastrat.com/Download/Calendar2K.zip The calendar is written in VBA and will run in 2007 as is or converted to the 2007 format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "spike_h" wrote in message ... The in-built date picker is a great function in Access 2007, but anyone know how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
#10
|
|||
|
|||
Date Picker
Look at the code in my calendar app.:
http://www.datastrat.com/Download/Calendar2K.zip It uses the Double-Click event. Superfast typists who prefer not to use a mouse, simply type in a date. Any one who, like me, likes the mouse, simply reaches over and double-clicks on it. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Dom" wrote in message ... Sorry, let me rephase that. I have a custom date picker dialog form. I put the button to open that form next to text boxes where the user enters the date. Because I set the format to "Date/Time", in VISTA an icon appears over the top of my button. How do I stop the default Vista date picker icon from appearing when the user enters my text box? "Dom" wrote: I too have always provided a custom date picker in every application I've developed and now Vista has caused me great grief in the the picker icon happens to be in the same place as my "Open Calendar Dialog" button. Is there an Option I can set to stop that picker appearing? "Arvin Meyer [MVP]" wrote: This is one of the reasons I use my own Access form as a calendar. The calling event can also run other code.: http://www.datastrat.com/Download/Calendar2K.zip The calendar is written in VBA and will run in 2007 as is or converted to the 2007 format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "spike_h" wrote in message ... The in-built date picker is a great function in Access 2007, but anyone know how to apply an Event Procedure (eg Refresh or Requery) after selecting a date using the datepicker? Selecting a date seems merely to enter the data into the field and no event actually occurs until tabbing out of the control. I use several forms based on queries with a user-defined date range - Have I missed something or is this a bug.... (I know it is quicker just to input a date from the keyboard, but users seem to like this popup datepicker function) |
|
Thread Tools | |
Display Modes | |
|
|