1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: acces help

Discussion in 'Business Applications' started by whschimmel, Sep 22, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    I've got an database, in this database there are made some callnumbers

    this number is create like this:

    customer # + Year + Month + number, this results in:

    851000-2008-09-00001 (without the '-')

    I would like to change this number so it wil create sequence per dealer, so when a other dealer is selected, the number re-starts with 00001, like:

    851006-2008-09-00001

    can anybody help with this?

    Tnx,

    Wouter
     

    Attached Files:

  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Wouter, is the current Number entered manually?
    Are we talking about the Form called Form_Melding?
     
  3. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    when selecting a dealer (field 'Dealernaam') in the form: FORM_Melding, the callnumber is entered automaticly
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Wouter, I recognise the Code now, I created it a while back, so you want to carry on Incrementing the Count if the Dealer is the Same, but if it is a New Dealer start back at 00001?
     
  5. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Try this version, I am sorry, I had to delete your Images from the Forms to make it small enough to post on here. I am sure that you can put them back.
     

    Attached Files:

  6. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    HI OBP,

    Wow, thats fast! It's exactly what I needed.

    MANY THANKS!

    Wouter
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/752269

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice