Recent content by CJ_London

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

So usual reasons for moving to sql server BE, nothing new. Now if only IT could actually support the typical rapid changes required to meet strategic initiatives, particularly when only 5 or 6 users out of say 500 users require the functionality. As it is with companies that have low data...

Can you provide some links to support your statement

dcount will return the number of lines in the query. If the query already has the criteria '"received" = False' then you just need DCount("*", "TotalOpenPOQuery")

What I have done in the past when migrating data from one system to another is to create a migration document. This lists all the tables and fields in the new system together with all datatypes and constraints. Sometimes with performance criteria as well. The old system tables and fields are...

usually means you have a spelling issue so first check names - TotalOpenPOQuery and OrderID - and is orderID on your main form? try using Me.OrderID to verify and try using "*" rather than "1" in the dcount function