Recent content by CJ_London

You also have the functions choose and switch

why convert to vbscript when it is to be deprecated? if you are using a .accdb as a loader app you could use something like Select case SysCmd(acSysCmdAccessDir) like "C:\Program Files\*" case true 'access is 64bit 'install 64bit accde case false 'access is 32bit...

yes it's 0 x 0cm so cannot be seen - but needs the visible property as true to be able to receive the focus. It's a method I use when I need to do something to a control that has the focus - simply move the focus elsewhere. GF is just a name which means 'Got Focus' or 'Gets Focus'.

My example does, but can run in any app that uses vba such as excel or word - the other thing you need to consider is whether the app is in a trusted location (for the app that is running it) otherwise the code won’t run

you can use this code snippet to return the access path - it reads the registry Function GetAccessExePath() As String Dim ws As Object Dim folder As String Set ws = CreateObject("WScript.Shell") On Error Resume Next folder =...

Perhaps this is what you are looking for? https://www.access-programmers.co.uk/forums/threads/a-multi-select-form-using-unbound-check-boxes.323395/

You’ll just have to try harder to join the developer program from a seller perspective. Do you have a seller account? I used Amazon and shopify a few years ago and had to have my client grant me access to their account to download the transaction history to consolidate into production orders.

Copying and pasting a table or query to a post looks as expected until you save it - then its all code and unreadable. e.g. I copy/paste: but go to preview or save and it looks like this: what an I missing? Query1 PricesOrderedFromFK PricesQuantity RegisteredOn PricesRegisteredBy...

Can you not use last (with a sort)? SELECT PricesOrderedFromFK, PricesQuantity, Max(PricesRegisteredOn) AS RegisteredOn, PricesRegisteredBy, Last(PricesUnitPrice) AS LastOfPricesUnitPrice FROM tblProductPrices WHERE PricesProductFK=34086 GROUP BY...

In the uk we have sites like goCompare, comparethemarket where you can compare house/car insurance, utilities, telecoms, broadband etc We also have insurance brokers who search around for the best deals come renewal time. do you have something similar in the US?

Depends on whether or not the site provides api’s to allow you to do what you actually want. Each will be different, some are provided free, others you pay for a license Review this link for eBay https://publicapi.dev/e-bay-api Search sitename api for others Search ‘rest api in vba’ for how...

As can an accdB

You don’t show how you are creating the json or the sql to your queries so not sure what to say. Are you saying you will be parsing a query to create the json? And it is the line numbers that need to be consecutive? If so why not use a counter in the the code to create the line numbers at the...

Seen on a card If cats could text….. > > > They wouldn’t