473,320 Members | 1,936 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.

Updating Invoice dates

My small database has now developed and is used to send out invoices
and invoice reminders. I have an "invoice sent" field in the table,
select records where this is "null" to identify the correct records
and generate invoices, then run an Update Query to insert todays date
in the table. (I'm using a similar process for reminders)
I am a novice, and this seems a rather chunky way of doing things. Has
anyone got a slicker/quicker way??
Nov 12 '05 #1
1 1163
What triggers the generation and sending? Could you not include the current
date in that process? Obviously, you'll have to come back and update the
reminder date/indicator when the reminders are sent.

As we can't be sure _how_ you are going about all this, it's difficult to be
specific. If it were my application, I'd likely have a form to trigger
sending reminders and run a query from code when I sent them.

Larry Linson
Microsoft Access MVP

"Dumbo Liz" <du**********@yahoo.co.uk> wrote in message
news:17**************************@posting.google.c om...
My small database has now developed and is used to send out invoices
and invoice reminders. I have an "invoice sent" field in the table,
select records where this is "null" to identify the correct records
and generate invoices, then run an Update Query to insert todays date
in the table. (I'm using a similar process for reminders)
I am a novice, and this seems a rather chunky way of doing things. Has
anyone got a slicker/quicker way??

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: David B | last post by:
An app I am working on produces invoices between two dates, either for a selected customer or all, with transactions in the date range. I need to record that an invoice has been produced and,...
3
by: David B | last post by:
I am creating invoices for an app I am busy with. The transactions for the invoice come from 2 tables which store Sales and Facilities Hire. The current arrangement is that I create a temp...
5
by: J. Yuan | last post by:
Hi, I am working on a checkout/inventory system. How can I make a button that when pressed, would update the previous fields transaction number to a table (for example, -3 printers, so that...
6
by: Marlene | last post by:
Hi All I have the following scenario, where I have found all the duplicates in a table, based on an order number and a part number (item).I might have something like this: Order PODate Rec...
8
by: jamesnkk | last post by:
I got this Run-time error 3251 Current Recrdset does not support updating. This may be limation of the provider, or of the selected locktype. Dim red1 As New ADODB.Recordset Dim strmess As...
17
by: NCRStinks | last post by:
Hi Every1 I have only just started working on databases very recently - and I am not at the technical stage yet either. I am creating a database to integrate into sage line 50. This bit is...
10
by: NCRStinks | last post by:
Hi everyone, I know its not standard practice to attach a sum to a table, but with the data I am working with I cant really work around it. I am creating an invoicing database that will export...
2
by: jfrench1941 | last post by:
I am somewhat new to Access but I kow Sql server. I have an Access table linked to a Sql server table. I want to update on certain fields in the sql table. I have created a query : with the...
2
tdw
by: tdw | last post by:
Hi all, I have several ideas on how to do this, but am having difficulty putting the ideas together and figuring out the most efficient way to do this. I have a database of survey coordinate...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.