Search results

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.

I thought the claim being made (in #10) was that multi-instance forms could be supported without a Public Collection or similar to hold the form references. Maybe I read that wrong.

No objection.

The demo has 3 identical tables, one curiously named Employees. Can you shed more light on this?

Yes that is correct. Fortunately, that is a problem you can ignore, since you are upgrading.

In #1 you wrote: "need to be migrated to accdb" So do that, and make sure you have the 4 standard references in their normal order (create a new db to be sure), and remove the DAO 3.6 reference.

You may also want to consider SQL Server for the BE. Opens up new capabilities, in addition to a more stable and secure BE.

It's a great time to think about new features. Often as a beginner we can present the data, but are not yet thinking much about what to do with it. For example, are there alerts about quotes that are past due? Orders that are stuck in the process? Can quotes be copied from a template or a...

I typically create a new VBA module with procedures that perform the conversion. There is a Main procedure that calls the others in sequence. It is designed to be able to run multiple times as you perfect the conversion more and more. It starts with "Clear out most new tables". Some are just...

I use unbound controls as well. In Form_Open: Me.TimerInterval = 1. This starts a timer. The form will continue to open. Form_Timer happens after the form is open and visible. In that event I stop the timer Me.TimerInterval = 0, and then call RefreshKPI procedure. It calls a stored procedure in...