Search:

I'm with Baka on this one: If just starting out, don't learn VB6.
Look for cross-platform (everything baka said).

For that purpose i go with FreePascal/Lazarus: Open Source, Free, Cross-Platform,...

*sigh*
And a Date-Format is basically a Long Integer (actually: a Double without the Fraction part)
and a Time-Format is a Double in the Range of 0 to 1 (actually: the fraction-part of a Double)
...

Hi Folks,

something weird:
Excel2019-64Bit on Win10Pro-64Bit

Via macro i pull data from a database and transfer it to a worksheet.
This macro has worked for years in production.

Since i've...

Besides having to sit at least 4 feet away? :D

True, but i wouldn't be surprised if under the hood it's the same function every time, overloaded with flags and what not. see Flag IGNOREWIDTH in wqweto's link, which basically can be used for...

Considering it's Microsoft we're talking about? *shrug*
Out of my left sleeve: Take a binary representation of both strings, and subtract one from the other. If Result = 0 Then Equal Else NotEqual...

Huh?
You lost me there.....
btw: I just noticed the name of your table.
"user" is already a table in the database "mysql" (System-DB).
Have you tried qualifying the tablename/SP?
CREATE TABLE...

Duplicate Keys where? Within a Section?
That doesn't make sense.

OTOH, a key can be repeated in a different section.

Sections in an INI-File: Must be unique
Keys within a Section: Must be...

...which actually implies the same way RTLCompareMemory works: compare each "character" (honoring the flags), until there is a "difference"
Otherwise it couldn't return Results like "is less" "is...

https://docs.microsoft.com/en-us/windows/win32/api/timezoneapi/nf-timezoneapi-systemtimetotzspecificlocaltime
Depending on if that server is on UTC, or in its own TimeZone differing from UTC, you...

No idea if the compiler optimizes a String-Compare to a RTLCompareMemory, but i wouldn't be surprised,
if a "If String1=String2 Then" compares the whole memory-blocks the Stringpointers point to....

Have to disagree.
Scroll down about one third. MySQl allows granting columnwise
https://www.mysqltutorial.org/mysql-grant.aspx/



GRANT
SELECT (employeeNumber,lastName, firstName,email), ...

Have you tried increasing the VARCHAR-size in the Parameter?

https://stackoverflow.com/questions/13960760/mysql-stored-procedure-that-accepts-string-with-multiple-parameters

At a guess: Records (VB6-speak: UDT's) accessed/written in random mode.
Have you tried reverse engineering the Record-Structure?
First, i would look, if there is a repeating pattern recognizable...

....and at its Window-Styles (HIDDEN, SILENT or whatever it's called)

That blasted "Active"-Something again.
Is your "Active"-Sheet even the "correct" one?
Does the error happen, when you qualify the sheet directly (via number/Name)?

Why don't you build a computed column from your 2 columns and compare that one?
If you have fixed-length Text-Columns, use TRIM to cut off leading/trailing whitespace
Aircode

SELECT/DELETE *...

A friend of mine made an "interesting" suggestion (note the quotation-marks):
"Actually, we could defeat that blasted virus quite easily: The whole world just has to stop for 4 weeks, all at the...

https://docs.microsoft.com/en-us/windows/win32/api/namedpipeapi/nf-namedpipeapi-peeknamedpipe

Ehhhh.....wrong!
I know for a fact, that TeamViewer has a central Server, where all clients connect to /register themselves with. That's the server which assigns you your TeamViewerID.
So,...

I admit: It's been some time having tried something like this,
but, couldn't he define a "child"-class "POINTL" with just two public Properties (x and y As Long), in this mode "Public - Not...

Had that thought, too, but since it's Graphic-API's i wouldn't be surprised when there are other API's waiting down the code, which actually are expecting a POINT-Structure as an argument

hrhrhrhrhr.....
Written in Office/VBA (that's why the PtrSafe and LongPtr is there)



Private Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As...

Urggghhh.....forgot about the implicit Type-Cast

Nevermind, that you should never save a Date/Time-value in a String-Variable.
Just use Format (which returns a string) to assign/show/display...

Or if you know the internals of your DB-Backend you can just query the System-Tables......

Or Dim the new Array to its new Size, and then CopyMemory the VarPtr of the old Array to the new Array with the correct/new length.
Don't forget to cheat the ref-count.

EDIT: I'm with baka on...

Why not just use the predefined Formats?
Debug.print Format(Now, "Short Date")
Or the FormatDateTime-Function?
Debug.Print FormatDateTime(Cstr(EstDate),vbShortDate)

It has nothing to do with SecurityAttributes, but with Access-Rights the User, who's running the Program, has.

It's the age old problem with write-access to "c:\Program Files" and similiar folders...

Eh? How do you figure it's supposed to be 241?
On my machine (Germany) the "±" is: ALT+0177
https://www.ascii-code.com/

You know, looking at the link wqweto provided.......

.... i don't think there is enough alcohol on the planet for me to suddenly understand a single word of that one day.......
:D

Sam, your initial Problem reminds me of Conways "Game of Life":
It checks the (max) 8 possible squares around the "selected" square for a "state" (dead/alive)
Maybe you can find an algorithm there:...

As a "quick" ( ! ) solution:
Your "RT"-Field seems to be the "key" of the Array, and you want it to be unique, albeit with the Highest Width of a Glyph.
As an algorithm (Aircode)
Define/Dim a...

Have you checked, if "lpClipMemory + Len(tDropFiles)" in your copymemory-call actually translates to a Memory-Address?
Add to Watch-Window:
lpClipMemory
Len(tDropFiles)
lpClipMemory +...

Haven't looked at the Workbook.
1) If you want to use a VBA-Function directly in a cell on a sheet, this function must be "Public" in a standard-module.
2) That said in 1): How are you passing...

Agree with Arnout.
Collect the Foldernames with Dir (or its API-Sisters) matching that particular pattern,
comparing Foldernames to your Pattern you can use the "Like"-Operator
in a hidden ( ! )...

Between your working 32-Bit and not working 64-Bit-Version: Have you checked if there is a difference between Len(tDropFiles) vs. LenB(tDropFiles)?

You do know, that the VBA7-constant checks the Office-Version, not the Bitness of the Office-Version?

I've run into a similiar Problem, when the company i work for switched from Office2016-32Bit...

Hi Folks,

something weird:

I've written a small tool for my boss in excel (for him to query our database).
For that, on the primary worksheet there are some ActiveX-Controls (ActiveX, not...

And now i'm going for the Overkill:
Why not shell calc.exe, use the PID that shell returns to find/get the hWnd of calc.exe, and then SetParent to a Picture-Box?

Right, just thinking out of my...

You mean besides the point that this is VBA/Office apparently?