Recent content by Bennet

Hi, Just looking for some input on the following. I have a couple of different databases which are often left open in the background whilst the user works on other tasks, and this makes total sense considering their purpose. Every ten minutes or so, the main form timer causes the main subform...

Could probably solve it by hiding the parent forms. Aiming to keep the parent forms visible for reference if possible. Tried adding Me.Visible = True to the on-load code of the form which didn't make any difference. Which makes sense, since the form is visible, it just isn't "on top".

I like the sound of this and would be grateful if you are willing to share, for general purpose use. Some further experimentation indicates that the problem in this case is definitely a window stacking issue, rather than the form opening unnoticed on a different monitor.

Hi, fellow Access enthusiasts. I have a front end database which runs with a maximised form as it's main interface. Sometimes, I open a "pop-up" form in a window which opens in front of the main form - all fine so far. Then the first pop-up form generates a second pop up form which gives the...

Many thanks for all the above. It's actually our own IT department who are putting pressure on me to stop using it, even in this controlled and limited way, because of security concerns. SeleniumVBA looks brilliant and that's now going to be my primary avenue of investigation - thanks again.

Hi all, In the past I've written some fairly extensive browser automation scripts in Access VBA, using something called OpenTwebst that talked to internet explorer. I'm now trying to move to automation of a modern browser and (as of about two hours ago) I'm learning about Selenium, and...

OP, have you tried chat GPT for this stuff? (Seriously.)

Ghetto solution: I often have Access write and execute autohotkey scripts. They might not let you automate email sending, but they probably can't stop you scripting the keystrokes that will generate and send one for you :devilish:

My solution to multi-user performance issues has been as follows: 1. Design the database from the outset to reference the back end the absolute minimum it has to. As part of the autoexec procedure, download all commonly used reference tables and refer to them locally. This makes launching...

Any time I want to show my user some data or pick something from a list I do it dynamically with a universal form. (Not created on the fly - it already exists - you just alter the text and the source query etc etc.) Or maybe the OP is creating a new form for every new product line or something...

It sounds a bit like there might be lots of highly bespoke forms for very specific purposes. If that's the case, it should be possible to create forms that dynamically alter themselves that can be re-used for multiple purposes. If that's true you might be able to delete hundreds of them. Hard...

Amazing! Are many of those forms automatically generated or has someone really created all of those manually?? Can I ask what sort of things they do? Are there lots of forms created just to get the user to answer a question or confirm something? Sounds like a nightmare! Still genuinely...

Sounds like a sensible consideration. You can probably achieve this with dedicated front ends for specific areas of the business which only contain objects relevant to that area. How far you split it is totally up to you. In my opinion, for all practical purposes, splitting a front end in this...

Dear Amorosik, May I ask what your project is and what it's for? I'm intrigued. Genuinely! Especially about the purpose(s) of the new objects you will be adding continually. :)

I bet you could achieve this by capturing whatever the user has typed in when they hit tab or enter, then perform a string comparison of their entry against every allowable value in the combobox source data set, then set the combobox to the one with the best score. May not be worth all that...