Search results

Will have a mess with that, but the purpose of the code I use is not just to scroll to a record, but to keep the form in whatever position it was in. The currently active record may not even be on the screen. It just keeps the subforms scrollbars in the same position they were in after the requery.

That's not something I've heard of. Like many, I learnt VBA by googling things. That code I've been using for probably 13 or more years, starting in Access 2003. It's always worked fine so I never looked any further.

Sorry for the delay. The timer on the main form calls a procedure on the subform as below. Note it doesn't always steal the focus. Just sometimes. Public Sub RequerySubformWithoutLosingPosition() Dim OriginalSelTop As Long Dim OriginalSectionTop As Long Dim RowsFromTop As Long...

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

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