User Profile
Karl_Donaubauer
MVP
Joined Mar 14, 2018
User Widgets
Recent Discussions
Re: Access SQL Syntax Highlighting, Autocomplete, and Formatting
Hi, The usual reason why you don't see the Monaco checkbox in the options of Access 365 are the security settings. You either have to put the database in a Trusted Location or make it a Trusted Document or enable all macros to make the Monaco option visible. All these settings can be done in the Trust Center. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK98Views0likes0CommentsRe: How do I reference query data from an Access Macro
Hi, You can use the DCount function in your macro to get the number of returned records of the query, like this: If DCount("*","YourQueryNameHere")=0 Then [some action here] Non zero would of course be: >0 Depending on your regional settings, i.e. the Windows list separator, you may have to use the semicolon instead of the comma as separator in the DCount function. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK45Views0likes0CommentsRe: You must start microsoft access by double click
Hi, George already wrote that this is the Runtime version of Access. To determine what type of M365 trial you have and if the full version of Access should be included, you can open any Office application like Word, Excel etc., go to File - Account and post a screenshot with the product name, version info etc. Servus Karl **************** Access Forever News DevCon Access-Entwickler-Konferenz AEK67Views0likes0CommentsRe: "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 AEK53Views0likes0CommentsRe: 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 AEK60Views0likes2CommentsRe: 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 AEK58Views0likes0CommentsRe: 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 AEK107Views2likes1CommentRe: 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 AEK76Views0likes0CommentsRe: 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 AEK34Views0likes1CommentRe: 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 AEK123Views0likes7CommentsRe: 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 AEK153Views0likes0CommentsRe: 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 AEK518Views1like2CommentsRe: 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 AEK90Views0likes1CommentRe: 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 AEK85Views0likes3CommentsRe: 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 AEK41Views1like0CommentsRe: 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 AEK65Views1like0CommentsRe: 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 AEK88Views0likes1CommentRe: 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 AEK96Views0likes0Comments