Lebans Calendar Control

I have a continuous subform embedded on a main form.  The Totals query 
underlying the subform calculates the total number of hours and their value 
based on each staff member's BillingRate.

The subform is linked to the main form by the ProjectNumber.

There is query criteria that references two textboxes on the main form that 
hold the starting and ending date of the period to be examined.  I am 
attempting to use Steven Lebans fantastic calendar control to select the 
start and end dates, afterwhich I want to requery the subform, but for 
reasons I don't understand, changing the date does not trigger the OnUpdate 
event. 

Does anyone know why and/or know of another event I can use?

Thank you.

Sprinks
0
Utf
6/15/2007 8:34:08 PM
access.forms 6864 articles. 1 followers. Follow

4 Replies
415 Views

Similar Articles

[PageSpeed] 18

Programmatically changed controls do not trigger events in the control, only
user actions will do that.

Sprinks wrote:
>I have a continuous subform embedded on a main form.  The Totals query 
>underlying the subform calculates the total number of hours and their value 
>based on each staff member's BillingRate.
>
>The subform is linked to the main form by the ProjectNumber.
>
>There is query criteria that references two textboxes on the main form that 
>hold the starting and ending date of the period to be examined.  I am 
>attempting to use Steven Lebans fantastic calendar control to select the 
>start and end dates, afterwhich I want to requery the subform, but for 
>reasons I don't understand, changing the date does not trigger the OnUpdate 
>event. 
>
>Does anyone know why and/or know of another event I can use?
>
>Thank you.
>
>Sprinks

-- 
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200706/1

0
ruralguy
6/15/2007 10:12:22 PM
Call your update code in the code that changes the date in your textbox 
after you change the date. Something like:

Me!NameOfTextbox = >>Calendar Date>>
Call Sub NameOfTextbox_AfterUpdate
Me!NameOfSubformControl.form.requery

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@pcdatasheet.com






"Sprinks" <Sprinks@discussions.microsoft.com> wrote in message 
news:6571C660-695E-4761-9939-2AEF93E22E52@microsoft.com...
>I have a continuous subform embedded on a main form.  The Totals query
> underlying the subform calculates the total number of hours and their 
> value
> based on each staff member's BillingRate.
>
> The subform is linked to the main form by the ProjectNumber.
>
> There is query criteria that references two textboxes on the main form 
> that
> hold the starting and ending date of the period to be examined.  I am
> attempting to use Steven Lebans fantastic calendar control to select the
> start and end dates, afterwhich I want to requery the subform, but for
> reasons I don't understand, changing the date does not trigger the 
> OnUpdate
> event.
>
> Does anyone know why and/or know of another event I can use?
>
> Thank you.
>
> Sprinks 


0
Steve
6/15/2007 10:54:39 PM
Filling a control by using code does not trigger any of the events for that 
control. In most cases, you can add the code you want to the code you are 
using to fill the control. In this case, I'm not sure that's possible. You 
may need to use the ActiveX calendar control that comes with Access so that 
you have a single instance of code. There is an example at my website:

http://www.datastrat.com/Download/XCalendar2K.zip

-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Sprinks" <Sprinks@discussions.microsoft.com> wrote in message 
news:6571C660-695E-4761-9939-2AEF93E22E52@microsoft.com...
>I have a continuous subform embedded on a main form.  The Totals query
> underlying the subform calculates the total number of hours and their 
> value
> based on each staff member's BillingRate.
>
> The subform is linked to the main form by the ProjectNumber.
>
> There is query criteria that references two textboxes on the main form 
> that
> hold the starting and ending date of the period to be examined.  I am
> attempting to use Steven Lebans fantastic calendar control to select the
> start and end dates, afterwhich I want to requery the subform, but for
> reasons I don't understand, changing the date does not trigger the 
> OnUpdate
> event.
>
> Does anyone know why and/or know of another event I can use?
>
> Thank you.
>
> Sprinks 


0
Arvin
6/16/2007 1:35:55 AM
ruralguy, Steve, and Arvin,

Thank you for explaining why the events did not trigger and for your 
suggestions.  In this case, putting the .requery code in the control's own 
Double_Click event which calls the Calendar control works great.

Sprinks


"Arvin Meyer [MVP]" wrote:

