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
Transitioning From Access To Web Sites
I have a question for the individuals out there that are moving to a web interface from Access What it the best app/program to use to make the move from using Access to using web pages? I've been tasked with converting the Access app that I have been working with for years to make it a web "site", which would be converting the entire application - forms, reports, etc. so that it can be used via web browser instead of MS Access. I am in no means a website developer, but I'm always open to learning new things. Mind you, one of the databases has in excess of 12K lines of VBA. I want to be able to use some of the same techniques as what I've done with VBA and to be able to create a good user experience on the front end plus create some additional enhancements. Al of my searches have not yielded anything helpful. Thanks in advance. JeffMS Access Handling Nulls In Query Formula
Hi all, I have this formula in Access: IIf([Init_Static_P] < 0 And (Nz([Adj_Static_P], -9999) < 0), "Resolved", "Not resolved" which keeps outputting an #Error when Adj_Static_P is null which will happen. I need the nulls in my dataset. Whenever Init_Static_P is < 0 and or Adj_Static_P is < 0, it works as it should outputting "Resolved" and vicer versa, however it does not work whenever there is any instance of Adj_Static_P as a blank value. Does anyone know how I can handle the nulls so that if the Init_Static_P is >0 and Adj_Static_P is null, then it would output "Unresolved", and if Init_Static_P is <0 and Adj_Static_P is null then it would output "Resolved" instead of #Error? Output should be as follows: Init_Static_P Adj_Static_P Result >0 Null "Not resolved" >0 >0 "Not resolved" <0 Null "Resolved" <0 < 0 "Resolved" Thanks in advance! <3
