Search results

  1. D

    Linked SharePoint list. Is it possible to grant users contribute permissions on the SP site, but password protect the SP list URL itself from users?

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

    Trying to append records to a SharePoint list. Getting "set 1 field(s) to Null due to a type conversion failure." Can query redefine type?

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

    So I just learned that my employer blocks the .Send functionality of any attempt at sending a VBA email, but I know our SharePoint can send email ...

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

    My mouse wheel cannot scroll the height of my form when my cursor is atop my continuous subform. Can I always have main form vertical scroll control?

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

    Solved I use VBA to adjust the height of a continuous subform based on # of records, but my subform only adjusts to show up to 3 at a time w/ scrollbar

    How can I have my continuous form always expand to see all records instead of having a scroll wheel? The following code seems to work well when I have up to three records, but any more than three records and the subform no longer grows but only displays a vertical scroll bar. How can I...
  6. D

    How do I set up sequential numbering in one field of a table for each alike value in another field? I want to have this applied in a query.

    I have one table that gets a number of records imported into it several times a month. There are two fields I am trying to establish query programming for that will likely have to reference some VBA. I am a bit of an Access noob who sometimes has a hard time grasping how to cobble things...
Back
Top Bottom