> Filling a control by using code does not trigger any of the events for that 
> control. In most cases, you can add the code you want to the code you are 
> using to fill the control. In this case, I'm not sure that's possible. You 
> may need to use the ActiveX calendar control that comes with Access so that 
> you have a single instance of code. There is an example at my website:
> 
> http://www.datastrat.com/Download/XCalendar2K.zip
> 
> -- 
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
> 
> "Sprinks" <Sprinks@discussions.microsoft.com> wrote in message 
> news:6571C660-695E-4761-9939-2AEF93E22E52@microsoft.com...
> >I have a continuous subform embedded on a main form.  The Totals query
> > underlying the subform calculates the total number of hours and their 
> > value
> > based on each staff member's BillingRate.
> >
> > The subform is linked to the main form by the ProjectNumber.
> >
> > There is query criteria that references two textboxes on the main form 
> > that
> > hold the starting and ending date of the period to be examined.  I am
> > attempting to use Steven Lebans fantastic calendar control to select the
> > start and end dates, afterwhich I want to requery the subform, but for
> > reasons I don't understand, changing the date does not trigger the 
> > OnUpdate
> > event.
> >
> > Does anyone know why and/or know of another event I can use?
> >
> > Thank you.
> >
> > Sprinks 
> 
> 
> 
0
Utf
6/19/2007 1:51:05 PM
Reply:

Similar Artilces:

Do I need to use VBA for the following control structure?
Hi all, I have the following control structure from Matlab, do you think I need VBA to handle it, or I can just rely on Excel? Thanks a lot! ----------------------------------------- for t=1:5; CumLoss=CumLoss+sum(DefaultTime(:, t)); if (CumLoss>TotalNotional*Deattachment) break; else PV=PV+y*(TotalNotional-CumLoss)/(1+r)^t; if t==5 PV=PV+(TotalNotional-CumLoss)/(1+r)^t; end; end; end; You can just rely on Excel: In row 1 put the labels t,DefaultTime, CumLoss,PV,TotalNotional,D...

Outlook 2007 SP2 calendar issue off by 1 hour??
we are having a minor issue with a few users with thier calendar being off by an hour? these are all users with new machines, with all updates installed, and also using new blackberrys, also with the newest OS installed. i maintain a windows server update server in our domain, and push out all of the approved updates, so i know that they are installed. any ideas??? ok, more info on this. i believe its the Outlook client on the end users machine, as i was able to log into his account in webmail and any new appointment i set up for next week was fine, except for when he l...

Syncing with Blackberry: bug with private events in calendar?
When I create a "private" calendar event in the Blackberry, the corresponding entry that appears in Outlook does not have the private flag set. Our synchronizing is using the Blackberry Wireless Sync, and we use MS Exchange and a Blackberry Enterprise Server. Is this a bug/known limitation? Thats a good question. I too have experienced this. doesnt bother me much as i dont set many 'private' calendar events. Hope you find resolution! -- Dan Schlicht Microsoft Gold Partner / MBS Partner - Great Plains / Small Business Specialist Platinum Systems, Inc. Kenosha, ...

Lebans tooltip control 10-28-07
I am trying to use the tooltip control on a form with a tab control, on which are the other controls I want to show information for. On controls that are outside the tab control, it works fine; on controls inside the tab control, the tooltip shows on text boxes only when they have the focus, and on check boxes not at all. I've tried every naming scheme for controls I can think of, without any luck. Anybody have any ideas about this??? Is it the same problem as using a subform???? I am using ACCESS 2003 -- Jack Walsh ...

