Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2009
    Posts
    9

    Exclamation Unanswered: Access Stock Problem

    Here goes, tell me if you go cross eyed.

    I have a database, a HUGE database.

    That lets the user, Order and sort a delivery of that item, calculates costing etc.

    Now the items 'Ordered' are stand alone and require no stock managment, but the 'Additions' do.

    1 single item can have up to 9 additions that dont come as standard.

    Eg: Door

    Glass
    Lock1 - ALL FROM SAME STOCK LIST
    Lock2 - " "
    Lock3 - " "
    Frame
    Handle
    Key
    Closer
    Doorstop

    My problem is this:

    All 9 additions show on the single form, at Order Stage.
    A person may order as many or as little as they like in any combination.
    This leaves me with a rather "loopy"( ) look on my face when my assignment says "Now add stock controlling"

    So I need to manage stock for 9 items(or is it 7?)

    Im pretty well rounded when it comes to access, done my fair share of databases. But this just beats me ..

    (PS: Northwind database REALLY aint of use.)

    Any ideas/views accepted.

    Thanks for you're time

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Asked your lecturer?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2009
    Posts
    9
    Well I did .. I dont think he knows either ..

    He gave me a 25min speech about some rubbish that has no connection to my assignment.

    I hate it when he avoids things -.-

  4. #4
    Join Date
    Jan 2009
    Posts
    9

    Smile

    Moved to own thread.
    Last edited by Irprogram; 01-28-09 at 06:20.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well if you can't be bothered, why should anyone else?


    ...be bothered that is
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jan 2009
    Posts
    9
    Believe it or not, im trying lol

    My first question, I have no idea where to start, tried books, Microsoft website.
    (Tried thinking about Dlookup and the "Northwind" way. Nout to say really.)

    The second, I got the code from a class mate, it works fine in his, but for some odd reason wont work in mine. Ive copied his code with the exception of form names etc.
    (I can either get a printout of first record only, or runtime error)

    Im not asking anyone to do it for me, I just need to learn how to do/fix these issues.
    If you dont have the methods, time to look at it, pass it up. Ive got 2 weeks left to look at it(of 6 weeks).

    EDIT: Spelling
    Last edited by Irprogram; 01-28-09 at 05:44.

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by Irprogram
    (and sorry about 2 problems 1 post, but having many active threads is a pain.)
    don't confuse can't with wont
    if you cant be bothered to follow forum etiquette, which incidentally is more designed to help the person with the problem (as many contributors look at the fron tpage and decide whetehr or not to look at the problem if there are few responses. thread hijacking, even hijacking your own thread is self defeating, especially if the original problem is unresloved.

    so I repeat the comment, if you cannot be bothered then why should anyone else be bothered with your laziness
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Jan 2009
    Posts
    9
    I was always under the impression many active threads by 1 person was "bad"

    fixing..

    I only did it to avoid self confusion, I dont do well with many tasks.

    Anyways, back to top.

    should I use multiple sub forms ?

Posting Permissions

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