Database in an "inconsistent state" and other errors
Hello. I was directed here for help by Microsoft Tech Support because the problem is "file specific" and not at the app level. I am not computer savvy and have never used a forum like this. Tech support just kind of dumped me here and said "have at it," so any guidance, help, etc. would be appreciated. I use Microsoft Office 365 as a personal/individual subscriber and my Access program started issuing error message over the past week. The biggest concern and problem is around db called Comic Books and I've attached the error message. When I click OK, it attempts to repair, fails and issues the second message. Another database--an earlier copy of Comic Books from mid December-- opens OK, but has its own problems, such as when I attempt to simply copy a table (see third error message). I don't know if these are related. Can anyone help me? Is there any hope for me ever regaining access to the Comic Books database which was last accessible and working on January 4? Thank you.
Em Dash short cut not working in Word
I am using Windows 11 Pro on my Lenovo P14 laptop, and Windows 11 on my HP Pavillion x360. I often write in Word and insert Em dashes. CTRL+ALT+"-" (shortcut). Both machines have this setting automatically in Word's built-in shortcuts, however the Lenovo machine ignores the shortcut sequence and inserts nothing (the HP works fine). I have reinstalled the OS and Office Pro 16 MS Word on Lenovo, and nothing helps. Any suggestions?
How do I reference query data from an Access Macro
I have a simple Select query that returns a number of records. In my Access macro (just for clarification, I do mean Access Macro and not VBA) I want to check how many records the query returns in an IF statement. In this specific case the check would be on zero returned records, but being able to check non-zero in the future might be useful. I have tried various internet searches but the only results I found relate to VBA. Suggestions on how to do this check would be appreciated. Thank You
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!
