User Profile

Collapse

Profile Sidebar

Collapse
HAMIZ
HAMIZ
Last Activity: Jul 20 '10, 05:08 PM
Joined: Jun 2 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • HAMIZ
    replied to Create Specific Unique Serial Number
    in Access
    Yes, It is in Standard Code Module.
    it works fine in "LOCALS" VB window and gives correct result.

    Along with my last statement, It also gives error for strLastSerialNo stating "Run Time error '94' Invalid use of NULL" if there is no any record in the said table, i.e. we have write 1st value in [SerialNo] manually.
    See more | Go to post

      Leave a comment:

    • HAMIZ
      replied to Create Specific Unique Serial Number
      in Access
      unknown function

      Dear ADezii,
      When I enter =fGenerateNextS erialNumber(), in default value field property of tblTest.SerialN o and save, I receive notification stating "unknown function '=fGenerateNext SerialNumber()' ". Further more I have added the code in class module of VB window. Can you please help on this issue?
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...