ver2507 bug
I got an Access 2016, it updated itself to version 2507 (build: 19029.20156). Since then I can't use the linked table management interface. I can't refresh linked Excel sheets. The Version 2507 (Build 19029.20136) was still OK, but I can't downgrade my Office 2016. Is there any solution?
Calculating Age In Access
Hi All, Just got a question regarding calculating ages in tables in access. I am on Access 2016, and I have two columns, DOB, and Death Date. I only have one entry for a death date, and if there is not a death date I want to calculate it from today. Would I use a Calculated Field Type? What would I put in it? I found some Vba code, but I don't know how to put that into my table.
MS Access Database Decommissioning
Hi folks, We have the following version of the MS Access Database and we are not sure when MicroSoft is decommissioning this version of MS Access Database. We have the latest version of MicroSoft Application installed as a part of our environment, but the actual MS Access Database is the following for one of the databases. Do we need to update this database called Pontiac to the latest version of database. The database itself is showing Access 2007-2016 file format - Access. Do we need to update this database to the latest version of database. We really appreciate your recommendations. Thank you
Copying and linking Excel tables (landscape mode) to Word (portrait mode)
Hello, I want to insert tables from Excel into a Word document. However, the Word document is in portrait orientation and has a header and footer that need to be located on the narrow side margins of the pages displaying the tables as they would in portrait mode. The tables, on the other hand, are large enough to span across multiple pages in landscape orientation and need to be separated - automatically at best. Ideally, the table would automatically repeat the header row at the top of each new page. Additionally, the inserted Excel table would be linked to the original file, so changes in the .xlsx file would reflect in the table inserted in the Word document. How can I achieve this goal? Here is what I have tried already: section breaks - helps, inserting and linking the table in landscape mode but issues with footer, header and page breaks arise creating an extra text field and rotating the table - no link and therefore no updated data in the table, next to the issue with page breaks In the end I need to insert around 20-30 multi-page long tables in landscape format and would really appreciate avoiding a tremendous amount of work, every time I need to update the data in the tables. If there is more information needed, I´d be happy to share them. Thank you for your assistance!MS Access Forum Web Design Irritation
🙃 Can we take a vote and get a show of hands for how many MS Access Forum users find the little social media bar on the side of the screen not only unnecessary but also an annoying waste of virtual real estate? 😉 Any chance the site admins could reconsider the location of that annoying little intrusion to possibly find someplace else to try and recruit new members to your OTHER social media outlets? 🤣 A wise old saying that so many members of the current human population seem to have forgotten or never learned is, "Just because you can do something, doesn't necessarily mean that you should." If more people understood those words I would not be here right now typing these words... 🤪 LMAO Have a wonderful day everybody!Distinct Count Subquery, MS Access
Need some help in getting a Distinct Count result in this query. For context, i work in healthcare and of course an not share the actual data behind the query. My goal is to modify the current quiery - which returns total charges by account financial class (medicaid, commercial, medicare, sellf pay) and account date within a given month (post date, in the query), but add on a distinct count of hospital accounts in the grouping. Current SQL below, all data lives in the ez_hosp_chg_v. table. End goal is to return a distinct count of the bold/red data point: "HOSP_ACCT_ID" SELECT ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, Sum(ez_hosp_chg_v.ORIG_AMT) AS SumOfORIG_AMT, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID FROM ez_hosp_chg_v GROUP BY ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID HAVING (((ez_hosp_chg_v.POST_DATE) Between [enter start date] And [enter end date])); I've attempted incorporating a subquery like this distinct count example, but can't get the syntax correct in my version: source: https://www.access-programmers.co.uk/forums/threads/count-unique-values-in-a-query.327614/ Any help or pointers are appreciated. -Joe
MS Word Freezing when navigating between Chrome and Word. Safe mode works. now?
Hi All, First, a bit of context. I teach online, so I constantly navigate between MS. Word and Chrome/Firefox. It is pretty much a requirement for what I do. I am running Office 2016 on my home machine. This has worked completely fine until about two weeks ago. Now, after an indiscriminate amount of time (it varies), Word will freeze when I enter back into Word from another window. This has persisted even though I have deleted and reinstalled the program. Safe mode allows me to work within Word per normal, and is a good short term fix. However, I am stumped at how to fix this long term. Additional details Only Word freezes I have plenty of RAM (32gb DDR4) Windows is up to date Chrome is up to date Chrome does not have any extensions enabled I do not have any add-ins enabled for MS Word RAM/CPU usage are not spiking in Task manager Malware/Virus scan has no results It is not related to the computer sleeping/waking up Given all of these factors, it seems like a Word issue only. I do not have the issue in PowerPoint or Excel - just word. My guess is a bad registry entry, or a corrupted file somewhere. What is puzzling to me is that the issue persists through a re-install. Thoughts?
