Search results

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

I can think of the set of actors that might change for each season.

> Older versions of Access closed the form when you press End. Not necessarily. That may depend on which event the error occurred in (the cancellable Form_Open perhaps?), if there is an error handler in place (your code apparently did not have one), and possibly other factors like if the form...

This is a screenshot from the Northwind 2 Dev Edition, Product form. I don't see the issue you're raising, but because of the tight cropping there is not much difference between a right aligned and a center aligned tab. Post your screenshot, please.

I foresee problems. User1 opens the shared FE and relinks the tables with ODBC13. User2 opens it and relinks with ODBC18. What will happen to User1? Bite the bullet, and give every user their own FE, per best practices. If you look around, there are several tools / scripts available to keep the...

No, it is an RGB value, long integer. There are a few defined constants like vbYellow, but otherwise you need to cobble a color together yourself. There is a color selector for the color properties.

Yes you can, in a Standard Module you can write: Public g_db as dao.database 'g_ prefix for global objects and then set it in your startup code. I do this in my code. For recordsets it can be more tricky because you may sometimes want to keep them open for more than the current procedure, but...

Are you saying ACCDR does not require Trusted Location?

We know nothing about your company (a common line of business, or a unique one?), your hierarchy (e.g. where are you placed in the org chart, and where is the asker?), your equipment (is it connected to your app), the strengths and weaknesses of your app. So giving advice is perilous. In your...

In Access we don't have Float data type, but Double is the equivalent. The VBA.Round function takes any "Numeric expression", per this documentation. That means my "real" data type is supported.