Search results

Which is the best way to select rows in the current recordset? How do you filter the recordset to display on a form/report? Are there any specific reasons for using the first or second method? Personally, I almost always tend to use SQL string selections, which are then passed in their entirety...

In my case, the offending library was the last one (the first four aren't visible in the list, but they're there; the cursor is at the bottom to show the missing library) And no function contained in it was ever called from code But even in this case, and therefore regardless of the loading...

That's exactly how it is :ROFLMAO:

I'm referring to a problem I recently encountered Discussing with some colleagues, it seems that the lack of any external references impacts the correct functionality of date-related functions Does anyone know the reason for this strange effect?

In fact, even with the Erp2_Function1 library loaded, everything works correctly now. I forgot to register the DLL file. :mad:

I've used CR from version 5.0 onward on projects created with Visual Basic 6.0. Even recently, when it entered the SAP umbrella, I used version 2020 to print reports and allow the end user to edit them independently In my opinion, it's an excellent tool, superior to Access's native reports

Thank you for generously sharing an enviable experience It should be noted, however, that it's still unclear why using that library breaks everything It seems harmless.

Bingo !!! The difference between program 1 and program 2, besides some changes to the 'articles' form, was that in program 2 I added a reference to a DLL I wrote using TwinBasic just to do some experiments and understand how it worked. The DLL code is this: Public Class MyClass Public Function...

That's correct. Since it's a particularly strange problem, I set up a virtual machine with a clean Windows 10 and installed the entire package with just the runtime. And the problem with program2 persists. While with program1, everything works correctly. Then I installed the full Access, and...

Then, to avoid ambiguity, what is the better way?

Right, I hadn't thought of that. It might work. I'll test it as soon as possible.

Yes, program1 and program2 link tables from the same DNS and therefore from the same database. The REGISTRATION_DATE field is a timestamp, and both program1 and program2 see it as a timestamp. What do you mean by 'explicitly relink' the tables?

Yes, of course I could do that. I simply should modify the dateSQL function and make it return the date exactly as passed The point is: the system has worked this way for years, for dozens of different versions Why should it work differently now? But above all, why does program1.accde still work...

This is truly incredible (at least for me). Program1.accde becomes program2.accde after some changes to the 'articles' form. Both program1 and program2 work correctly on the development PC, with Win10 with Access 2013 32bit Let's move to user PC2, a Win10 pro pc, where only the Access runtime...

Simple and effective But if the program were transformed into mde/accde and the debug.print files were eliminated, could there be any benefit?

He didn't ask how to turn on the phone with Maui, but how to read an mdb/accdb file from an app on the phone And the discussion is far from stupid, but it's very interesting for all Access users who have a smartphone

No He asked how to read an Access data file Not how to run Access on his phone.

Don't make up things I didn't write ("..you think the Jew....") Regarding the hostages, it doesn't seem like a priority for the current Israeli leaders The clear primary objective is to annihilate the Palestinian population and occupy the territories, Palestinian territories

Yes, okay, you're excused

You're not the one who has to think about how the system should be set up The colleague asked some questions; if you know the answer, you can help him Otherwise, save the ink