Generate Invoice Numbers in Excel

5 pts.
Tags:
Development
Hi, I would like to generate invoice numbers which i want automated. The invoice format is in excel and i want to insert a text box which would contain the generated invoice number and the text box linked to a table in access with a field calld invoice number.I do not know how to do this and also what code to write to link this text box to excel. If i open a new file it automatically should give me the next invoice number to use. In access table i dont need to store any other detail apart form the invoice number, which would be the primary key. Please am in desperate need of help. Thanks in advance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

It seems to me that since the invoice number is already in Access, that you would, or at least should in my opinion, use Access to generate your invoices. The sample Northwind.mdb has an invoice in it as well as orders etc.
Having developed a number of applications in Access, I think this would be your best solution. I use Excel only for spreadsheet type tasks/analysis. It wasn’t intended to be an invoice generator, so although you might be able to get it to work, I think Access is your best bet.

A few good sites for Access assistance/information tips & tricks are:
http://www.mvps.org/access/ Access forum
http://www.jmhare.com/wildhare2.htm Jim Hare’s access site
http://www.forumco.com/jmhare/ Jim Hare’s access forum
http://www.tek-tips.com/index.cfm Tech forums
http://p2p.wrox.com Tech forums

Hope this helps you out.

Jim
(no relation to Jim Hare though I wish I had some of his knowledge)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kadriguler
    My auto invoice number example. Auto numbering with txt Auto total Price List View here
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following