Search results

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

I'm getting information on Cybele products, in particular on VirtualUI which seems to advertise the possibility of using desktop applications created with Access via the web simply by adding a few lines of code in the forms to be made usable via browser I am aware that there is no magic wand in...

When a new procedure is created or even simply when functionality is added to an existing procedure, the moment of release to the end user is always a critical phase Will I have thoroughly tested the new features? Will I have introduced anomalies on functions that worked correctly before? And so...

In the forum, indications often appear on how to use one method rather than another to perform a certain operation on the data connected to the db Suppose we are in the most generic case, an Access interface that connects to data via odbc driver Where to find a guide that allows you to...

I would like to add a rule in the conditional formatting of some textboxes present on a form, but when I select more than one the 'conditional format' item disappears The question is: using the manual editor (and therefore not via vba) how to change the conditional formatting of several...

Is there a document that describes the default value assumed by an object, declared but never used yet? For example if I run Dim Var1 as string, what value does that variable contain? What if it's a boolean? And an Integer?

I would like to build a procedure to search for reports present in my program but which are never started by any piece of code So the first phase will be to make a list of the available reports, but then how to go through the code both present in the modules and present in the forms to verify...

I have an in-memory Ado recordset that contains four lines of the type Value Code 100.00 1234 200.00 1234 300.00 3456 400.00 5678 I would like to get a recordset so that the 'Value' field is the sum and grouped by Code, and then something like this Value Code 300.00 1234 <- sum of...

I have one form, continuous form, which I use to display data from an Articles table The last two columns of each row are calculated fiel, for example =DLookUp("PRZ";"PREZZI";"cod_art='" & [CODICE_INTERNO] & "' and cod_dep=1 and cod_val=1 and cod_lis=" & cmbCodiceListino1.Value) The problem...

What are the maximum limits of a procedure created with Access? I mean, is there a maximum number of forms? Of Reports? Module? Is there a maximum length of a module? Is there official Microsoft information on the maximum limits for a project created with Access? And do they depend on the...

There are several systems for copying files from one location to another location When there are thousands of small files, however, the difference between one system and another can be sensitive In your opinion, what is the system to copy more quickly a few thousand small files from one...

How to export the data of a linked table, so that it can then be imported and restore the contents of the table itself to the original values? I'm trying to use the various export/import modes that are available via vba code and I'm finding it difficult to restore the contents of the data table...

I'm using a TransferText function to import the data contained within a file, and it basically DoCmd.TransferText acImportDelim, "my_spec", "Items",file_name, True On my_spec there is variables: DateFourDigityear = true DateLeadingZeroes = true DateOrder = false DecimalPoint = ...

I have a continuous form, linked to the data in the db In the form header section there are some textboxes, always connected to some fields of the db table indicated on RecordSource The form initially starts with the property AllowEdit = false, to prevent involuntary modifications by the...

I have a vba routine that adds to the MSYSImexSpecs table some export specifications suitable for the tables I want to export I see that a newly created .accdb file does not contain the MSYSImexSpecs and MSYSImexColumns tables So I assume they are created on the fly when the operator manually...