Search results

Did you mean to include the BE in your attachments? There is also a reference to "C:\Temp\SquareClickHandlers.txt" in the code. Don't know how important that is.

I chalk this up to "Access does this in its infinite wisdom". The query engine is written to handle all queries, and the optimizer is quite limited. The result will be sometimes remarkably good performance, sometimes remarkably bad. I don't see how you can rewrite your SQL better. It is too...

I see your behavior, no matter the refresh rate (between 75.03 and 29.98). Personally, I blame the Philips drivers, which just don't perform very well at the extremes. I do not consider this an Access issue, but a hardware/driver issue.

Better!

I have a similar display setup, but the zip file link in #12 generates a 404 error for me.

Does it still work interactively? Web sites sometimes change. For example, 'user_login' may have been renamed. Inspect the web page's source code. They could also have added protection against automatic logins.

Welcome here! A complicated business model, but good for you helping those who cannot help themselves.

if myField occurs on several forms, this syntax can be used: Form.myField

For years I was jealous of Duane to know so many friends...

Your desired syntax "clsName.FunctionName" only works with static classes, which have Attribute VB_PredeclaredId = True in the header. See also this. Public methods then are available throughout the rest of the code.

Nice to see you here, Jeff.

Change this: strSql2 = StringFormatSQL("INSERT INTO tblCheckTran(TPayment, TReceipt, TranMemo, fTransactionID)" & _ " VALUES ({5}, {6}, {7}, {8});", TPay, TRec, TMmo, ID2) to this: strSql2 = StringFormatSQL("INSERT INTO tblCheckTran(TPayment, TReceipt, TranMemo, fTransactionID)" & _...

INSERT INTO tblCheckTran(TPayment, TReceipt, TranMemo, fTransactionID) VALUES ({5}, {6}, {7}, {8}); The numbers need to start with 0. You're starting with 5. I am not sure about the GUID formatting. The StringFormatSQL function may need to be updated to apply special formatting for this data type.

BuildCriteria comes with its own set of issues. Example: ?BuildCriteria("url", DAO.DataTypeEnum.dbText, "www.microsoft.com") url=[www].[microsoft].[com]

Yes, they are the placeholders that get filled by the arguments provided, in the same order. Check the comments of the StringFormatSQL and StringFormat functions. Also, review this YouTube video, starting at 35:30:

If the Num field is Null, you should store Null in the table. It is a nullable field, right? You have a second issue: the date parameter is not decorated with #. May I suggest you use modStrings from the Northwind 2 Developer Edition? It has a handy dandy function for you that takes the...

I'm trying to say that it cannot be decided which of these is correct: A14212 19/06/2025 111 444242 5 --- 1 A14212 19/06/2025 111 444242 9 --- 2 or A14212 19/06/2025 111 444242 5 --- 2 A14212 19/06/2025 111 444242 9 --- 1 Maybe the OP does not care. That would then be the additional rule.

I think this ranking is dangerous. The example data is unordered (as all table data is), so it is impossible to assign rank 1 and 2 to the first two rows without an additional rule.

There are some tools that can do this, such as MZ-Tools. In lieu of that, you can do a find and replace of "Debug.Print", and change it to "'Debug.Print" (note the single quote to introduce a comment)

That value is not making it crash, but likely something related to it. You speak about Stack Overflow. Is there VBA code involved here, presumably behind a form that is bound to this table? As a test, comment out all VBA, and Repair and Compact the app. Still a crash? If yes, what if you have...