473,320 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Running a query using ASP

20
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
Apr 25 '07 #1
9 1492
Rabbit
12,516 Expert Mod 8TB
How much experience do you have using the visual basic editor?
Apr 25 '07 #2
harky
20
How much experience do you have using the visual basic editor?
Not much i used it for a project in second yr of university
Apr 25 '07 #3
Rabbit
12,516 Expert Mod 8TB
Are you able to design a query that returns records for those that are overdue?
Apr 25 '07 #4
harky
20
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?
Apr 25 '07 #5
Rabbit
12,516 Expert Mod 8TB
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.
Apr 25 '07 #6
harky
20
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
Apr 25 '07 #7
Rabbit
12,516 Expert Mod 8TB
I copied your thread over there in case someone here happens to know how to do it. Be sure to keep an eye on both, they're seperate threads.

If you don't get a response in 24 hours, bump this thread and I'll send a message to the moderators.
Apr 25 '07 #8
harky
20
I copied your thread over there in case someone here happens to know how to do it. Be sure to keep an eye on both, they're seperate threads.

If you don't get a response in 24 hours, bump this thread and I'll send a message to the moderators.
grately appreciate it thanks so much
Apr 25 '07 #9
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
Hi there
Have you had any progress yet? If not I can help if you can explain in details what you want to do, if you want to do it in ASP using Access etc. I will help!

Regards
Jim
May 2 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Paul Mateer | last post by:
Hi, I have been running some queries against a table in a my database and have noted an odd (at least it seems odd to me) performance issue. The table has approximately 5 million rows and...
4
by: Gary | last post by:
I am having a problem executing long running queries from an ASP application which connects to SQL Server 2000. Basically, I have batches of queries that are run using ADO in a loop written in...
5
by: PeteCresswell | last post by:
Access tends to take over my machine when I run long queries. The queries in question are Append queries. Some of the jobs we're talking about run 45 minutes to an hour...so the loss in...
2
by: Gershon | last post by:
I have an ASP.NET/C# web application running against a SQL Server database using ADO.NET. Whenever there is a long-running database query, the web application hangs until the database query is...
6
by: johntarr | last post by:
I hope I am not asking about something that has been done before, but I have searched and cannot find an answer. What I am trying to do is to run a query, and then perform some logic on the...
1
by: Aaron West | last post by:
Try this script to see what queries are taking over a second. To get some real output, you need a long-running query. Here's one (estimated to take over an hour): PRINT GETDATE() select...
7
by: (PeteCresswell) | last post by:
Can anybody point me to an example of creating a running sum via SQL. The situation is the application shows a history of bond trades - both as parent transaction and as allocated among funds. ...
5
by: mebrabham | last post by:
Hello, I am trying to create a running subtotal in a query and then graph the running subtotal for each city group. The data looks like this in the table (for illustration): My City My...
9
by: JJM0926 | last post by:
I'm trying to create a running totals query in access 97. I have followed the directions on how to do it from Microsofts website article id 138911. I took their code they had and replaced it with...
7
by: Lewe22 | last post by:
I have a query pulling information from multiple tables, one of which contains a list of students with an auto number their assessment information and how long the assessment took in minutes . ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.