Search results

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...

>even though they are both using the same tables If both forms use the same underlying tables, the filter should work in FormB. Example filter: TableA.FieldA = 5 If FormB is also bound to TableA, the filter should work. If that's not what you are seeing, can you upload a very simple repro database?

I checked your code and put a breakpoint at the bottom of the Timer event. Then in the Immediate window: ?[cboEarlyDutyManagerHour], [txtNowHour], [cboEarlyDutyManagerHour] = [txtNowHour] 9 09 False The number 9 is compared to the string "09" and the result is: not equal...

Nice to see you here Ken.

Re API: I made it work with Postman (which is a tool to call REST APIs). I'm sure it would work with the VBA-Web library. The OP would be well advised to exercise this API so you can see what data is available, which may influence your db design. There are several APIs available related to...

In the immediate window (Ctrl+G): ?strPath Or in your code: Debug.Print "strPath=" & strPath If you REALLY need it in the clipboard, you may need to use Windows API calls. E.g. see https://www.devhut.net/vba-save-string-to-clipboard-get-string-from-clipboard/

Can you create a new table, with only one field, bigint, and make it the PK, and see if linking to it causes #Deleted? You may also want to temporarily turn on ODBC tracing.

Did you follow the advice of #10 post in that previous thread?

> it will not work That is too vague. Is there a runtime error? Then cite it verbatim. Are no records inserted? That would be correct if tblDnaTests has no records. How many does it have? Get the sql statement using: dim sql as string sql = "INSERT INTO tblDNAProfile (dnatestid, dnacategoryid...

Very interesting. Thanks for posting. A few questions. Please answer all of them so we don't have to go back and forth. What exact version of A2019 are you on (see File > Account)? What locale are you in? Is this US-English? What font are you using for your captions? I am surprised to see...

> What's new recently in the experience of several of us is that apparently, clearing a reference to a form instance is no longer sufficient to close that instance That is not my experience. The Northwind 2 Developer Edition has several such forms, e.g. OrderDetails, and there is no DoCmd.Close...

A2007 has been out of support for almost 8 years. There will be no fixes. You will have to upgrade, or live with this.