Recent content by cheekybuddha

  1. cheekybuddha

    Bad Data is Bad for Business

    Here's some quick and dirty code you can run from your form's Load event that will add your LogEvent to all the event handlers. It requires that LogEvent is a function and not a sub, and also changing the signature so that you pass the form name rather than the form object itself. I haven't...
  2. cheekybuddha

    Problem with SQL server back-end.

    Missed that! More coffee required! :LOL: :coffee:
  3. cheekybuddha

    Problem with SQL server back-end.

    Similar question asked here on UA. Maybe it can shed some light?
  4. cheekybuddha

    Problem with SQL server back-end.

    I think ::1 is the IPv6 version of 127.0.0.1 (localhost)
  5. cheekybuddha

    Format a row based on a cells value

    Ummm... easy, tiger.
  6. cheekybuddha

    Format a row based on a cells value

    I think Isaac means like this:
  7. cheekybuddha

    Solved FileDialog "Userdefined Typ not defined"

    Are you sure you have the correct object library selected? Microsoft Office 16.0 Object Library is not the same as Microsoft Access 16.0 Object Library and Microsoft Office 16.0 Access database engine Object Library, and can be easily confused. Can you post a screenshot of your references...
  8. cheekybuddha

    Variable not defined

    Did my post #6 and Pat's post #7 not help?
  9. cheekybuddha

    Variable not defined

    ' ... fldInfo = "Illustrator" ' <-- Add quotes to assign the string value tblInfo = "tblIllustrator" ' <-- ditto Response = MsgBox("""" & NewData & """ is not listed as an " & fldInfo & "." _ & "Do you want to add it now?", _ vbYesNo + vbQuestion, "Invalid Entry")...
  10. cheekybuddha

    Advice request: Retaining focus on a record-navigation listbox

    I haven't looked at Arnel's sugggestion, but really you just need to add an extra command in your listbox's AfterUpdate event. Eg if your listbox is named 'lstSelect', you can use something like: Private Sub lstSelect_AfterUpdate() ' code that performs the form requery...
  11. cheekybuddha

    A bad day with Access, is it only me?

    I don't think that's it either. You have a form called 'fdlgMessage'. It looks like it is used a custom MsgBox, but that is just a guess.
  12. cheekybuddha

    A bad day with Access, is it only me?

    No, that code looks like (a really horrible way) to open a different database.
  13. cheekybuddha

    A bad day with Access, is it only me?

    Timers are attached to forms - they will only run if the particular form is open. Close all forms and no timers will be running. To check if a form has a timer attached check the OnTimer property in the events tab of its property sheet. If it is empty then no timer. Search for 'send'. Also...
  14. cheekybuddha

    VBA Issues in Windows 11

    Might you have messed inadvertently with the Access Options? under 'Advanced' there is: It may look a bit different on your version of Access
Top Bottom