Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2013
    Posts
    3

    Unanswered: Help on creating an invoice

    Hi all my first post so i am trying to make it as detailed as possible
    ok so I have 5 tables these are

    tblCustomer
    (PK)CustomerID
    FirstName
    LastName
    Address
    PostCode
    ContactTelephone

    tblEmployee
    (PK)EmployeeID
    Initals
    FirstName
    LastName
    Address
    PostCode
    ContactTelephone
    Email

    tblVehicle
    (PK)VehicleID
    Make
    Model
    VehicleReg
    EngineSize
    NoDoors
    Style
    Transmission
    Fuel
    Colour
    Milage
    ServiceHistory
    Notes
    AskingPrice
    PurchaseDate
    SaleDate
    PurchasePrice
    SalePrice
    Sold
    SalesPerson (Linked to tblEmployee - Initials)

    tblInvoice
    (PK)InvoiceNumber
    InvoiceDate
    CustomerID (Linked to tblCutomer - (PK)CustomerID)
    EmployeeID (Linked to tblEmployee - (PK)EmployeeID)

    tblInvoiceDetails
    (PK)DetailsUniqueKey
    InvoiceNumber (Linked to tblInvoice - (PK)InvoiceNumber)
    VehicleID (Linked to tblVehicle - (PK)VehicleID)

    I want to people to go to the a form select the customer ID and Vehicle ID and the Employee Initials and then click on a button that will produce a invoice into Word which will show the Cutomer Name and Address then the Invoice Number (which I would like to be automatic in the table it is set as 'AutoNumber' anyway) then I would like it to show the Vehicle Make Model Vehicle Reg and then the Sale Date and Sale Price.

    Any help would be appreciated

    If this is too complicated to explain could you show me any manuals or help videos that could help

    Much appreciated

    Rob

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Why do you want the invoice as a Word document? What's wrong with Access Reports?
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Jan 2013
    Posts
    3
    It doesn't have to be word an acces report or pdf or word would be okay whichever whould be easier

    Maybe at a later date I would try to do it in word for a challenge

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    In that case, you can design a query to pick up all the information that you need from the relevant tables. Base a report on that query, and call the query from a command button on the form mentioned above. Assuming that the query includes the relevant fields, you can pass the data from the combo boxes to the report as openargs, and that will open the selected invoice.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  5. #5
    Join Date
    Jan 2013
    Posts
    3
    Hi sorry i kind of understand what you mean,

    So I guess i create a query and call it say "qryInvoice" and then the info in that would be

    InvoiceNumber
    InvoiceDate
    CustomerID
    CustomerName
    CustomerAddress
    EmployeeID
    EmployeeName

    then I get lost when create the form on the combo box what table should all the details come from the original tables or tblInvoice and tblInvoiceDetails

    sorry to be a pain but i am not as experienced as most

    Rob

  6. #6
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    The row source for the combo boxes should be the tables, but they ought to be bound to the query.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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