Recent content by Ivy

The filter does not filter the date: Record1 with DataProvvedimento 01/05/2007 Record2 with DataProvvedimento 15/05/2007 Record3 with DataProvvedimento 15/04/2006 I search (in DataInizioRicerca) from 14/05/2007 to 18/06/2024 (in DataFineRicerca) but I have always all three records, instead I...

Hi, I need to filter beetween two data for "DataProvvedimento": ([DataInizioRicerca] and [DataFineRicerca]), but it doesn't work: Private Sub ApplicaFiltro_Click() Dim strFilter As String Dim searchValue As String Dim dataInizio As Date Dim dataFine As Date strFilter = ""...

In the meantime, thank you all so much for the replies. For reasons of privacy of employee files (PDFs), which may contain very sensitive data and which can only be seen by the direct colleague who has to deal with that specific employee, and therefore not allow the rest of the sector (other...

Hi, to do this I have to give each attachment (OLE? or normal attachment) its own ID? @The_Doc_Man and @GPGeorge: I know it, but I can't link PDFs directly from folders :( so, I have to find another way

Anyway with Union Query it works:

Personal data and work history, with related PDF attachments. I would like something like this (I did it manually): Or that I manually create the employee list and then try to link the individual employee via employee ID?

Hi, to manage an employee archive I will have to upload many PDFs and I will necessarily have to do it in an "attached" way, so the database will certainly exceed the maximum size of 2GB in a short time. SQL Server and other databases cannot be used. I had therefore thought of splitting the...

Hi, I have created 3 databases: employees1, employees2, employees3. In each database there are exactly the same tables (e.g. personal data table and career table) but with obviously different data. In practice I had thought of creating own database for each employee, and then connecting all to...

Found the problem!!! after hours checking every little thing by comparing the two db.. it was the join property in the query of the form "CarrieraM". Now it works perfectly!! (Traslation of the error message: impossible to find any record in the "TipoCarrieraValoriTbl" table containing...

Thank you very much @MajP! Yes, it seems much simpler to me and above all I would have fewer problems in the future, in case, understanding because something doesn't work in the code. I put your code in my "real" project (with real names, data etc) and it works fine. Only, sorry, can I ask...

Hi arnelgp, I have a little adapted your cascade combobox sample to my project, basically I just removed the Active Y/N condition and it works like a charm, you are great!! However I wanted to ask you for two pieces of information, if it can obviously be done: 1) Does every Relationship...

Hi all, I would like add a cascade combo box to my subfom, but it's in continuous form and I have always error about parameter. It works on second combobox ("ValoriCarrieraIDcmb"), only if I put manually the number of ElencoCarrieraID, for example "8". How can I filter it? Thank you very much

It's ok the form name in caption's main form, I need the name of main name there: And other little problem.. when I add new records, the count records works fine and it's ok, but when I click on other tabs I have all font colors black 😅 Why does the formatting change?

It works to me, I have name of mainform (DipendenteM), from the last attached file of arnelgp:

Thank you thank you thank you very much Arnelgp!! Now it works perfectly! 🥳