Search results

  1. I

    Create an auto-increment field

    :)Thanks John. I had a primary key field with 'Date' data. I wanted to increment it with each new record. The code worked wonderfully after substituting #My last Record Date# in place of x. Now with each press of new record button, the next date is added. :)
  2. I

    The expression On Mouse Move you entered as the event property setting produced error

    After a lot of back and forth on my database, I had the same error. And what seems like a solution... at least so far it has worked like a charm. I opened the form in Design view and on the On MouseMove property, I selected the code option. In the coding space, I wrote - MsgBox ("All is Well")...
  3. I

    Prevent duplicate entries on an Input Form

    Hi, Though I've been tinkering with Access for long, I've never ventured deep into VBA. So when I had an issue of a Date Picker triggering a duplicate error on my field, I tried using DCount and DLookup codes given here but to no avail. Finally it struck me that the field I was interested in has...
Back
Top Bottom