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

+2 per RecordSource 0 per Filter+Order

Up to this moment the answers seem oriented towards demonstrating the superiority of the RecordSource loaded with a complete sql string compared to the simple table/query inside the RecordSource and the use of the Filter + Order property

ok, +1 per RecordSource and Sql String

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

Mistake, i have hand write the row

Numeric

No, TAXABLE is the name of a db field, from query

Thanks for the suggestion But I've already tried =Val(Dsum([TAXABLE];filter)&"") Same #Error result in txtTotTaxable What I really don't understand is why it works on the Documents form and it doesn't work on the Accounting form, and they are practically the same, except for table and filed name

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

Ok but the problem is "user connection" exactly does it indicate a connection to the Windows "file sharing" system or any other connection? For example, if on pcX, the machine where the db server is physically run, I had a MySQL with port 3306 open and available to accept 'connections' from...

Very interesting code Ok but I can use this code on the client side and see how many connections are activated from the single workstation Wanting to see the server-side connections, those generated by all the workstations, and therefore on the PCX what contains the server db, is there a way to...

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 didn't use this tip because moving the subreports to detail already worked as required But this tip is particularly interesting and I will definitely use it in other contexts Thank you

It was sufficient to move the subreports to the detail section and now the desired effect has been obtained Thank you very much

For anyone who has the patience to help me, I attach a file with an example of the report I am trying to prepare

Sorry but I don't understand I have to prepare a report where the information can be displayed Why do you write about forms and two suforms?

Ah ok, In my case I have a report that I will call rptBilancio, and in the PageHeader section I have dragged two subreports, the first rptAttivita and the second rptPassivita

This is a 'normal' report But with this system I can't have two sections side by side See this example in the Attivita and Passivita section

What do you mean by 'container control'? I'm experimenting by inserting a subreport inside the Page Header section, I'm not using any 'container controls' As regards side-by-side reports, the norm is that they have different numbers of records, and therefore the Attivita section will have 10...