Recent content by likecricketilovesit

  1. L

    Solved Lock file errors on FE. Multiple access tasks in task manager.

    Hi there, over the last week or so we have an issue with our DB (which is split FE local / BE server in the correct way). If you open the FE then the first time it opens ok. When you close access the lock file is still there and multiple access tasks are visible in task manager (see image)...
  2. L

    Calculated field (control) on (sub)Form

    Thanks Majp. I renamed all the table fields which seemed to fix it :)
  3. L

    Calculated field (control) on (sub)Form

    Hi there, I'm hoping you wonderful people can help me?! I've tinkered with this very simple calculated control (Volumetric) on a form but for the life of me cannot get it to calculate correctly. =([Length]*[Width]*[Height])/5000 Based on this (36*27*14)/5000 it should be 2.7216 but its...
  4. L

    Form Msgbox if field B is not null

    Hi Paul, many thanks for your suggestion. Worked a treat! Thanks for your help Simon
  5. L

    Form Msgbox if field B is not null

    Hello, I wonder if you can help me! I am trying to remind user via msgbox of subform to enter data in revision field if revA field is not empty. I have tried this out on the subform before update, however msgbox doesn't seem to appear! Private Sub Form_BeforeUpdate() If Not...
Back
Top Bottom