Search results

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

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

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

Hi there, Does anyone have a reliable method of getting Access to run code in response to the user pasting some records into a subform? After_update and After_insert do technically work, but they cause the code to run after the insertion of each individual record. So it runs 100 times if you...

Just wondered if this is something people are aware of and what might be known about it. I've noticed that you cannot manually trigger a DoCmd.SetParameter BEFORE you have viewed the navigation pane in a database. To demonstrate this in its simplest form, if you: 1. Create a blank database 2...

Hi everyone, For about ten years I have had a "Please wait" style form that I use to keep the user informed when they are waiting for some long running operation to be completed. I might update this multiple times during a process. "Downloading results" "Calculating totals" "Reticulating...

Hi there. First time poster here. Just wondering if anyone can offer me some assistance. I am grabbing data from a local table, placing it into an ADO recordset, disconnecting the recordset, then applying the recordset to a subform. I then manually edit the data in the subform (let's say I...