Search:

I can help you tomorrow from my workplace (no VB at home)

Run through the array using do/loop until you hit first „GetHost“,
next array-member is user hosting
next array-member is game name
next array-member is game description
next array-member is...

Use my code in post 3, and ignore array-members you don’t need
it‘s not rocket science

From where are you calling it? From a Standard-Module?
Fully qualify the ListBox? myForm.lstChars.Clear?

At a guess: Look in Settings for Include/Exclude Paths-Properties

Quarantined by AntiVir?

I think i understand


Sub main()
Dim s As String
Dim t As String 'temp. String
Dim d As String 'Delimiters
Dim p As String 'Primary Delimiter
Dim r As String 'remaining Delimiters
Dim a()...

And your problem is?


Sub main()
Dim s As String
Dim a() As String
Dim i As Long
s = "@dE%GetHost#@¥€¥€%@harris fna¥€%@men of...

There is that, nevermind opening an existing (!) file for Output implies overwriting it, and maybe this is your time-penalty
Maybe as a test: Open for Output to a different filename

Well, not counting algorithm (Loops etc.) , IMO 95% of IO-File-Performance is due to Hardware, as in the "pure" read/write-operation.
Like: SATA-HDD vs. SSD vs. NVMe

It's probably your loop
Untested


Dim iFile As Integer
Dim strAllDogs As String
iFile = FreeFile
Open App.Path & "\result.txt" For Input As #iFile
strAllDogs = Input(LOF(iFile), iFile) ...

Probably your best bet

20,000 rows?
that‘s ……. cute…..

Got it without ROW_NUMBER

SET @rn = 0;
SET @ic ='';
SELECT
i.item_code,
i.item_description,
i.item_unit,
ip.order_number,
ip.order_date,

Argg...and additionally i missed that ROW_NUMBER is only available in MySQL8 and later, not earlier.
Damn!

wqweto, OP's Problem is, that he wants to create a View for that Statement, and MySQL5.6...

OUCH! Why such an old version?



https://dev.mysql.com/doc/refman/5.6/en/create-view.html

If i understand it correctly, with MySQL5.7 and newer you don't have that restriction, MySQL5.6 and...

Returns:



ABC01
Item Number One
Ea
1238
2022-07-09
10.33

Tested in SQLite (No MySQL at Hand).
ROW_NUMBER might have a different Syntax on MySQL, but researching it couldn't find any difference
SELECT
i.item_code,
i.item_description,
...

From Post 10:


Well then, as a last guess:: SELECT * FROM blablabla
Do we know what he tries to pull in using "SELECT *"?
Maybe some BLOB-Columns choking everything.
It still wouldn't explain...

Just saw it: Since when do you use single quotes in Jet-SQL?

And since it's MS Access the wildcard should be "*" and not "%"

How if he needs a Type provided by the "other" DLL?
Or do you mean as a "dummy" (a.k.a. empty dll)?

How if it cannot solve the dependency because the other dll is (still) not compiled?

For me, THAT is close.... :-)

Eh? So i was actually pretty close.....

hmm....what about swapping out that "type" into a support-Ax-DLL, so both dll's can reference that type in that dll, and the second dll then only needs to reference the first one?

Use latebinding?

Go through the individual Settings in the PageSetup (comment them out one by one)
I'm guessing, that you're trying to use a Setting your printer doesn't understand.

OR: Have you checked your...

hmm...
I'll take your word for it, since i've never used EXISTS in that context (don't laugh, it's true),
and IIRC, not all DBMS provide the EXISTS-Operator/Function. So i'm more used to use the...

Hi Folks,
everyone knows the Problem trying to compare a column against multiple values with wildcards.
This usually results in "constructs" like


SELECT DISTINCT SomeTextField
FROM Table...

I already quoted the SQLite-doc's, that there is an "arbitrary" Order for GROUP_CONCAT, though i also wrote my thoughts on it.

Would have to disagree with your proposal.
A CTE is basically a...

you're right :D
It has to do with that i've started to explicitly select columns for JOINS, so call it personal preference
(And yes, TID as Output-Column for the CTE is not necessary. It's a...

Are you coding VBA inside Excel?
because if yes, F1 refers to a Website, so if you don't have Internet-connection....

In another Forum i helped out an User who was struggling with the following:
He had a table "tbl_employee" and a table "tbl_task", which were connected in an "m:m"-scenario via "tbl_emp_task"

He...

Then the last thing coming to mind would be, if his Office is a "Pro" and if he can open the mdb in Access directly

No, it's not.

Is this even legal?

Hmmm….. OP said he has Win10 on a separate partition of this (Apple) Harddrive.
i‘m not familiar with Apple (APFS?) but maybe it‘s the harddisk-controller messing stuff up when trying to read/write...

Check if "db1" is a valid (Database)-Object (in Watch-Window?). Maybe OpenDatabase fails and returns "Nothing"

EDIT: Wait a sec. He has DAO and ADO referenced, but his "Dim rs1 As Recordset" is...

Remember: he has an active Error-Handler

That's DAO, definitely (as you can see in his References).
But why he's referencing ADO too, escapes me.
Next: Is Excel/Office installed on that VM? (I'm guessing he runs Win10 in a VM on the...