Adding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new subform of "2025-2026 Dues". There are forms for the previous years and I can copy them, but I don't know how to get them at the bottom ofthe page I have shown below. Can someone help me?New User - Looking for best option to share Access DB front-end using MS Teams
Office 365 Cloud Based - Sharepoint, MS Teams, MS Access - Windows 11 server (not dev.). I'm building a database in Access to store various document names and their corresponding processing instructions. I would like Team/Channel members to have permission-based access through the Teams app to be able to perform certain actions. At lowest level permissions, access means the ability to use the database through Teams to search for a given document name to retrieve the processing instructions for their level. At the highest permissions level, access means being able to make changes to select tables in the database. They may add/mod/delete the Document Names and the corresponding processing instructions. Can someone please help me with it? I don't want to spend too much time building out the database if it can't be used as an information resource for everyone. I would be grateful for any assistance, including a point toward good information that might help a novice like me to understand how to best accomplish this? All other users on our network (also Team members on my Channel) have the same software that I do, including those designated as Team Owners. Please let me know if any needed information is missing. Thanks in advance for your assistance!! :)
Autofill data
Hey, is there a way to autofill some values in access based on a combination of other fields? Like essentially with VLOOKUP in excel. Specifically, I'm trying to autofill Latitude and Longitude fields based on a combination of Bay (location) and a Waypoint number for where we set nets in a lake. I have a deployment table I'm trying to fill everything in, and the only reason I need Lat & Long in that table vs just having it in the Waypoint table, is sometimes we set nets not along a waypoint and I want to be able to enter those coordinates. Attached are pictures of part of the Deployment form and the Waypoint table
MS Access Email Report
Hi I have a Form that I can email as a report. There is an email address on the report that is automatically used as the 'sent to' address within Outlook. Is it possible to lookup a cc email address that is not on the form and add this to outlook also. I am using linked Sharepoint tables for some of the dropdown inputs on the form, and all data is saved to Sharepoint. I am using the embedded macro function as below. Thanks
