Search results

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...

Happy Friday! Please see the attached mock-up database I made to demonstrate the issue I am having. You will see that the Main form's On Current code seems to work once the form is immediately loaded, or the view switched back to Form View, but once you toggle the main form's records forward...

Thanks for the response! I am attempting to try your code out, but the "IF CtrlHeight < YourMaxHeightHere" line is red in VBA and gives me a Compile Error (Expected: Then or GoTo). Is the code missing something? Also, just to confirm, I am replacing "YourMaxHeightHere" with my max height #...

Thanks very much for the response and for the attachment share! I swapped out my code for the code in the attachment (updating the subform name, of course) but now my subform is only ever the size of the header row and one row of record data. It's almost as if there is no count of records...

Thank you so much for the example, but I am struggling to make it work for me. To clarify my intentions, I have a form with a subform that will display related records via a parent/child relationship. Every time a user toggles between records on the main form, I want the subform height to...

Thanks for the response! I am a noob and found my code online. How would I implement your suggestions? Are these settings in the Property Sheet for my subform or would I have to add more VBA code?