Search results

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! 🥳

Thank you very much Gasman, now it seems to work without problems 🥳 I thought I had to put the name TabCaption in f.Name, but instead you don't have to put anything, I didn't quite understand but the important is that it works without giving errors. The count of new records doesn't update...

Yes, it's this: But it's only a submask, it isn't in tabs, I don't understand because it causes the error, it has nothing to do with tabs. If I delete that submask, error debug in effect disappears. I don't know, it won't like that submask 😅

Thank you very much Gasman!! 😄 Now count records on tabs works, but I have always error on this code: strCaption = Left$(ctl.Parent.Caption, InStr(ctl.Parent.Caption, "(") - 1) I have added only a ( at the end of every name of tab caption

Hi arnelgp, Sorry, I need your help about count records on Tabs. I have tried your code on my database but I have always error and I don't understand where edit it :( Thank you very much in advance

Hi all, I'm from Italy. I'm trying to learn Access for a project at work: put all the employee files (about 6000 employees) on PC (scan into PDF), using Access as a digital archive. I will succeed? I have no idea..