Recent content by bsacheri

I like this approach because it is easy to implement into an existing application. All you need to do is add one code module. All of your existing code will continue to work. Any place you want to accept password input you can pass an additional parameter to the InputBox() function. The...

I have made some enhancements to post #27 by @riti90 The function is named InputBox() and will override any normal calls to the VBA InputBox thus you don't have to update code if you implement in an existing app. It has an additional parameter that when set to True will mask all input as '*' If...

Good timing. 2.5 years later and I was just revising the code that day.

It's 2020 and I'm still programming in VBA!

If you have a button on the form that users click to close it, and your query is being displayed in a subform object, then add this to your close event: Me.subform.SourceObject = "" If you don't have a Close button, then I don't know what to suggest. I'm running into a similar problem. If...

I was the original author of that utility. :D I'm glad to hear that it has been helpful to others. I recently discovered that it has been enhanced and made available on Colin's website. I'd post a link to it but I don't have enough reputation here.

If you are still looking for a solution, I have contributed to a VBA Class that can be attached to any combo box and provide find-as-you-type capabilities. This is something that I had looked for for years so I feel I should share it on this site since this is a recent inquiry. Some features of...

It is unfortunate that I can't post links here. I found a solution on another forum. If you want to see it, go to UtterAccess and search for "Mouse Pointer Won't Change To Hourglass, Access 2010" There you will find an API routine there that will change the mouse pointer and it defeats the...

I have an image to show but I'm new to this forum so I'm unable to add hyperlinks or images until I post 10 times. I've been using VB/Access for a long time. The "GoTo" is static text in a textbox control. The control is formatted as a Hyperlink to make it appear blue with an underline, and...

Re: hourglass delay from hyperlink click Skipping ahead 10 years....I wanted to chime in on this old thread in case anyone has come up with a working solution or is searching for one. I think I'm in the same boat as the OP. I suspect there is a bug with the way Access handles the hyperlink...

Re: XP Style Msgbox Buttons - vbSystemModal For anyone reading this in the future I wanted to note that vbSystemModal does not work for me when using Eval() on the Msgbox. In my use case I have a process that takes a few minutes to run so while I'm waiting I may open other applications...

If you are looking for a solution for a combo box, I have contributed to a VBA Class that can be attached to any combo box and provide find-as-you-type capabilities. This is something that I had looked for for years so I feel I should share it on this site since this is similar to this thread...

Zurvy, Thanks for posting that concise example. :) It worked great for my purposes and was much simpler to implement than the VBA class provided by Stephen Lebans. The attached image shows how this appears when applied to various reference tables. I'm measuring by inches and for a Tahoma 8...