Recent content by Bennet

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

I wanted to do this recently and hit the same problem. The reason was that I wanted to generate a new record for the sake of getting its ID number which I then wanted to use in other tables. Yes, there would be some more info to write back to that record later, but for now I just wanted a new...

My guess is that the actual reason for failure is that the file is still technically being accessed by your own procedure earlier on, and it hasn't "let go" of the file yet. Could try putting the actual import in a child procedure, and maybe once that ends the parent procedure will be able to...

Are Depart and Ward ID number fields or text string fields? If text then I think you would also need to wrap it in speech marks: "Depart= """ & REC("Ward") & """"

No idea if it would work in your circumstances but one hack I've used to get something to happen as the last possible event after a form has loaded and rendered is to stick it on a half second timer.