Search results

"£" seems to indicate you may be in the UK. Make sure your Azure database is in a data center near you, not in say Asia or USA. As an example, on the portal home page I hover over Resource group, and it shows my resources correctly to be in West USA: As another example, here I am in a command...

"... recommended MINIMUM versions ..."

The old-fashioned way. I saved a color bitmap at (in this case) 48 x 49 pixels. Then dropped a button on a form, and clicked on the ... button of its Picture property and selected it.

b/w only?

WRT the connection used by SSMS: it says so on the Connect dialog: ADO.NET

I just tried it with a basic Azure db, and it was also almost instantaneous.

These are all instantaneous for me, with a local SQL Server.

That query needs another clause: GROUP BY SalesPerson

Hi Josef, I think assigning the result of DLookup to a string somehow modifies it because this fails: s = DLookup("myReplicationId", "tblAccessReplicationId", "myShortText='aaa'") DumpBytes s while this works: DumpBytes DLookup(...) I'm tempted to see if I can hook up a debugger to the...

Playing is good! That's how I learn. You could have called "DumpBytes ..., 0" to indicate unlimited size. Your approach reveals something interesting: in a recordset the returned value is the string representation of the GUID, as-usual in Unicode so every other byte is a zero. It probably makes...

Yes, I am aware there is a big difference between a String and a Variant of subtype String. The latter would not have a VarType of vbString. Indeed a conversion function like you showed may be the best idea. What I was after with my question is more understanding of WHY this is so, not how to...

I'll wait until you are able to. You will see the compile error when you uncomment that line. All 3 forms of the variable return a vartype of 8: vbString. That is the point I want to discuss because some of them can be converted to byte array, and some cannot.

(cross-posted in Access MVP email list) Environment: A365-32. Some variables have a VarType of vbString (8) and I can pass them to a function that takes a Byte array as argument, and some have the same VarType value and trying to pass those gets a compile error: Type mismatch: array or...

Copilot says: Large Number was introduced with A2016, and Date/Time Extended with A2019, and both are in 2021 LTSC.

You're talking about an ACCDB, right? That surprises me. File > Options > Current Database: uncheck Support Large Number and Support Date Time Extended. I am not sure they made it into 2021. And for sure uncheck "Enable Monaco SQL Editor". That one certainly is not in 2021. Of course, the old...

One step towards figuring out what is happening is to implement Crash Detection. It only takes a few lines of code here and there. The basic idea is: 1. AutoExec macro calls VBA function to start the app. As part of that the first hidden form is opened (frmHidden). 2. frmHidden ticks a timer...

Better: CurrentDb.Execute strSQL, dbFailOnError Personally, I don't like to worry about string concatenation and escape characters for dates and strings, and I use the StringFormatSQL function from Northwind Developer Edition template. Also, single quotes are easier to read, in situations...

Welcome to the forum Martin.

The original:

99.999% chance it will work with 365 as well.