ethernet controller issue
hi, i posted previously but need to clarify. my device mgr indicates no driver installed for my ethernet controller (NOT the ethernet adapter) as well as the video and audio controller (i can't hear sound from my media player either.) it seems that the controller and adapter are two different things - the ethernet adapter is above the ethernet controller in the device mgr, but only the controller has a yellow question mark (shown as under 'other devices.') along with the audio and video controller. i understand that an ethernet controller has two other names: a &qu...

Visual controls
Where can I found and install more GUI controls for VC6? I need something like TPanel in Borland (Delphi or C++ Builder) tools. I need to make small blue rectangle around picture and WebBrowser control. Which GUI control is the best for it? I've tried to use CStatic, but it is allways showing in a front of WebBrowser control. :( How can I "sent it" to background? Petar, CStatic would do fine. You'll have to be aware, however, that in MSVC++ 6.0, the controls are created in the reverse order from the resource editor, so you should place the static on top of the ...

Monthly Calendar Report
I have a db with a table that has employee names and dates scheduled for the year. Could someone please direct me on how to create a report (or even an examples of reports) that shows a monthly calendar report for the year with the employee names for each day. There can be several employees of for one day and I need for all of the names to show under that date. Thanks in advance for any help you can provide. Dennis wrote: >I have a db with a table that has employee names and dates scheduled for the >year. Could someone please direct me on how to create a report (or even an &...

How to move Calendar items from one Calendar folder to another?
Hello How to move Calendar items from one Calendar folder to another? I'm tempted to say "Drag & Drop them" but you might have already tried that... "Dmitry Kopnichev" <kopn@bk.ruDelete> wrote in message news:ezxf2$e5FHA.2560@TK2MSFTNGP12.phx.gbl... > Hello > How to move Calendar items from one Calendar folder to another? Yes, I have already tried that. They do not follow. "Vince Averello [MVP-Outlook]" <vince@omegageek.com> �������/�������� � �������� ���������: news:Og2ZHGf5FHA.4076@tk2msftngp13.phx.gbl... > I'm tempted ...

calendar again
Is there a way to change the first day of the calendar from Monday to Sunday. When I print the calendar it always prints Monday as the first day? Thanks You should be able to change the first day of the week here for monthly calendars: Tools menu > Options > Calendar "alleycat" <alleycat@discussions.microsoft.com> wrote in message news:211FEB7F-0E0E-45D5-850E-B3F043D2B0ED@microsoft.com... > Is there a way to change the first day of the calendar from Monday to > Sunday. > When I print the calendar it always prints Monday as the first day? Thanks Hi - I ha...

Control apostrophe
When you press Control Apostrophe the previous record's data is entered into the field on a form. Is there a code that I can enter On Load property of the form so that some (not all) of the fields will automatically fill in with data from the previous record. In other words is there a VBA code for Control Apostrophe? Thanking you in advance Leo Here are my notes on setting up default values: Private Sub controlname_AfterUpdate() 'text field Me.TheTextControl.DefaultValue = """" & Me. TheTextControl & """" 'date...

Getting rid of border around ActiveX control
Hello, I write an ActiveX control that automates MS Word. Specifically, the control embeds MS Word into a PowerPoint presentation. The problem that I faced is a thin border around the control when the presentation is run. I need to get rid of it so that there are no any borders around the control. I have tried to resize the control by calling the main frame's MoveWindow hoping the border will move out of the visible area, but the border still persists. Apparently, the border has nothing to do with the main frame. So the question is - how to get rid of this border? Thanks in advance. Denn...

Service Calendar Error #2
All, Everything is working fine in CRM except Service Calendar get an error: "Server was unable to process request." So, anybody knows what's going on? and let me know and I'd appreciate it. Thanks Never mind. I got it. "Toi Day" wrote: > All, > Everything is working fine in CRM except Service Calendar get an error: > "Server was unable to process request." > So, anybody knows what's going on? and let me know and I'd appreciate it. > > Thanks It would by nice if you share youre solution with us. Thanks "Toi Day"...

sending calendar to another
i'm toldther is a waty to send my vcalendar to anotther in aemail- something to do with exportbut i don't know how todo it al help to a daft disabled stroke victim gratedfully recieved thanks peter.......... peterftl.codner@tiscali.co.uk ...

Attendance Calendar
I need code for a calendar that will allow me to pick a day(s) for a user and also specify how many hours will be taken on that day. The individual days, along with the hours, then need to be added to a table so the hours can be tracked for a 12 month period. I have found code for an attendance calendar which gets me part way there. http://www.mvps.org/access/resources/downloads.htm It doesn't allow hours to be entered or to click off the day if it was chosen by mistake. Does anyone know of code that will do everything I need? Thanks in advance. This doesn't allow entering...

Calendar Events Disappear
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3342616917_3188718 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit Snow Leopard I enter an event in calendar � and within 10 seconds � it just disappears. I have verified the database � says all is fine. I hope someone has the answer to this. Thanks --B_3342616917_3188718 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable <HTML&g...

Creating and displaying bitmap in a tab control
Hi, I'm creating a custom-draw tab control, and am trying to draw a close button (x) at the end of an item. I've created a bitmap with the close (x) in black color, and the surrouding in white. I add the bitmap to an imagelist and use the CImageList::Draw() method to draw the bitmap. But when the bitmap is displayed, the close symbol is displayed in white, and the surrounding in white itself. I want the close symbol to be drawn in black, but the surrounding (background) to be the same as the tab control's color (i.e grayish). How do I do this? TIA, SD how you are creating...

to lebans
Master your rtf2.ocx and he dropped me has worked to perfection in a The project that I developed for the company in which I work alone Missing power can be drawn whether or cancel the context menu that has Because I have replaced by buttons that use their same functions and Spanish hope will not be offended now if you need buy I would like to tell me their price with the modification thanks for teaching A little more every day and I ask forgiveness if I could not write a better English but I am of Argentine greetings OWE Systems I'm sorry but I do not understand your question. Could y...

Stephen Lebans A97ReportToPDF
Is this still available? I am running Access97 and don't have a later version with which to open the current version and then convert to A97? I currently email out reports to multiple email addresses as RTF files but am not happy with the formatting. Will A97ReportToPDF (if still available) allow me to do the same but as PDF files? Thanks in advance. Piri ...

Transform table into calendar format
I have a table with dates (column A) and events (column B). I wanted to know how I automatically create a calendar template with the events I have on this separate sheet. Send me an email to: pashurst <at> auditel.net (change the obvious), and I'll send you a file that does just what you describe. Hope this helps. Pete On Nov 18, 9:55=A0pm, Matheus <Math...@discussions.microsoft.com> wrote: > I have a table with dates (column A) and events (column B). I wanted to k= now > how I automatically create a calendar template with the events I have on = ...

time based calendar editing
am wondering how i can get the functionality to do time based calendar editing with outlook and exchange. We want to be able to create a calendar which is only edited by one person and has a small handfull of people set as reviewer. The person set as editor can only edit during certain times of day but cannot edit during other times of the day. We tried blocking off a section of time, as an appointment, in outlook and marked it as busy. That will stop items sent as meeting requests but won't stop the editor from opening up the resource calendar directly and placing another appo...

Control contents disappear after postback
I have a VB2008 website with, among others, 3 dropdownlists. Two of these are autopostback and unbound, ddlFuel1a and ddlFormulation1. Whenever I click on any autopostback control, the entire content of both of these controls is deleted. Other than the Imports and Inherits lines, the following is the entirety of my VB code: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then ddlFuel1a.Items.Add("Gasoline") ddlFuel1a.Items.Add("Diesel") ddlFormulation1.It...

2011
I'm looking for a calendar template for 2011 - 2012 for powerpoint 2003 ...

Calendar failure
After running the Inbox Repair tool, my installation of Outlook 2003 went haywire. The most annoying thing that happened is that it changed all of my annual events and all of my recurring events into reminders, which pop up every time I start up Outlook (97 of them!). I dismiss them all and go on with my business, but the program is obviously not as useful for me as it once was. I have a backup PST file that contains all the correct calendar data. It occurs to me that I ought to delete all of the reminders from my current installation and import the calendar data from the backup PST, but I ...

Multiple Calendar default
In Outlook 2003, is there a way to open multiple calendars by default? I have both private and company public calendars on an exchange server. When I click on calendar my private one opens up, then I have to click on my companies public calendar so I can see both at one time. Is there a way to set this as a default? Saving the current view does nothing. Thanks much! imtaller ...

sync calendar with pda
I have a user that directs all his mail to a personal folder on a laptop. The user uses the calendar on server though so the secretary can keep his calendar up to date. When the user syncs the PDA it picks up the calendar in the personal folders not from the server. Is there a way to let him have his cake and eat it too? Larry larry bowerman wrote: > I have a user that directs all his mail to a personal > folder on a laptop. The user uses the calendar on server > though so the secretary can keep his calendar up to date. > > When the user syncs the PDA it picks up t...