Recent content by diamondDog

I don't believe you can specify which list fields can be edited based on permission group. Permissions granted to a person extend to all the list fields. It would be very ideal to set up different Access forms for different user groups so that certain forms are locked on a given form.

As I understand it, for a user to be able to create/edit a linked SharePoint list record through an Access form, they would need to have Contribute-level access on that SharePoint site list. If this is true, is there a way to grant users this SharePoint list access on the SharePoint site but...

I am rather novice, so please forgive any obliviousness. I am aware that you can directly link a SharePoint list to Access so user input in an Access form directly updates/adds data to the connected SharePoint list, but there is a lot more that needs to be worked through in my Acccess Databse...

Thanks again for the insightful exchange. With your advice in mind, I might have another approach that could work well enough for the problematic 5%. I can move the subform back into the header to prevent the scrolling issue and, when the 5%-chance scenario occurs where there are 40-50 records...

Thank you for your thoughtful suggestions! Well, the side-by-side approach won't work well because the subform record set has many columns--I am building an alternative to a current process that has users constantly scrolling left and right on an Excel spreadsheet to view data while working (I...

Unfortunately, the records are rather long, and I really want the entirety on screen without having to horizontally scroll back and forth so that all values are easily visible, so putting the subform to the side won't help. I originally started with this subform in the header, but since there...

The main takeaway point is that, regardless to where the subform is, a 50-record subform that disables the ability to use the scroll wheel is a real annoyance. Whether the subform is at the bottom or the top, it's not good when the user needs to scroll to another area on the form.

That's a very valid concern but the nature of the parent/child relationship is that subform records won't exceed about 50 in count. I don't mind if the verticality of the main form grows. I have user fields above and below the continuous subform; regardless the size of the subform, the user...

I am a total noob, but I've got big ideas! Would it be possible to have VBA send mock records to a SharePoint list that sends the email that I need for those records? Haha. Like, the SharePoint list would only be there and require one or two columns worth of record data--just enough to...

My subform dynamically changes height based on its record count, and so it never has or requires any scroll bars of its own, but it's rather jarring when a user cannot scroll the main form height when their cursor happens to be atop the subform. This always happens, regardless if there are two...

Good day to you, once again, solver of problems. I have another form that I want to use this tech on, but the records are occasionally so many that the header takes up the whole form from the subfrom record count and the user has hardly any room to fill out the main form details section. Is...

YES!! Wow! This is so great! Thank you so much! There is much I can learn from your code and from your kindness!

Oh wow, it works beautifully! Top-notch job!! Thank you!! Does the table relationship improve performance speed? You have already done so much to help me, but since you are very familiar with your code, might I trouble you for a functional and aesthetic addition? I wanted the subform within...

Thank you again for your help, but I was not able to get the code to work. I uploaded Thank you for the reply. I tried your suggestion but it did not work. I have uploaded a copy of a database, in an above response to someone else, to demonstrate how the code does not work properly. You...

Thank you for the reply. I tried your suggestion but it did not work. I have uploaded a copy of a database, in an above response to someone else, to demonstrate how the code does not work properly. You will see that the Main form's On Current code seems to work once the form is immediately...