Macro for sequential invoice numbering

J

James Menk

How do I create a macro within an invoice so each time I open the invoice template the macro automatically advances to the next sequential number?
 
S

Steve Schapel

James,

This is not a job for a macro. If your invoice "template" is a single
view form, you can set the Default Value property of the InvoiceNumber
textbox to the equivalent of...
DMax("[InvoiceNumber]","Invoices")+1
(obviously substitute the names of your own actual table and field
names).

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Invoice template for client... excel, access or accounting software... 1
Mailmerge - page breaking to new customer 1
saveas macro help 1
Need Help with Macro Security 1
open invoice and have a sequential number assigned automatically 6
Look Up Formula With Veried Search Range 2
Button to duplicate current forms (for an invoice) 1

Top