Auto increment dmax

[adnmhz]

Hi, I have an access database. I have 56 customers for which i have a table and a form. I want to create auto invoice number for each customer whenever user add new invoice. I tried DMax auto increment but all in vain. Please help me immediately as I want auto increment for each customer by giving him a specific text also for example for customer Daniel I want D-01, and in next new invoice i want D-02........... My database information is .......table name in invoicetble.......field name is "invoice" and form name is Invoice_Form.

 

[plog]

First, why? What's so special about these invoices numbers? Do they need to fulfill a purpose other than being unique?

Second, check the 'Similar Threads' section at the bottom of this page. This has been asked, had their purpose questioned and ultimately answered many times on this forum.

Third, if those links don't help, explain in more detail what you are specifically attempting to accomplish this. Post code and where you put that code.

 

[MarkK]

Please stop posting this question in multiple sections of the forum. There is a thread on this issue here https://www.access-programmers.co.uk/forums/showthread.php?t=301190. There is no need to start another thread on this. I have also delete a third thread you posted on this same topic.

When posting on this site you are responsible for conforming to standards set out here: https://www.access-programmers.co.uk/forums/faq.php?faq=vb3_board_faq#faq_vb3_board_usage

Please abide by those. Please ask one question only once.

Thanks in advance,
Mark