NOW ON DEMAND | Two Copilot and M365 for SMB Community offerings (Webinar and AMA)
We’ve got two upcoming public events for you. We’re ready to share, show, and engage! We got news, announcements, insights into using Microsoft Lists, and set to answer a lot of questions across Copilot, Teams, SharePoint, and more.
Problems with transfer of Emails from MS Access to Sharepoint Lists
I have a real issue, I just cannot solve. I try to export a Microsoft Access Database to SharePoint. However, exporting is not possible because of Email addresses included in a table (the datatyp of the field is link). The error is always: "Cannot send to server. The URL is either not valid or longer than 255 characters". If I directly enter an email address in sharepoint, I have no problem. I would appreciate any support, feedback, hint, as to how I can get my list of email adresses from MS Access to SharePoint. Many thanks mahu01
Cell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you J
Keeping Access files on a SharePoint site??
Hello: I work as a research scientist and I keep a substantial amount of data in Access databases. I use both a virtual machine and a laptop to work with those databases. Using the VM is helpful because I can disconnect my laptop from my employer’s network without disrupting a long-running job. Because I use two machines I would like to keep them in one network location so that both machines are able to access (no pun) my databases. Keeping them in one spot will save me from wondering which file is the most current. I learned the hard way to never store Access databases in a location that synchronizes (such as Offline Files or OneDrive), because the database will be damaged if synchronization occurs while I have the file open. I have seen “hints” that it might be OK to store an Access database on a SharePoint site without the database becoming corrupt. Is this correct, and do I need to “check out” the database so that the other machine cannot open it? My network is slow, so I likely will have to download the Access file from SharePoint to work with it. Access Web Services are not available, and I do not want to use SharePoint lists because (as I understand it) SharePoint lists do not: support unique composite keys; the difficulty transferring Access tables to lists; the learning curve. Any suggestions or thoughts? Thanks in advance.Drop Down List - Linking Corresponding Data in Separate Columns Based on Drop Down Selection
Hey there! I'm looking for a clear cut way to do something which seems like it should be simple. I have two columns that I want to correspond with one another. What I'm looking to do is when someone selects an option "Status" from the drop-down list in Column D the adjacent cell in column E populates with a corresponding percentage value. Ex. --> Cell 'D6' / "Sales Status" Drop Down Selection = Verbal Commitment ::: Needing Cell 'E6' to auto-populate once selected with the corresponding percentage "100%" I've built a drop down list for each column in a data worksheet. Am I doing this correctly? I've attached a screenshot of the columns I need populated as well as my lists in case that helps. Thanks!
