PhysioWizard
New member
- Local time
- Today, 08:19
- Joined
- May 16, 2014
- Messages
- 1
I have a sharepoint site that is used for my company. It contains 130 tables (aka "lists"). I have successfully linked those tables in Access to run reports off of. My issue is two-fold:
First, the linked tables do not display the "Name" and "Type" field. I had an issue where the sharepoint defined these as "Multi-field" columns and when I used VBA code to append to table I got a -3025 (?) error. I had to go back and chang them to "Single line" text.
Second, if instead of linking them, I pull them in as static tables, the name and type fields come across fine (great!) but I lose 3 other columns. These 3 columns are present if they are just linked.
We don't have an IT department that can help, and the internet has been less than helpful. After 4 hours of slamming my head against the wall I am hoping that someone else can share their wisdom in this area. I understand VBA to a very limited extent (though I am learning).
Thanks in advance,
Josh
First, the linked tables do not display the "Name" and "Type" field. I had an issue where the sharepoint defined these as "Multi-field" columns and when I used VBA code to append to table I got a -3025 (?) error. I had to go back and chang them to "Single line" text.
Second, if instead of linking them, I pull them in as static tables, the name and type fields come across fine (great!) but I lose 3 other columns. These 3 columns are present if they are just linked.
We don't have an IT department that can help, and the internet has been less than helpful. After 4 hours of slamming my head against the wall I am hoping that someone else can share their wisdom in this area. I understand VBA to a very limited extent (though I am learning).
Thanks in advance,
Josh