maheshashish
Registered User.
- Local time
- Today, 07:26
- Joined
- Feb 22, 2017
- Messages
- 20
InvoiceID AutoNumber
CustomerID Number
InvoiceDate Date/Time
InvoicePaid Yes/No
ProposedDueDate Date/Time
NextDueDate Date/Time
BillAmount Number
PaidAmount Number
DiscountAmount Number
BalanceAmount Calculated
Program ShortText
AlertStatus Yes/No
Respected pros
I have this particular table where the invoices are stored, there is an append query which
Creates invoices date every day, but if the customer fails to open the access database then that particular day's invoices will not be generated.
Every day A query called "NewInvoiceQ" will be run.
The invoices will be generated based on next due date; if the "NextDueDate" is equal to today's date then invoice will be generated with the "InovoiceDate" to be today's date and the "NextDueDate" will be calculated based on the Column "Program". (Which is monthly, quarterly, halfyearly, annually. And it will copy the Bill amount )
I want a vb code that sees if NextDueDate is today, if not then the code should see the difference between the maximum date in Column "NextDueDate" and todays date and run "NewInvoiceQ" for all the missed dates.
CustomerID Number
InvoiceDate Date/Time
InvoicePaid Yes/No
ProposedDueDate Date/Time
NextDueDate Date/Time
BillAmount Number
PaidAmount Number
DiscountAmount Number
BalanceAmount Calculated
Program ShortText
AlertStatus Yes/No
Respected pros
I have this particular table where the invoices are stored, there is an append query which
Creates invoices date every day, but if the customer fails to open the access database then that particular day's invoices will not be generated.
Every day A query called "NewInvoiceQ" will be run.
The invoices will be generated based on next due date; if the "NextDueDate" is equal to today's date then invoice will be generated with the "InovoiceDate" to be today's date and the "NextDueDate" will be calculated based on the Column "Program". (Which is monthly, quarterly, halfyearly, annually. And it will copy the Bill amount )
I want a vb code that sees if NextDueDate is today, if not then the code should see the difference between the maximum date in Column "NextDueDate" and todays date and run "NewInvoiceQ" for all the missed dates.