Search results

  1. B

    Solved Simple Query to divide two fields

    Perhaps something like: FormatNumber(1/70,4)
  2. B

    SELECT Query with AND in criteria

    The query will return no records with your criteria because no record have P1 AND P2. Perhaps you need to use OR instead of AND
  3. B

    hello

    Welcome to the forum :)
  4. B

    Checking Data

    I agree entirely with you missingling, which is why I advised the use of the form's BeforeUpdate event in post #5 and #8
  5. B

    Bonjour

    Bienvenue sur le forum Djeli
  6. B

    Checking Data

    First of all, please accept my sincere apologies for not replying sooner as I had promised. I'm not sure what you mean exactly by "it is not working", so I am guessing that after selecting "Yes" in the message box the focus returns to the "AMOUNTs" control but the original figure is not...
  7. B

    Checking Data

    So why not use the FORMs Before Update event. I am not at a computer today but will look at your db tomorrow.
  8. B

    A Ukulele For A Gent

    Approximately, how many hours work would you expect to be needed to make a guitar?
  9. B

    Checking Data

    It does work in the controls Before Update event but you need to remove the "setfocus" line as that is not needed and will throw an error. I think you had the code in the controls AfterUpdate event.
  10. B

    Checking Data

    I suspect that it "is not working properly" because you have not put the code in the FORMs BeforeUpdate event as I suggested in my earlier post. Try the attached db:
  11. B

    Checking Data

    I don't think that it will work on an existing record if user deletes the amount. Best to test for Null as well as 0, just in case.
  12. B

    Let's thank the Mods!

    Totally agree with thanking the Mods Doc, but which one is a "gal" ?
  13. B

    Checking Data

    Use the following code in the forms BeForeUpDate event: If (IsNull(Me.AMOUNTs) Or (Me.AMOUNTs = 0)) Then If MsgBox("Did you miss AMOUNT?", vbDefaultButton1 + vbYesNo + vbQuestion) = vbYes Then Me.AMOUNTs.SetFocus Cancel = True End If End If
  14. B

    Solved Code to check if field on form is Null

    Put your validation code in the forms Before Update event. If it fails you can cancel the event so the form stays open.
  15. B

    Clear contents of texbox in Subform from Main form

    You say that the button "opens" a subform but subforms are usually hidden or made visible. If you are actually opening another form then the code required would be something like: Forms!NameOfForm.textboxName = Null Forms!NameOfForm.Requery
  16. B

    Hello Everyone!

    Welcome to the forum :) May I ask what part of the world is "starting to be spring" now?
  17. B

    Regex

    Cross-posted: https://www.accessforums.net/showthread.php?t=79772 Please read: https://www.excelguru.ca/content.php?184
  18. B

    Hello

    Hi Terry Welcome to the forum :)
  19. B

    Announcing the New Super-troll Quarantine User Group

    Well, I for one, have had enough of it. At least for the time being 😱
  20. B

    Announcing the New Super-troll Quarantine User Group

    Indeed. Let's hope that that it isn't too sour for some nor too sickly sweet for others.
Top Bottom