Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by delontan

  1. delontan

    Generate Unique ID Combination for new record

    hi chris, thanks for you info...i thought of that using 2 fields (one for the suffix(autonumber) and one for the prefix). but my problem is for every new month, the autonumber field has to reset to 0001 again, u know? and u can't alter autonumber field, right? any more idea how can go about...
  2. delontan

    Generate Unique ID Combination for new record

    no, i am after a way of creating a custom combination for the order id which i mentioned earlier. the format is a prefix with 1st letter of the current month + 2 digits of currrent year + 3rd letter of the current month and the suffix is a 4 digits number that will go from 0001 to 9999. for...
  3. delontan

    Generate Unique ID Combination for new record

    Hi, I am doing a web database using asp page. i am using MS Access to create table. I have problem of dealing with the order id. My order id is a combination of 1st letter of the month, followed by year (2 digits), then 3rd letter of current month, then followed by a suffix of 4 digits (from...
  4. delontan

    Generate Custom ID instead of using AutoNumber

    alrite, i create the module with the IDGen() function and saved it. then i created a form that includes all the table fields. then i open up the form in design view and i enter =IDGen() in the default value in the properties of my Order ID field(text box). It gave me errors on the TEST_ID...
  5. delontan

    Generate Custom ID instead of using AutoNumber

    well, just forget about the frontpage thing. i just need the order field value to be unique and have the data format and auto values that i mentioned earlier. once that value can be automatically generated, then i can manipulate the field values in many different ways. i am going to try to put...
  6. delontan

    Generate Custom ID instead of using AutoNumber

    i am trying to create the order table with the custom id generator as primary key to be used in a website (will use front page to create the query and asp pages). i am new to implement database in a website (that's why i am using frontpage), so, how and where do i put the function? i can't use...
  7. delontan

    Generate Custom ID instead of using AutoNumber

    I need to generate a custom unique value for my primary key field (i.e order id). so far, i had little success by using functions in the default value but i still couln't get the other part to work.(add the other 4 auto numbers.) my primary key Order ID is a combination of 1st letter of the...
See more

Part and Inventory Search

Back
Top