Results 1 to 9 of 9
  1. #1
    Wingnut74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2020
    Posts
    10

    Creating an invoice from a form

    Hi everyone

    I am having a few difficulties with creating an invoice from a form, When I press the “Create Invoice” button it creates the invoice but sometimes with 2 or more sets of information. When I look back at the table it has in some cases created 2 records for 1 customer. The problem seems to be on the form (or my set up) The form set up is as follows:

    Customer details with a tab control containing information from different tables using sub forms. When I add information to the customer and then to one of the sub forms on the tab it creates 2 records with the same customerID.



    When I try to create an invoice it appears with one header but a details section for each entry on the tab. 2 of the tabs are from the customer table but all others are from different tables. If I only have info in the 2tabs from the customer table the invoice is perfect.

    What I am looking for is to have only one record created when information is entered. My first thought would be to have all the information in one table but that make for one very large table.

    Thanks in advance for any help you can give me.

    Wingnut74

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Can you post a copy of your db with just a few dummy records
    Last edited by Bob Fitz; 04-10-2021 at 07:23 AM. Reason: Typo
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Wingnut74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2020
    Posts
    10
    Hi Bob,

    Thanks for the prompt reply. I have stripped out the DB I've been working on due to the sensitive data but I am now having trouble attaching the file. I have tried to upload several times but cannot find the file in the attachment manager. I will keep trying and hopefully get it to you soon.

    Thanks

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by Wingnut74 View Post
    Hi Bob,

    Thanks for the prompt reply. I have stripped out the DB I've been working on due to the sensitive data but I am now having trouble attaching the file. I have tried to upload several times but cannot find the file in the attachment manager. I will keep trying and hopefully get it to you soon.

    Thanks
    Compact and repair the db, then zip it before posting it.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    "How to Attach Files" is in the top menu, if that helps.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Wingnut74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2020
    Posts
    10
    WDBookingInvoice.zip

    Hi Bob

    File attached, let me know if this doesn't work.

    Many thanks.

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Typically an Invoice follows a Purchase or an Order for a product(s)/service(s). It appears that there may be a missing entity/table in your design. Your design may not handle a customer with more than 1 vehicle. Perhaps if you described the "business" in simple English, in order to compare the database structure against the business processes, it may lead to more focused comments.
    Good luck with your project.

  8. #8
    Wingnut74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2020
    Posts
    10
    Hi Orange,

    Thanks for getting back to me. The business is Alloy wheel panting and repairs so it would be 1 customer with I vehicle and up to 4 wheels. There are also other services they provide like Welding, Wheel Straightening and tyre repairs which are on tblWheels but I would like them to appear on the customer invoice along with the alloy painting when I press the Invoice button.

    Hope that makes sense.

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-09-2019, 09:04 AM
  2. Replies: 2
    Last Post: 09-14-2015, 09:01 AM
  3. Creating invoice input form in 2007
    By mogo3xc in forum Access
    Replies: 2
    Last Post: 04-01-2015, 02:47 PM
  4. Automatically Creating an Invoice
    By Kelsod in forum Access
    Replies: 8
    Last Post: 05-15-2013, 08:03 PM
  5. Help With Creating Invoice Program
    By akshay_401 in forum Access
    Replies: 1
    Last Post: 09-04-2012, 05:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums