I don't know if this is possible or not. A non-profit client is running a
fund raising campaign where a person can make a pledge that can cover from 1
to 5 years and can be paid in monthly, quarterly or annual installments.
Most of the database work is pretty standard except for one part. The client
would like to send out notices to each donor when the next payment is due.
With each donor having from 1 to 20 payments, and 1 to 12 payments per year,
and a start date that can be any date, there are a lot of variables to
factor in on the fly. Any ideas out there?
Thanks in advance. 1 1390
Each payment should be a separate row in a table. Query that table to select
all payments due in the next n days.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"news.bellatlan tic.net" <ma************ *@verizon.net> wrote in message
news:pK******** ***********@nwr dny01.gnilink.n et... I don't know if this is possible or not. A non-profit client is running a fund raising campaign where a person can make a pledge that can cover from
1 to 5 years and can be paid in monthly, quarterly or annual installments. Most of the database work is pretty standard except for one part. The
client would like to send out notices to each donor when the next payment is due. With each donor having from 1 to 20 payments, and 1 to 12 payments per
year, and a start date that can be any date, there are a lot of variables to factor in on the fly. Any ideas out there?
Thanks in advance.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: spe.stani.be |
last post by:
SPE (Stani's Python Editor) is an open-source python IDE with auto
indentation & completion, call tips, syntax coloring & highlighting,
UML diagrams, class explorer, source index, auto todo list, sticky
notes, pycrust shell, file browsers, drag&drop, context help, Blender
support, ... Spe ships with Python debugger (remote & encrypted),
wxGlade (gui designer), PyChecker (source code doctor) and Kiki (regex
console).
To support the...
|
by: Rajesh.V |
last post by:
I have made a custom control in asp.net using webcontrols, and am raising my
event. I find that if no control is hooked into the event it goes for a
toss. I tried to find length of the delegate array returned by
ButtonClicked.GetInvocationList method
event that is raising an exception. Presently i am enclosing in try catch
block and would like to avoid that. Any suggestions on how to find if any
body is hooked/listening to this event.
|
by: Dan |
last post by:
I've created a pocketpc app which has a startup form containing a listview.
The form creates an object which in turn creates a System.Threading.Timer.
It keeps track of the Timer state using a TimerState object similar to the
example in the System.Threading.Timer documentation. The method which
handles the timer events, among other things, periodically calls a method in
this TimerState object which raises an event to the startup form,...
|
by: Greg Park |
last post by:
I have many user controls loading into a web page using
Page.LoadControl
However, I'm unable to figure out how to raise an event
when a button is click or a check box is checked. I can
have upto a hundred user controls on a single page and
AutoPostBack isn't an option.
I have no problem with raising events when an user control
is dropped on the aspx page.
|
by: Joe Campbell |
last post by:
I am encountering a problem raising WMI events from an
asp.net application. The error received (as captured in
the event log) is as follows:
System.Runtime.InteropServices.COMException (0x80041003):
Exception from HRESULT: 0x80041003.
at
Microsoft.EnterpriseInstrumentation.EventSinks.WmiEventSink
..Write(Object eventToRaise)
at
| |
by: Dave A |
last post by:
I am developing a somewhat complex component at the moment and coincidently
I am also reading the Framework Design Guidelines book.
After reading the section about event raising I have re-written the way my
component raises events to follow the Framework Design Guides verbatim; ie
(object sender, EventArgs (or some subclass there of) e).
The thing that was not explained is why should I need to cast the sender to
'object' when I know...
|
by: Gman |
last post by:
Hi,
I have created a usercontrol, a grid control essentially. Within it I
have a class: clsGridRecord. I have coded the events such that when a
user clicks on the grid, say, the events occur on the parent form. This
is fine.
The problem occurs when I want to raise an event for a user clicking on
one of the clsRecords which are on the grid. So I've placed:
Public Event GridRecordClicked(ByVal rec As clsGridRecord,
|
by: sloan |
last post by:
I"m trying to figure out what concept I'm missing here, or if its not a good
idea .. or what.
Here is my example.. code is below.
I have an employee class.
It has an event that can be raised.
In the constructor, I check the to see if the employees birthday is today.
If it is today, then I raise an event.
|
by: Christoph Zwerschke |
last post by:
What is the best way to re-raise any exception with a message
supplemented with additional information (e.g. line number in a
template)? Let's say for simplicity I just want to add "sorry" to every
exception message. My naive solution was this:
try:
...
except Exception, e:
raise e.__class__, str(e) + ", sorry!"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |