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. Jeff
MS 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
Sharing and updating an ACCESS database on the cloud
I have implemented an ACCESS database. I would like to store it on the cloud so my colleagues can access it simultaneously. Some of them may be updating some data while others will look for certain records and files being stored within the database. I realize that I should do all my design and coding on my local PC then upload the file on the cloud; however, this central cloud copy of the database file should be accessed and updated while it is on the cloud by multiple users. I am not sure if storing on OneDrive would allow me to do this. I would highly appreciate any experienced developer in this issue.Merging formatted text boxes in MS Access
Hi All, Is what you see in the first image below possible in MS Access? (See first image below, right side!) My goal is to merge multiple formatted text boxes into a single, coherent paragraph while retaining their distinct formatting. The software TLex exquisitely accomplishes this task as you can see. But let's look closer at what's going on. On the left side, you have a data entry box where users can enter: definitions, translations, example sentences, notes, etc. That info is then displayed on the right side of the screen. Notice how the styling, coloring, and formatting are all preserved. The text is not simply compiled into a list! It flows one sentence after the other, forming a coherent paragraph. THAT is what I'm trying to achieve. I did make an attempt. The image below titled "My Version" clearly shows where I fell short. Yes, I maintained the text box formatting, but I was not able to get the text boxes to form a coherent paragraph. I also tried string concatenation, but that method does not preserve any of the text boxes' formatting. So, has MS Access met its match? Can MS Access get text boxes to merge together while preserving the text boxes' individual formatting and form a coherent paragraph? Hopefully, you can help. Look forward to your suggestions. Thanks in advance!
