Search results

I thought the claim being made (in #10) was that multi-instance forms could be supported without a Public Collection or similar to hold the form references. Maybe I read that wrong.

No objection.

The demo has 3 identical tables, one curiously named Employees. Can you shed more light on this?

Yes that is correct. Fortunately, that is a problem you can ignore, since you are upgrading.

In #1 you wrote: "need to be migrated to accdb" So do that, and make sure you have the 4 standard references in their normal order (create a new db to be sure), and remove the DAO 3.6 reference.

You may also want to consider SQL Server for the BE. Opens up new capabilities, in addition to a more stable and secure BE.

It's a great time to think about new features. Often as a beginner we can present the data, but are not yet thinking much about what to do with it. For example, are there alerts about quotes that are past due? Orders that are stuck in the process? Can quotes be copied from a template or a...

I typically create a new VBA module with procedures that perform the conversion. There is a Main procedure that calls the others in sequence. It is designed to be able to run multiple times as you perfect the conversion more and more. It starts with "Clear out most new tables". Some are just...

I use unbound controls as well. In Form_Open: Me.TimerInterval = 1. This starts a timer. The form will continue to open. Form_Timer happens after the form is open and visible. In that event I stop the timer Me.TimerInterval = 0, and then call RefreshKPI procedure. It calls a stored procedure in...

Welcome! Are you inside or outside that large building in town? :)

Options?? What is the ID field that ties the child records to the parent record? Can you show a screenshot of the relevant tables laid out in the Relationships diagram?

Your screenshot in #1 is showing 1.08 GB/s. The "B" stands for Byte. Your #1 message seems to convey disappointment that "7 gigabits" speed only results in this 1.08 GB speed. I tried to point out the two are (almost) equivalent.

Are you confusing bits and bytes?

Job security: if the people upstairs ever define a new exam period, I will need to update and test all related queries, and who knows what else...

SQL Server has system views you can query to get all kinds of information about the structure of the database, including: select * from sys.foreign_keys fk inner join sys.foreign_key_columns fkc on fk.object_id = fkc.constraint_object_id You may want to additionally join this with...

Maybe because of the new-ish TrustServerCertificate clause.

Somebody should say that to my apps, which use ODBC 18. A typical connection string: ODBC;Description=xxx;DRIVER=ODBC Driver 18 for SQL Server;SERVER=.\SQL2022;Trusted_Connection=Yes;APP=Microsoft Office;DATABASE=yyy;TrustServerCertificate=Yes;

Who is the author of this Access,Azure,Performance.pdf document?

> using an ODBC connection in MS Access exposes passwords Not if you use this tip: https://www.microsoft.com/en-us/microsoft-365/blog/2011/04/08/power-tip-improve-the-security-of-database-connections/ With an Azure BE, you cannot program as-if you are on a LAN with an OnPrem SQL Server. The...

I am clicking around in your TV but am not seeing the error. Can you provide exact steps?