Search results

  1. B

    update query and autonumber

    Hello access friends, the following update query UPDATE Screen SET Screen.ScreenID = [CarModel] & "-" & Left$([Category],1) & Format(100,"000"); gives me duplicate values. How to avoid this and increment the next number? I have attached the database to show what I wanted to achieve in the form...
  2. B

    DMax() for sequential autonumber

    DMax() and Module for sequential autonumber Hello Access friends, Trying to have a sequential autonumber for the ScreenID with the DMax () function. Please advise on what is wrong with the following : =Nz(DMax("[ScreenID]","[Screenprep]","[ScreenID] = '" & [CarModel] & "-" & Left$([Category],1)...
    • banza
    • Thread
    • Replies: 1
    • Forum: Forms
  3. B

    afterupdate problem

    Hello Access friends, I have an unbound date field named txtDate with the following afterUpdate event. When I manually write the date the AfterUpdate works fine but does not work (the lblStock field doesn't get the value in the txtDate field) when I populate the txtDate field from a pop up...
  4. B

    Runtime error 3061 Too few parameters

    Hello Access friends, What is wrong with the following code (modified the module from http://members.iinet.net.au/~allenbrowne/AppInventory.html ): I Keep getting a runtime error 3061 Too few parameters . Expected 1 on the line highlight below. I have the reference MS DAO 3.6 selected and I am...
Back
Top Bottom