Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Forms/AutoNumbers

    On my invoice form I have a field called InvoiceNo which is an auto number.

    The user wants to be able at times to - instead of re-typing the entire invoice, query an existing invoice, make changes, save it and give it a new invoice number. Is that possible? If so, how?

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    Because it is an autonumber it cannot be changed. I would suggest that you create a new record and copy the information from the old invoice to the new invoice.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Feb 2002
    Posts
    403
    The user wants to be able at times to - instead of re-typing the entire invoice, query an existing invoice, make changes, save it and give it a new invoice number. Is that possible? If so, how?
    Accounting DB is not my thing but I don't think this is quite legal the way you have described it.

    Having said that you could build a search button to find the previous invoice and then transfer the fields across as default values to a new record. Except the date, the autonumber and perhaps the client.

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    or just bring up the record click addnew and use the ctrl apostrophe to duplicate any fields that will not be changed - then edit the rest.

    what can I say - I feel lazy today


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •