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.
April 6, 2005 8:09 AM
January 3, 2012 5:10 PM