Search results

I have a project created with Access 2013, 32-bit I normally use this procedure to export the entire project to a text file and archive it (VCS_ImportExport.bas / ExportAllSource) After the last export, I also followed the reverse procedure, and then tried recreating the project from the newly...

Using Visual Studio, you can appreciate the ability of external extensions like Gemini Code Assist to support developers in creating new code fragments useful for the current project. For all non-specialized tasks that require specific optimization, the assistant is an excellent tool and allows...

https://www.tomshw.it/hardware/piattaforma-ai-cancella-database-aziendale-per-errore-2025-07-21 ...Its automated system deleted an entire company database containing thousands of records, then attempted to cover up the incident with what many called "dishonest behavior." ... It's learning to...

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

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?

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

Normallly, using this code, ALL pc ip addresses are returned But wanting to know exactly the address of the wired or wireless network card that pc is using, how to do? I ask this beacuae if the pc has two lan ports on the motherboard, a wifi card, and a virtual lan like those installed by...

I have a report that needs to display rows composed of a DARE field and a AVERE field, and a third field that I will call SALDO that contains the difference between DARE and AVERE added to the SALDO field of the previous row A basic example is attached There are global variables for the report...

Let's suppose we have the classic management software to make sales documents, accounting, warehouse, e-commerce, etc... Different 'sections' each with a specific macro task, each section composed of different forms, reports, modules And let's suppose we want to provide gigi with the version...

I have a procedure created with Access 2013 ver 32bit that runs on Windows 10 pro It uses data present on Firebird 3.0 and the tables are connected via odbc using the odbc driver version 2.0.3.154 Everything works correctly I pass the same project on a Windows 11, Access same version, Firebird...

I have a procedure for administration and therefore the usual screens for articles, prices, invoices, etc. Some search forms can be launched from different forms, for example the form frmArticoliCerca can be launched both from frmFatture and from frmArticoli and from frmClienti I do not know in...

Sometimes it happens that an Access procedure is busy for a long time For example, when I export a project of hundreds of forms and reports, using the Vcs procedures, the sequence of operations lasts over ten minutes I'm talking about code that is executed and databases locally, and therefore...

In order to implement effective error handling, it would be useful if from code you could read the name of the sub/function inside which the code is running A sort of Me.name for forms Then the question is: how to read, via vba, the name of the function/sub inside which the code is running?

One of the most important features in the new version of Access is the Sql editor Monaco I tried to use it, but I can't fully appreciate the improvements made For those who have already had the opportunity to use it, I would like to ask: exactly, why use the new Sql editor?

Sometimes these are projects with a few dozen forms, tables, and some code modules But sometimes we are faced with projects that have hundreds of forms, hundreds of reports, dozens of modules even with a lot of code, and in this case we often get close to the limits of the Access environment...

I have a computer that we will call PC1 that installs Windows 2022 server as the operating system The terminal server service has been activated on this PC There are 10 different users on PC1, user1, user2, user3, ... In the directory C:\PUBLIC\ERP2\BIN there is the ERP2.ACCDE file created with...

Suppose we have a server database and many workstations each with its own copy of the Access procedures In this situation it is not possible to use the laccdb file because each workstation will have its own How to detect (from any workstation) which workstations have the Access program running...

I need your help with a problem that sometimes comes up A form with some comboboxes and other objects Inside the RowSource property of the combos are linked to the underlying db Some combos behave strangely in the sense that if I type in a value that is definitely present among the lines...

Have any of you already 'got your hands' on the available versions or have you done any experiments? Searching for information and using the little word 'database' you can't find much What do you think?

How to implement a generic functionality limitation system for some users of the Access procedure? Let me explain, let's suppose that the access to the Access procedure is granted to users user1, user2, user3 Suppose you want to allow the user user1 to do everything, the user2 to do everything...