Search results

Thank you very much MajP, I tried both solutions SELECT * FROM CompletedTasks WHERE (userID, taskID) NOT IN ( SELECT userID, taskID FROM PlannedTasks ) ; and recieved a "exist is missing of the sub selection." error message Then I tried SELECT T_Projets.pr_ID...

In essence query 1 is X and query 2 is Y and try to insert the yellow in a table, my issue is that the key is on 2 columns Should I add a calculated field that concatenate both and use it as a key?

I am looking for a 'not in' on combination of two fields: I should have (from first query) for project 74, 76, etc. and so far I have (from second query) so I need to insert 74 Capacité 74 Complexité 74 Responsabilité sociétale 74 Retour sur investissement 76 Capacité 76 Complexité 76...

Hi, I face a bit of a challenge: I have one table where I score categories by project. Those cateries are active if they are selected in the category table. I would need to make sure that the rating table has a record for each selected category for each project. I have a query to get all...

Hi, Thanks to all for your help. I opted for the save a copy as where the user wanted, that allows him to set filters for his department in the file without having to go through Access and having to set them back every time.

I try but I can't get the dialog box to open for a user nor the file to be saved if I try to save it on my disk. Can you spot anything wrong? (Note that there is only one record, I loop only because I don't know how to go to the first record) Private Sub BI_Attachment_Click() Dim dbs As...

Sorry I did not understand "programatically"...I thought you meant I had to take the file and copy the file on their laptops. So if I have an attachment in table 'T_Reporting' as first and only record called 'Report.pbix', how can I get the user an dialogbox to save it where he wants?

The idea is to have a master file in the database (a report). When a user click a button, he opens the file but he can't save it back in the database...therefore the original file is still in the database, user has a temporary file that he can save on his hard disk if he wants to. When next user...

Disk solution is bad in my case, I would need to overwrite the copy that has to be accessible to an entire corporation with a master each time someone uses it (don't know how to that either)...and worst of all it can't be used by multiple people at the same time. Isn't there a way to easily open...

In the database a devlopper stored an excel as an attachment in a single record table. It is being used to export data for the user and what is perfect is that the user can mess with the exported file, the next user who will want to export will have something working from the orginial...

Hi, I have a table with an attchment and made a form to visualise it. Now I would like to open it as if I double clicked it and pressed open but with a macro on the click event? Any idea how to do that? (It is a Microsoft PowerBI desktop file)