Search results

Update: I found some rogue DLookups along the query chain and replaced them with subqueries, but I'm still experiencing the same problem.

Hi, I have an Access database that has been working normally for years. No recent changes on my end, although my corporate IT environment likes to change stuff silently in the background. It was built in Access 2016 and currently running on O365 32-bit v2202 b16.0.14931.20602. It has very...

Thanks, all! Ranges from zero URLs to around 25, I believe. I reckon I'll write some code for this as it'll be easier (and I understand it more than complicated queries) Hi Colin. This is entirely contained within Access so unfortunately cannot go cheating and unpivot with PowerQuery :p I...

Hi all, Having a bit of a brain fart. I have a file that I import into a table in Access 2016. The data ends up like this: MainTableID PicURLs 1 www.example.com;www.abc.com;www.xyz.com 2 3 www.access-programmers.co.uk The field PicURLs are zero or...

Kinda. The pig db runs the operation locally and displays an infinite spinner by opening a separate lipstick db. My db updates the current (dual)meter class locally and runs the operation by opening a duplicate of itself.

I forgot to update this, but I did code in my 'bodge' from post #26. Even though it is limited, it works to alleviate the pain from accidental cancellations. Code below for reference. Hopefully, it will help someone somewhere: 'Run the queries On Error Resume Next j = 0 For i...

I use FrothingSlosh's progress meter in one of my in-house applications. I coded it in about 18 months ago, with some of my own modifications. It's really great. I've thanked FS before, but I'll take the opportunity to say my thanks again :) I had a query that extracted data from a gigantic...

Ah, if Task Scheduler has to be run from an always-on computer then I would have to get the IT department involved. The company I work for is very 'hot desk' orientated with all the computers being laptops (that we shut down and store each night) and no permanent workstations or offices at HQ...

Thanks for your continued support ridders. Me too! I was perplexed when I discovered this, and it is the biggest reason I want to be able to disable the ESC key's ability to cancel queries. I want to be able to carry on working while the update is taking place without worrying about keypresses...

Thanks ridders, I appreciate your detailed answer. I didn't spend much time trying to break your db exactly as it was since it doesn't reflect the situation I'm trying to solve. However, starting from an empty table each time and running both methods at 1000 counts, I was able to interrupt a...

Hi ridders, Thanks for tackling this for me! Unfortunately I have managed to break your method, it must be my uncanny ability to break everything :) I have reattached the sample database with my changes. The first point of the SQL... actually I designed it exactly like that to create a slow...

I have created a sample database that can replicate this behaviour with the ESC key. I'm using Access 2016. Pressing the ESC key while the SQL is executing / running will throw an error to cancel the SQL statement. See attached.

I've done some more testing and the ESC key is definitely being picked up during the db.Execute method and canceling the execution.

I have just tested with not loading the "Please Wait" form, so that the loop to execute the queries is happening without any forms involved at all. Same behaviour.

I have just quickly created a form with a button that triggers the code and applied the same techniques as in the above post. No change to behaviour.

Hi ridders, Interesting that it might be taking the keys through the "Please Wait" form (which I forgot to mention in the original post--now edited) so I have tried your solution. The database is pre-release so currently the code is called manually and not from a form itself. Here are the steps...

Hi all, I have a piece of code in one of my databases that runs 22 queries to import, delete, and append external data to the local tables. This process--due to one or two large queries in the source database--takes around 2-3 minutes, which is not a problem in itself. However, I have noticed...

Thanks for your advice, I'll let you know how it goes :)

Some good questions there Mark. OK, so we are a motor manufacturer that put a lot of new vehicles on the roads through contracts. After the contracts end the vehicles come back to us. We remarket them and sell them to the dealership network at trade prices (which in turn are sold by the...

Hi ridders, That's true, it is not clear just from the relationship view. BonusName in the parent table is the unique 'database name' for the bonus scheme, e.g. I have "QuarterlyBase" and "QuarterlyAdditional". In the generated reports sent to the dealerships however, these both have the...