Recent content by CJ_London

Do be aware that classic outlook will cease to exist (or at least not supported) in I think 2029. Although Classic (i.e. the outlook application) is still available, at some point you won't be able to download it. For individuals like yourself it is not likely to be a major issue but if you are...

for CDO Account is your email address or user name for sending, Server will be something like smtp.gmail.com Port will be something like 465 Authentication is your password some email servers require what is called an app password, all depends Basically the same information as when you set...

If you are just sending, there is also CDO. Plenty of examples if you google - here’s one https://www.devhut.net/vba-cdo-mail/

May be missing the point, but you can use the timer event - away from my computer at the moment but set the timer for say 1/2 second. Reset the timer on each key press. If user hasn’t typed anything for 1/2 second, assume they have finished

not sure how many fields you can have in a composite unique index (certainly more than 2) but what I have done in the past is hash all the relevant fields and store the hashed value in a unique indexed field

Perhaps clarify what you are trying to do and how - seems like your issue is when clicking on the combo down arrow? And the after update on fires if the selection changes

much the same in the UK. Pretty sure there is also a flag raised if you withdraw large amounts of cash - not sure what the level is but would guess £10k

Someone I know (no names) has a business supplying and installing swimming pools, spas etc. During Covid he had a a lot of customers coming to him wanting to pay cash, no invoice -most were around £10k, largest one was nearly £30k. He though he was onto a winner until I pointed out to him that...

Suspect it is a problem with the forum presentation - It looked fine when I copy/pasted from the browser. I'm not prepared to spend more time on this. Suggest do what I did - copy paste the OP's questions to your browser.

a further google on the question 'Suppose Access is the only application running on a computer, what hardware, operating system, and configuration is recommended to maximize the performance of the running application?' produces this result: To maximize the performance of Microsoft Access, it is...

googling the question 'What PC hardware/software is needed to run Microsoft Access quickly?' produced this response: To run Microsoft Access quickly, your PC should have at least a 1.6 GHz dual-core processor, 4 GB of RAM for 64-bit systems (or 2 GB for 32-bit), and 4 GB of available hard disk...

Been asked - yes, pursuaded - no Last one a couple of years ago was for a theatre company - an employee had built it using only macros and no documentation. And data wasn’t properly normalised. It handled show bookings and some elements of production and staffing rotas. They wanted to license...

about 20 years ago I was involved in migrating an access system for calculation of sales commission for around 600 sales people. It used to take about 1 1/2 hours to create 600 reports and email them to each person with copies to managers. The new boy on the block decided that access was not a...

The problem i have with the new browser control is that when using it to display local files. updating the control source doesn’t always refresh what is displayed

can't say I agree with all those comments Why "1" is better: Faster - Access doesn't need to resolve field names No field name conflicts - Won't break if you rename/delete fields Clearer intent - You're just counting records, not referencing actual data Performance comparison: you don't do...