I have a MS Access form with a Datasheet subform. Using code, I change the ColumnHidden property of various of its columns. But, when I close the form, I'm asked whether to save the table layout of the Datasheet's table. How can I stop the form from asking the user to same the table layout continually? Do I have no choice but to change...
I've added a lookup field to a document library, and it is possible to choose values as expected in "Edit properties" for a single document. However, when in Edit in Datasheet mode all of the dropdowns for the lookup field are EMPTY!!!! Is this just the way it is, or have I done something wrong? Has anyone managed to get lookup fields t...
I can see columns that list people names in SharePoint's datasheet view, but read-only users cannot. Is there a way for read-only users to see columns of this type? The type of information in this column is: Person or Group, no mandatory information, allow multiple selections, People only, choose from All users, show field - name with p...
Hi, Has anyone discovered a way to extend or modify the functionality of the SharePoint Datasheet view (the view used when you edit a list in Datasheet mode, the one that looks like a basic Excel worksheet)? I need to do several things to it, if possible, but I have yet to find a decent non-hackish way to change any functionality in it...
Hi, This is probably very basic stuff, but please bear in mind I am completely new to these things. I am working on a procedure for my Access datasheet forms that will: Adjust the width of each column to fit content Sum the total width of all columns and subtract it from the size of the window's width Adjust the width of one of the c...
Hi Experts, I am importing data from Excel into Sharepoint list using "Datasheet view". When i paste the data, I get error message "Cell is read only." for readonly fields. Is there a way to import data into readonly fields. Thanks ...
In ms-access 2007, i'm trying to make a form for a table. this table has foreign keys from 2 parent tables. so i thought i would make these fields a lookup. but i couldn't create a single lookup for each parent table because they are composite keys. I decided to create a query in which for each of these parent tables and the child table...