User Profile

Collapse

Profile Sidebar

Collapse
firefighter17103
firefighter17103
Last Activity: Oct 26 '08, 03:45 AM
Joined: Oct 22 '08
Location: Rockland Co, NY
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • firefighter17103
    replied to Help Creating an Order Form/Invoice
    in Access
    I don't fully understand how to set up the AFTER UPDATE event and how to do a DLOOKUP. Can you please explain a little more.

    As far as the tax rate you want me to create another field on my "Orders" table, correct??

    Once again thank you.

    Joe
    See more | Go to post

      Leave a comment:

    • firefighter17103
      replied to Help Creating an Order Form/Invoice
      in Access
      OK... I have created the "Orders" table w/ the following fields
      OrderID(PK)
      OrderDate
      CustomerID(FK)
      Salesman(FK)
      ProjectedInstal l

      Sales Tax is 8.375% for services and goods.

      For the "OrderDetai ls" table how do I get it to pull up the info such as product price and descript??

      I want to thank you again for your help.

      Cheers
      Jo...
      See more | Go to post

        Leave a comment:

      • firefighter17103
        replied to Help...Best way to create a sales and invoice database
        in Access
        Please Close this topic I have reposted with a clearer description of what I would like help with....
        See more | Go to post

          Leave a comment:

        • firefighter17103
          started a topic Help Creating an Order Form/Invoice
          in Access

          Help Creating an Order Form/Invoice

          Hi All,

          I am new to MS Access 07, & do not know any VB, on a new business adventure. I am running Office07 on Vista Home Premium.

          I am in the process of creating a database that in the end I will be able to create quotes, bill out customers for security services, cctv products and installs,create purchase orders to my distributors being that I keep no inventory on hand, and track payments such as deposits on equipment....
          See more | Go to post
          • firefighter17103
            replied to Help...Best way to create a sales and invoice database
            in Access
            NeoPa,

            I have a couple of obsticales that are preventing me from doing that...One is that the databases I have seen won't allow me to include specific details. Another is a money issue..as of right now all incomming money is going to insurance, equipment and such. I am pretty good at figuring stuff out. I am just looking for some guidence/help.

            Thanks,
            Joe
            See more | Go to post

              Leave a comment:

            • firefighter17103
              started a topic Help...Best way to create a sales and invoice database
              in Access

              Help...Best way to create a sales and invoice database

              Hi All,

              I am new to MS Access 07, & do not know any VB, on a new business adventure. I am running Office07 on Vista Home Premium.

              Basically what I would like to do is create a database that I can create quotes, bill out customers for security services and cctv products and installs as well as create purchase orders to my distributors being that I keep no inventory on hand. Also I would like to track payments such...
              See more | Go to post
              Last edited by firefighter17103; Oct 22 '08, 01:11 PM. Reason: Add computer info
              No activity results to display
              Show More
              Working...