Results 1 to 5 of 5

Thread: A few problems

  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: A few problems

    Hi,

    I think this should be pretty simple, but I don't use access that much. I uploaded a screen shot of the form that I'm having some problems with. First, I need to set up the transfer ID so that when a new form is entered, it will create a transfer ID that is 1 higher than the highest one in the system. Second, the part_ID in the sub-form needs to automatically pull up the corresponding part description and "in units of." Last, I need to have the form set up so that the transfer status can never go down a number once a status has been selected. (Like if closed is selected, which is the highest numeric value option, no other options can be selected).

    Thanks in advance.
    Attached Thumbnails Attached Thumbnails untitled.JPG  

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make Transfer ID an AutoNumber, and the incrementing will happen for you automatically.

    If your tables are related correctly, just including both tables in the form's SQL will result in the automatic description and units fields. Perhaps your table structure is not quite right.

    You'll probably need a very small piece of VBA to prevent users from selecting lower valued status entries.
    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
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    before choosing an autonumber column make sure you understand what the true purpose and meaning of an autonumber column is. its a method of generation a unique number. if your transfer ID has to be contiguous to satisfy some anal accountants then autonumber isn't going to cut it, or at least not without some serious design considerations.

    there is some stuff in the code bank on autonumbers
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    May 2009
    Posts
    2
    The autonumber is actually what I was looking for. It's a prototype, so it doesn't have to be an ideal system. I'm still having a little bit of trouble with the other two. Not sure what I'm doing wrong. Would anyone be willing to take a look at it?

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I don't know if anyone would be willing to just fix it for you for nothing, perhaps someone might, but it would be far better for you to learn how to do it yourself.

    What is your table structure?
    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

Posting Permissions

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