Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Forms (Excel 2002)

    Hi,
    I'm interested in knowing how to use an existing purchase order form (which I can't seem to find... I found the balance sheet & sales invoice) which then stores the data entered into the forms... I've copied the Excel Help section below that says Excel can do this... any help with how to go about using this tool would be awesome.
    Thanks so much!
    Lana


    Ready-made forms for common business tasks Excel provides Spreadsheet Solutions: ready-made templates to help you create expense statements, invoices, and purchase orders. These templates also allow you to store the information entered into the forms in a database.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Excel 2002)

    Sorry, this is too vague to answer. You want help with a form that you don't have? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    BTW, Microsoft has lots of purchase order templates available for download - see here.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Forms (Excel 2002)

    Sorry about the vagueness... what I'm wanting is the purchase order template that allows me to store the information entered into the forms in a database. I found the paragraph below in the Excel Help saying it could do it. Maybe I've misunderstood it's capabilities?? Originally I was just going to create a spreadsheet for others to enter in purchase orders related to capital projects.... then I wanted to create a button with a macro attached to it that would transfer the data they just entered into the purchase order over to a database that would keep track of all the entries made over time. The statement from the Excel Help below kind of sounds like something like what I wanted already exists... I figured "why re-create the wheel"??!! Anyway, I did download a purchase order form last night from the Microsoft website, however I didn't see any options on it that would allow me to STORE the data in a database... this is what I'm truly after... the storage of the data after someone enters a purchase order.


    Ready-made forms for common business tasks Excel provides Spreadsheet Solutions: ready-made templates to help you create expense statements, invoices, and purchase orders. These templates also allow you to store the information entered into the forms in a database.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Excel 2002)

    OK, I hade to search a bit (because I have the Dutch language version) of Excel, but I found the text you quote in the Excel Help. Unfortunately, I don't know of a freely downloadable example that stores the data in a database. It shouldn't be too hard, however, to create it.
    But if you want to use an Access database, why not do it all in Access? It comes with an Order Management wizard that will create a database complete with data entry forms and reports. You can either use it "as is" or use it as a starting point.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Excel 2002)

    I don't believe that any of the MS templates have that capability built in. You have to create the data base and then do the VBA code to store the data from the worksheet into the database.
    Legare Coleman

Posting Permissions

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