Search results

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

Suppose we have a computer with a Windows operating system, which has terminal services active And suppose we also install an http to rdp gateway, for example Myrtille And then using a web browser, it should be possible to connect to an available session on the terminal server Do you think it...

It often happens that you read that for an RDP server there are far greater security problems than for other systems for remotely accessing centralized resources on a single machine So let's suppose that you have your procedure created with Access and it is necessary to allow its use also by...

Suppose we have a continuous form that displays as many rows as there are records in the CUSTOMERS table I can restrict the display to only records using the FILTER property and sort them using ORDER Or I can set an equivalent selection using a sql string complete with selection and sorting...

I have a continuous form created with Access In the record origin there is a query that connects ACCOUNTINGMOVEMENTSTES with ACCOUNTINGMOVEMENTSROW and returns as many rows as there are accounting movement lines included in the current selection Type recordset of the Snapshot form but I also...

Reading the discussion on the possibility of using a Windows 10/11 as a machine to keep the data of an Access program I wondered how to count the open connections between an Access procedure running on PC1 and the db server running on pcX Suppose that pcX runs Window10/11 pro as the operating...

I would like to create a report to display information from 4 distinct sections, Attivita, Passivita, Costi, Ricavi Like this figure Attivita and Passivita must be placed side by side, the first on the left and the second on the right The number of lines present in Attivita is variable, the same...

I would like to create a procedure to automate the compilation of the classic school timetable And so starting from: - list of teachers - list of subjects provided by each teacher (each could teach more than one subject) and weekly quantity (e.g. teacher code 1 teaches mathematics and history...