Search results

I noticed an unrelated bug: Case "Location":<br> R = 230<br> G = 192<br> B = 228<br> str = "BO" Did you know you can add FormatConditions programmatically?

Maybe this will help: dim url as string url = "loveracing.nz/RaceInfoSearch.aspx?q=Kenny&s=All&g=All&r=undefined&t=Name#horse" url = replace(url, "Kenny", Forms!myFormName!tbhorseName Application.FollowHyperlink url You may need to add "https://" at the front of that url.

I really doubt it. Using Access BEs only, can you show a distributed transaction that works if MSDTC is running, and not if it is not?

10,000 images at 12 mb each would take up 120 GB space. It is not possible today to buy a hard drive that small.

Define "better". I'm assuming your image control is set to 1200 x 1800 pixels, so resizing to that size makes sense to me. The image quality is secondary. Certainly you could offer a button which would open the original image in the default viewer on the machine. That way users get the best of...

Very curious. DLLs in the SysWow64 folder are usually 32-bit (on 64-bit Windows). I was using 32-bit Access for my test, and selected the one in SysWow64. Just for grins I also tried the one in the system32 folder (which should be 64-bit), and got "Can't add a reference to the specified file". I...

You're right. I first thought "es" in the filename stood for "Espana", but it is "Expression Service". Mine is v6.2 from 2025-09-09. In an obscure folder is a v4.0 from 2024-04-01. I think your chances for a fix just went up. If only we could make it crash with current A365. I just tried, but...

There have been other reports in this forum about that DLL, such as this one so there is a chance the issue is more universal (read: more likely to get fixed) than that property in ADP reports. I would start with rolling back the latest updates. And long-term staying with technology that has...

I play the Wordle game with friends (where you get 6 chances to guess a 5-letter word), and on Sundays one of us comes up with the Starter Word for the first guess. I wanted a football-related word and asked the Google AI on my Pixel phone. This is what it came up with.

The OP's #1 message says that it is not.

Would you agree that with the several explanations and amendments, it's about time for a very simple repro database? Might take you less time and would be much more fun for us.

It's not crystal clear to me if you want to have only 1 instance ever of ClassA and ClassB. If so, then you can use a Static class, like clsErrorHandler in Northwind 2 Developer Edition template.

It's not OK, as you can see when opening any code module. Option Explicit has not been added. If I add it, then the code no longer compiles.

> Neither RD nor Citrix requires a VPN While technically true, it is a best practice to have VPN anyway, and to establish the RD connection over this VPN. Ask your knowledgeable IT consultant.

You do not have the standard 4 references as the first 4 in this list. That is a really bad idea. Create a new db and check which ones they are, and select them here as the first ones. Jet Replication is a thing of the distant past. Using it now puts you in very uncharted territory.

After replacing your: Option Compare Database with Option Compare Database Option Explicit your code no longer compiles. Can you please fix that and post a new version?

Because Access puts the entire query back together before executing it.

That won't help. What would help is to replace the subquery with a call to DMax or other domain aggregate functions. Those keep the query updatable.

The "TOP 1" clause makes the query not updatable. You can also see this when pasting the entire statement into a new query in SQL view, and running it. The * line for new record will not be there.

Can you concatenate LocationID-ItemID as the identifier? That would be unique, no?