Search results

  1. S

    Assign the next number to a field not using autonumber

    Thanks! I think that will work.
  2. S

    Assign the next number to a field not using autonumber

    Tried both to no avail. the record source is ECRNumIndex. Should it be something else?
  3. S

    Assign the next number to a field not using autonumber

    I am still missing something. I have placed the followng function in the "on current" event of the form and it is not assigning a number. =Nz(DMax("ECRnum","ECRNumIndex"),0)+1 The filed name is ECRnum and the table name is ECRNumIndex" Am I missing something? Thanks, Randy
  4. S

    Assign the next number to a field not using autonumber

    This looks like it may work. I am new to this and am also looking at where I enter the function. Is it in the form for the associated field? Is it in a query? Also does the field and table have to be in brackets[]?
  5. S

    Assign the next number to a field not using autonumber

    Auto number will not work for what I want to do. I am creating a simple database that will assign the user with the next incremental number in a field. The intent of the database is for the user to enter three text fields and then obtain the number. I believe that Dmax would work but do not know...
  6. S

    Hello from Maryland

    I am new to Microsoft Access and am here to find some answers. I hope I may find it here. Thanks, Randy
Back
Top Bottom