Search results

I'm guessing you want to restrict the number of users connected to the database to the number of licenses. If you follow my post #5, that web service call will return the number of licenses. Then you query the database at startup time as well as from time to time during the session for the...

There is a new blog post here. Apparently, they decided to incorporate in Canada and work the project full-time. I think that's great. Seems to me it's not as big of a project as twinBASIC (going on 4 years), but still substantial. Let's see where they are in 18 months.

What did CoPilot or another AI say when you asked this question? I found it to be quite good at understanding T-SQL.

Would this work: the FE queries the name of the network, and calls your website, where you have a list of approved network names. You could also query for other fairly unique data points, e.g. the SQL Server connection string.

I'm testing your code and I'm getting an Access crash. Using A365-32. Steps to repro (same as post #2): Northwind 2 Dev Edition > Set a breakpoint on line 20 of ProductAvailable. In VBAStack module add the below code. Change the Quantity of a line item of an order and save the record. When you...

Once we have the stack frames, is it possible to get a list of the local variables and their values?

> Tools like ChatGPT and Copilot work best when you know enough to double check their output. Case in point: over the last 2 days I spent about 6 hours with CoPilot fixing and optimizing a set of SQL Server views. They fell in 2 groups, and they disagreed over the Sum of Revenue, and not just...

Welcome! Nice of you to join. Looking forward to your questions. What is D365?

Welcome Paul!

> I watched Designing a Monaco Editor with AI for Access with Ben Sacherich recently That was a REALLY COOL presentation. He is a good speaker, and in this presentation I took away a lot of hints as to how to use AI better. Used that this Sunday to create a WordPress plug-in for my friend's...

Nice work! Looks a bit like my Android phone interface where such overlays are common.

Looking forward to what you have to share. And WELCOME!

Re HKLM: that is true, but it is POSSIBLE that the same key in HKCU will work as well. Test that first. It may also be possible to run the Launcher as Administrator, yet launch msaccess.exe as standard.

@mellamokb: I can understand that you are upset right now and I would be too. This may not be the best timing to say "you are abusing Access in the presence of better alternatives", but I'm saying it anyway, with all due respect. Do I understand correctly: we have a commercial payroll app with...

Cute!

I don't use this connection string to open an ADODB connection, but for the Connect property of a linked Tabledef object. For an OLEDB connection I use OLEDB19 driver from here. The connection string is: Provider=MSOLEDBSQL19;Data Source=[server];Initial Catalog=[database];Integrated...

I always use the ODBC Driver 18 for SQL Server from here. The connection string for Windows Authentication is: "ODBC;DRIVER={ODBC Driver 18 for SQL Server};SERVER=[ServerName];DATABASE=[DatabaseName];Trusted_Connection=Yes;TrustServerCertificate=Yes;Encrypt=Yes"

Select * from tblTransactions where Cleared = False or TransactionDate >= DateSerial(Year(Date), Month(Date), 1);

I downloaded @MajP excellent treeview example from here. I run frmDemo, select "Show Checks", and check the box for Dr. Andrew Fuller. I answer Yes to check the descendants, and then expand the node to see the result (see screenshot). Not all descendants are checked. I believe this is a...

I know one can open a criteria form before opening the report, and pass in WhereCondition that way. As I wrote in #1, "I am interested in exploring THIS version". In THIS version, and as a general practice, I open a modal criteria form in Report_Open. That keeps the two together and I find it...