User Profile
Karl_Donaubauer
MVP
Joined 8 years ago
User Widgets
Recent Discussions
Re: "Access" does not close completely, so the further application must be closed in the task manager
Hi, Just a few remarks: Microsoft® Access® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20106) 32-bit 1. You should not take the version and build info from the "About Access" screen because it does not always show what's really your current build. For this you have to take the information to the right of the "About Access" button on the Account screen. 2. You do not seem to be in a productive channel but in the test channel Current Channel Preview (CCP), right? 3. I checked with the same build in CCP, albeit 64 bit, and cannot reproduce the problem. Maybe we'll have to wait for other reports to see if the bitness or sth else is involved and if it is a common new problem. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK14Views0likes0CommentsRe: Deleted Posts
Hi, I have already heard this from others who said they did purely technical posts that were immediately deleted. The suspicion is that Microsoft may be using AI for cleaning that does not work well. If that is the case, it is difficult for users to take action against it because we do not know what terms or combinations of terms etc. it responds to, and because I do not see a way to appeal against deletions here. Perhaps someone knows of such a possibility in order to get a post back and to help the poor AI to improve. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK39Views0likes2CommentsRe: Access Still Struggles on Data Import
Hi, I agree with you that there have been too many problems with Excel (and text) imports for ages. However, if this meant that the application would soon vanish, it would have done so already for about 25 years. 😉 Concerning improvements for Access, you can find out more e.g. in the Features section of our AFo blog or (a bit less up-to-date) directly from Microsoft. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK42Views0likes0CommentsRe: Application.SaveAsText posible Bug
Hi, It's not a bug but a known limitation. SaveAsText (and LoadFromText) cannot be used for tables. Instead you can use the TransferText method to export (and import) tables as text. See e.g. Colin's description in point 1. (and 2.) here. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK85Views2likes1CommentRe: ACCDB Files wont open in MS Access 2024
Hi, 1. Do you know with which version(s) of Access the files have been upgraded or previously could be opened successfully? 2. If the files are all on the same network drive, you can try to copy them to a local drive (or at least a different one) and test if they can be opened from there. 3. Which version of Windows do you use? Especially if it is Win10, it could be the bad old Leasing bug and you could try to use the workaround to disable Leasing as described in this MS support article. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK63Views0likes0CommentsRe: Help Needed: Trouble Filtering and Re-Entering Data
Hi, My question was about what you technically do to check for or prevent duplicates. Your first screenshot shows that you wrote "Primary Key" as description for the UUID field. In reality, the Primary Key is set to the Autonumber field ID. Is there a unique index also set for the UUID field or is the duplicate check done only in code or wherever? Your other screenshots show a form with an import button. Technically it would be necessary to see the code (or macro) behind the button if it is relevant for the duplicate check. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK27Views0likes1CommentRe: Help Needed: Trouble Filtering and Re-Entering Data
Hi, I've attached what I’ve started so far. I don't see an attachment to your post. Do others? ...currently, it still says the data has already been entered, even after deletion. What do you do to check for duplicates? Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK87Views0likes7CommentsRe: Text cursor misbehaving in Access text field, what causes this and how do I fix it?
Hi, I reported this problem to Microsoft some months ago, but there were surprisingly few user reports about it. Now I've followed up because of your post, and there's at least a chance it will be fixed in the near future. Servus Karl **************** Access Forever, News, DevCon Access-Entwickler-Konferenz AEK95Views0likes0CommentsRe: Text cursor misbehaving in Access text field, what causes this and how do I fix it?
Hi, Access doesn't render the new default font Aptos (Detail) correctly. George already mentioned the workaround. You have to choose a(ny) different font, e.g. Aptos Display (Header) which looks similar and doesn't have this problem. edit: I forgot to mention the other workaround we found out in an AFo discussion last year: It also helps to simply change the font size from the default 11 point to any other size. Servus Karl **************** Access Forever, News, DevCon Access-Entwickler-Konferenz AEK318Views1like2CommentsRe: ACCDE File - Hide Everything
Hi Adrian, What I meant: Where and how do you use this line of code to hide the ribbon? In which object, event, procedure, surrounded by what other code? Because usually, it just works. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK69Views0likes1CommentRe: ACCDE File - Hide Everything
Hi, I want to hide the navigation pane File - Options - Current Database - Navigation - untick Display Navigation Pane DoCmd.ShowToolbar "Ribbon", acToolbarNo does not work. That's strange. Where and when do you use it? Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK76Views0likes3CommentsRe: Tengo una base de datos e Access que contiene una serie de documentos Word y PDF.
¡Hola! Compara las versiones exactas y los números de compilación de Office en ambos ordenadores y comunícanos los datos, o mejor aún, publica aquí capturas de pantalla con esta información. Los encontrarás en Access o Word, en Archivo - Cuenta - en la parte derecha de la pantalla. Si esta comparación confirma la sospecha de que se trata de un problema de actualización, puedes intentar volver a una versión anterior de Office en el ordenador con problemas para ver si eso soluciona el problema. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK36Views1like0CommentsRe: Free Environment for Developers for Dynamics 365
Hi George, BTW I get an elipsis, i.e. three dot menu, on the top right of your reply with the option to report it as SPAM, OT, wrong forum or whatever. I do not get this elipsis for posts that start a thread. That's strange and seems like a bug. Not the only problem of the new forum software here. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK54Views1like0CommentsRe: Access keeps giving syntax error
Hi, It is strange that you would have to use ' instead of ". That shouldn't matter. The comma is even more strange. AFAIK the default for Dutch is semicolon as list separator. If you haven't changed that in the Windows regional settings, then you will have to use the semicolon as separator in every expression in Access including calculated fields: IIf([Testscore1c1]>28;'Plus'; etc. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK80Views0likes1CommentRe: Block users from exporting queries and tables
Hi, George already wrote that there are only limited means if you use an Access backend. > encrypted the back end If you have used a database password for the backend file then there is no "free pass" anymore to the data. A user who tries to connect from Excel to the data in the backend will be asked for the database password. To exclude external intruders you have to close the file chain as described in our beautiful video here. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK88Views0likes0CommentsThe New Access Features in 2025
Hi, Yesterday, I posted two videos on my YouTube channel. They are a short version of the presentation given by the Microsoft Access team at my recent Access DevCon conference. They show a lot of new features they are working on and that are planned for the rest of the year: Breaking Access News - Signing/Monaco/SCC/Charts Breaking Access News - Zooming and Extending Form/Report Size Limits Here is my article with some more explanation: https://www.accessforever.org/post/the-new-access-features-in-2025 Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK656Views2likes0CommentsRe: Access changing lettercase - redux
Hi, Two weeks ago at my DevCon conference Mike Wolfe asked the Microsoft Access team (not for the first time) if they can do anything about it. --> No cure in sight. You can read more about it in his blog post. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK89Views1like0CommentsRe: In form or report design view, cannot paste objects
Hi, In my Clipboard settings there is no option visible to turn on or off Suggested Actions, so I found a registry entry that will turn off the suggested actions. Interesting that you (only) found it in the registry. AFAIK Suggested Actions as a Windows setting is only visible in North America. Where are you located? Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK328Views0likes1CommentRe: In form or report design view, cannot paste objects
Hi, I haven't heard of this problem so far. If you use Windows 11 you could try if it helps to turn off Suggested Actions for the clipboard. See the last section on this support page. Servus Karl **************** Access DevCon April 10+11, 2025 Access Forever News240Views0likes0Comments