Search results

Amazing- thank you that worked a treat! LizzyJ

Doing that gives me a run time error when I go back to the Form View. when I click debug it takes me back to the code and highlights to code you gave me. Any ides?

Please see attached screen shot- I don't think I am putting it in the right place. Sorry new to this. Any help much appreciated. LizzyJ

Hi, I have created a form that details information about a user and has various subforms. What I would like though is the change the header which currently just has a standard caption in it (which I currently have as 'User Form') to display two of the fields from within the form (namely...

thank you for all the help. Have decided to simplify slightly for now in order to get it built quicker but I might take a look at all of the above in the future. Thank you to plog for the initial advice that solved the original problem! LizzyJ

Plog- it is not as simple as that. To gain access to the subfolder the user might need to be in two different groups (one to get into the root folder and a different one to get into the subfolder). Whilst there might still be multiple groups that COULD give access. The_Doc_Man- thank you for...

Yes I could list all the folders pathways as root folder but that is not ideal. Ideally I want to list the root folders and then the subfolders separately where needed. And the complication comes when (taking your example) Group 1 has access to Folder A and Group 2 has access to Sub 1. If Joe...

OK, that has worked to display the access information. And I have designed a form for adding a user that can also add them to the groups so that is ideal. I now want to complicate things slightly with subfolders. There are some root folders that contain subfolders with further restriction...

Thanks all. I will have a go with the junction tables and see if I can create the report I need to pull the information back out (either 'who has access to this folder' or 'what folders does this person have access to'). It looks like there is no way to simply create a user and multi select...

Hi, I have been trying to design an Access 2013 desktop database to report on user access to shared folders within the company I work for. Acess to folders is granted by users being added to a permission group and groups being added to folders. What I want is to be able to query the data and...