Hi
I need some serious help!!
I am a beginner with very little knowledge of access
I am looking to get a database to tell me who has not payed their bill, they have 30 days to pay it. if possible this could be a pop up alert telling me who hasnt paid. Then I need to send a email to that Id(client) asking them to settle the outstanding bill.
Thanks claire
6  1179  Rabbit 12,516
Recognized Expert Moderator MVP
How much experience do you have using the visual basic editor?
How much experience do you have using the visual basic editor?
Not much i used it for a project in second yr of university
Rabbit 12,516
Recognized Expert Moderator MVP
Are you able to design a query that returns records for those that are overdue?
Are you able to design a query that returns records for those that are overdue?
Yes i can do that, although i haven't created it yet. Is it possible to run the query from the database on a webpage? If so do you know what code i should use if it is written in ASP?
Rabbit 12,516
Recognized Expert Moderator MVP
Sorry, I don't know ASP, could transfer you to that forum if you want.
But in VBA I would do something along the lines of:
1) Set a recordset equal to that query.
2) If said recordset has a record count larger than 0 then pop up a message saying there are overdue records.
Sorry, I don't know ASP, could transfer you to that forum if you want.
But in VBA I would do something along the lines of:
1) Set a recordset equal to that query.
2) If said recordset has a record count larger than 0 then pop up a message saying there are overdue records.
Thank you so much i would be very grateful if u could send me to the other forum
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Judi Keplar |
last post by:
I am currently taking a course to learn Python and was looking for
some help. I need to write a Python statement to print a comma-
separated repetition of the word, "Spam", written 511 times ("Spam,
Spam, … Spam").
Can anybody help me get started? I am completely new to programming!
Thanks in advance!
|
by: *** HAWK |
last post by:
I'm trying to make a music CD webpage (eg hmv.com) using ASP. I want it to
follow these guidelines:
All visitors should be able to obtain a list of
1 - all CDs in the database listed by A-Z by arist name
2 - CD's which price is within a range (minimum & maximum) specified by the
user
3 - titles of the tracks on a CD
4 - CD's which include both CD & track titles contains keywords inputted
into a 'search box'
5 - Also an option that...
|
by: PhilB |
last post by:
Hello experts,
I am a complete beginner in C++ (although I know C).
I am trying to compile the code below, and I get
the following error.
Can anyone explain to me my mistake?
Thanks!
PhilB
myprog2.cpp: In method `Line::Line (Point, Point)':
myprog2.cpp:32: no matching function for call to `Point::Point ()'
|
by: BobJohnson |
last post by:
Just started learning C++ and I need some help with my homework, shouldn't
take long for people around here. I need to create a simple money
calculator but I don't know how to make the output numbers two decimal
places long like 10.01 I only know how to define numbers as int or double.
Do I use float?
Also, I'm using Visual Studio .NET is there anyway to keep the compiler on
the screen long enough to actually see what it's outputting. ...
|
by: ranger |
last post by:
Hi,
I'm a beginner with C++, studying on my own from a book and I've
encoutered quite some problems.. If possible, someone out there might
help me out..
The problem is the following.. I've tried to create a couple of string
class/functions.. and they do compile.. but when I run them.. windows
suddenly reports an error.. As I'm just a beginner in C++, with noone
around me to help.. I'd appreciate if someone might help me out!
| | |
by: Bshealey786 |
last post by:
Okay im doing my final project for my first computer science class(its
my major, so it will be my first of many), but anyway im a beginner so
im not to great with C++ yet. Anyway this is the error msg that im
getting: "Error executing cl.exe"
this is the code that I have, but I know whats causing it, ill just
show you the whole thing first though
//file: Quadratic
|
by: imranzafar |
last post by:
hi! i am beginner c++ programmer. Here is my code. I can delete any
entered record but if i want to delete first and last node of the list
it goes into indefinite loop, although the compilation is successfull.
Can anybody suggest any clue what and where it went wrong?
#include <stdio.h>
#include <alloc.h>
#include <ctype.h>
#include <conio.h>
|
by: Rodney Garland |
last post by:
Hi All,
I am a relative beginner to Python and am looking for help with sending and
XML message and getting back a return file. The server is:
https://node.deq.state.or.us/node/node.asmx
I have have successfully sent and recieved using the PING, AUTHENTICATE
(send in username and password and return a secuirity token), SOLICIT(send
in information for a query and get a number indicating the query),
|
by: mia23 |
last post by:
Hello, I am a java beginner and I need series help in solving this program; my assignment is due after 2 days and I can't understand this program .
This is THE PROGRAM:
The ABC medical clinic needs your help in building a Java application that can help in keeping track of patients, appointments, and clinic activities.
Create a class Patient from which we can create objects to handle information about different patients. Each patient is...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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: 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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
