Search results

this is an update to a post in the code repository located here: https://www.access-programmers.co.uk/forums/threads/randomizing-data-for-posted-dbs.306745/#post-1640309 It's been 5-6 years but a flaw in my code was just discovered in that users who have spaces in table and field names get...

We've been in a drought since summer. Sometime around midnight Monday night a fire broke out on East Mountain. This picture is from Tuesday morning when they estimated it to cover about 100 acres. Today they estimate it to be about 1,100 acres and still burning. They say it wont be totally...

When did they update the Query designer. I didn't see any recent posts about it and the change just took effect the other day. Intellisense is awesome!

@Jon Can we no longer post links to the former twitter?

Guilty All counts.

Cross Posted here ... https://www.accessforums.net/showthread.php?t=83096&p=472473#post472473 As noted in my cross post, I was toying around with a custom class for a picklist utilizing a dictionary object. I want to use a dictionary due to the fact that it is much easier to add and remove...

In order to tightly control a data entry procedure I am using a custom class. Within the class I am instantiating several popup forms with withevents for several controls on the forms. Everything works perfectly so far except for the Class_Terminate event. I declare the class in the forms...

Happy Birthday @MickJav !

I've been playing around with dictionaries trying to get a grip on how to use them and what they can do. I've been trying to declare a public dictionary so that its members are available to other procedures within the module. It seems to work OK if I add the keys and items using Dict.Add...

A well run race from a familiar face

A week or so ago I came across some code which allows you to add custom buttons to the native message box. It seems that it may be useful at some point so its one to add to my code repository. The one thing I didn't like about it was the method of calling it. I added a function so it can be...

When a pop up form is opened as modal and you try and click somewhere else it is not allowed and a warning tone is fired. Is there anyway to detect that event?