Search results

  1. M

    Duplicate current record & Increment a non Primary ID column to CurrMax+1 value

    Hi I would like to know if we have a simple method to duplicate the current record in a form and Increment a ID value to Current Maximum Value + 1 , and to clear few boxes so that user can enter new data in this form. I used Duplicate button but it copies entire data and I am unable to get a...
  2. M

    CLearing Few boxes after duplicate

    Hi I have kept a duplicate button to duplicate the current record but I would like to know how we can make 1) few fields empty and 2) Increment a particular NID field to the next highest number present in the database. ( This particular ID field contains duplicate values too, so Autonumber is...
  3. M

    Like in Dlookup

    Hi Could you tell me how we can achieve the below req: SV="Russia" DeptId = DLookup("city","Lok","country like 'SV'") Thanks.
  4. M

    Basic: Executing simple sql query to extract a value in vba

    Hi I am trying to execute a sql to fetch a value which will be source to a text box. Could you help me on how to write and execute sql's in vba?? tnx in advance. I tried below but it is giving 3163: the field is too small to accept the value.......... Dim SS As String DoCmd.SS = "SELECT...
Back
Top Bottom