Recent content by cheekybuddha

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...

Missed that! More coffee required! :LOL: :coffee:

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

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

Ummm... easy, tiger.

I think Isaac means like this:

Yes (y)

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...

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

' ... 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")...

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...

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.

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

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...

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