Forum Widgets
Latest Discussions
Tab header font issue when the "new zoom" feature is enabled
We found a curious font display issue, which can only be reproduced if the "new zoom" feature flag is active: We can reproduce it with build 20026.20076 with the zoom slider visible (e.g. in the "Current Channel (Preview)"), but we cannot reproduce it on the same build with the zoom slider invisible (e.g. on a freshly updated system in the Current Channel, which has not received the staged rollout yet) or with older builds (e.g. the current Monthly Channel build). The problem itself is unrelated to zooming. Repro 1. Create a new Access database. 2. Create a new form in Design View. 3. Add a Tab Control. 4. Set the tab control's "Use Theme" property to "No". 5. Add a button with the following code: Private Sub Command3_Click() Dim start As Double ' Localize the page name, if you use a non-English version of Access Me.Page2.Visible = True ' Simulate long-running operation (3 seconds) start = Timer Do Until Timer > start + 3: Loop End Sub 6. Save and open the form in Form View. 7. Click the button. Expected result: Nothing happens for 3 seconds. Actual result: The tab header's font switches to some old raster system font (MS Sans Serif?). After 3 seconds, the form returns to the 21st century. This issue is easy to work around: just do the long-running operation before setting the Visibility property, this will reduce the font-change to a short flicker. Still, this appears to be an unintended side effect of the changes made for the "new zoom" feature, so I thought it might be helpful to report it while that feature is still being worked on.SolvedHeinziATMay 26, 2026Iron Contributor85Views0likes2CommentsBold Duplicates (Conditional Formatting)
Hello experts I have a form based on qryLCAmends I want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCID here is what I have but it doesnt bold anything: DCount("*","qryLCAmends","[LCID]=" & [LCID] & "[LCNo]='" & [LCNo] & "'")>1 LCNo is text. I am using the "expression" in conditional formatting: Example: How can I do this with conditional formatting?SolvedTony2021Apr 26, 2026Steel Contributor128Views0likes6CommentsODBC error (incorrect syntax) since 2604
Overnight i have the problem that many inserts in my MS Access app do not work anymore. I get the error Run-time error '3155': ODBC--insert on a linked table 'tablename' failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.(#102) I have been able to isolate this issue on a column of type NVARCHAR(MAX). If I insert any value except null in this column the error above will show on save. I tested with other variants of NVARCHAR. The problem happens starting from NVARCHAR(256), thus what is Long Text for Ms Access. When i insert the record first with a value null for this column, no error is generated and the record is saved. If i 'Update' the record later with a text value in this column, that is no problem. So, the ODBC connection generates a sql insert statement that is mallformed in case of a long text. I have this problem consistent on all apps and all tables where i have NVARCHAR(>255). My solution is to go back to office release 2508 (semi annual support).SolvedEzAccessGideonApr 24, 2026Copper Contributor528Views1like2CommentsMove Existing Sharepoint Linked Database to a different Sharepoint Site
Hi. I have a Sharepoint Linked Database that is working well within our company. We would like to use it within another subsidiary company that operates with its own Name and Sharepoint sites. Could you please assist as i am struggling to do this. ThanksSolvedHenryDApr 03, 2026Brass Contributor146Views0likes7CommentsTool to compare object in one database with the same object in another database
I would like to compare a form in a backup database to the same form in my current database. It is very difficult to use the properties to find differences.SolvedelkinskckathyMar 27, 2026Copper Contributor90Views1like2CommentsApplication.SaveAsText posible Bug
I'm discovering the powerful Application.SaveAsText and LoadFromText methods, never used before, and found that Application.SaveAsText acTable,... always produces an Error 2.487: The Object Type argument for the action or method is blank or invalid The method works flawlessly with any other ObjectType. I've tested this behavior in a bare new accdb, with a single table in it, in three different systems (win10 & win11), all yielding the same result. My Access is 365 2508 (32 Bits) May someone check if it is a bug?SolvedJF_RuizSep 09, 2025Brass Contributor235Views0likes3CommentsMail Merge File Open Dialog - File Filter
In Access, when I use the 'Mail Merge Wizard' it opens a standard "File Open Dialog" box where the default "File Filter" only shows basic word documents by default. This default filter does not show Templates [.dot] or Macro Embedded Templates [.dotm] files -- forcing me to then select "All Files" on the file filter box to reveal my [.dotm] files. Is there any way to add templates such as [.dotm] files to the default file filter selection? It is a minor issue, but it would be nice to see my [.dotm] files by default instead of having to adjust the "File Filter" every time to "All Files" just to show the [.dotm] templates that I want to use for the merge.SolvedTrentPhxAug 16, 2025Copper Contributor129Views0likes1CommentAccess Não Copia Objetos
Faz um bom tempo, mesmo antes da atualização do Windows 24H2, o meu access vem se comportando de forma estranha ao copiar objetos. EU uso a versão do Access 365 de 32bits, porém já testei na versão 365 de 64bits e o problema acontece da mesma forma. O que ocorre, ao copiar alguns objetos, o Access simplesmente ignora a cópia, seja com Ctrl + C ou através do menu suspenso. Por exemplo, se eu quiser copiar uma linha, muito raramente ele copia, mas na maioria das vezes não copia, se eu quiser copiar vários objetos de uma vez, a mesma coisa, as vezes copia, mas na maioria das vezes não, tanto que tenho que copiar objeto por objeto, por exemplo, se tenho duas caixas de texto, tenho que copiar a uma de cada vez. No caso da linha é pior porque mesmo havendo uma linha selecionada, ele não copia, preciso criar a linha novamente e isso atrapalha bastante o desenvolvimento. Note que textos sempre é copiado e colado sem problemas, e fora do access qualquer coisa que copio funciona normalmente, arquivos, pastas etc. Alguém já se deparou com esse problema? Segue minha configuração: Windows 11 Pró Placa-mãe: ASUS B550M Processador (CPU): AMD Ryzen 5 5600 Placa de vídeo (GPU): AMD Radeon RX 580 8GB Memória RAM: 32GB Armazenamento: SSDSolvedRicardoball2409Aug 08, 2025Copper Contributor70Views0likes1CommentText cursor misbehaving in Access text field, what causes this and how do I fix it?
Steps to reproduce: create a data-bound form with textboxes showing text field values. Place the cursor in a textbox. Type. In my Microsoft Access 2016 accdb, I have a form with textboxes showing table field values. When I click on any of these text boxes, the blinking text input cursor appears in the text box more or less as expected, but with an offset that grows as it moves further to the right. What I mean by offset is that the cursor is shown in a certain place, but entering/deleting text happens a bit further to the left. With the cursor all the way at the beginning of the textbox, editing happens right there. But at the other extreme, if I hit End, the cursor is shown some 5-10% behind the text in the field. Moving a position to the left with the left cursor key, the cursor is still some distance behind the displayed text, but entering text happens before the final character. And when I click somewhere in the middle of the text, the cursor can even display in the middle of a character, and editing always happens a bit to the left of the cursor. It's as if the text is scaled at 95% for display, relative to the (invisible) text for cursor positioning. Interestingly, I took a look in my tables, and the behaviour in text fields in the tables is exactly the same. I've found reports of this elsewhere, but none of the causes and solutions apply here. There are no special characters (tabs or otherwise) in these text fields. There is no code in the Change event. There is no timer running. I suspect it's a scaling issue somehow, but I can't find any explanations or solutions anywhere. And the issue makes editing the text data near-impossible. I've resorted to copying the text to Notepad, editing there, and pasting it back.SolvedflorismkleijneAug 01, 2025Brass Contributor1KViews0likes7CommentsSort in Query not Displaying
I have no clue how to word this. Basically, in a form I have a field called Members. This field is a drop down menu that lists all of the Members for a meeting via check boxes. I can then tick the checkboxes for the people who attended the meeting, click 'ok', and then when when I run the report, their names will appear. I don't need this information saved; just to display on the report so I can print it. Here's my problem. Not all of the members can vote, so I want the members who can vote listed first, and the rest of the members listed next. I've put in my custom sort formula in the Members query. When I open my Members dropdown box, they are listed exactly the way I want. However, as soon as I tick on the names and then click 'ok,' it's displayed in order of the primary key. When I run the report, the names are still sorted by the primary key. I've gone to every query and table I can find to create my custom sort, but it keeps defaulting to sorting by the primary key. It's driving me INSANE. Any idea why it's doing this? I've dug through google and haven't had luck finding an answer that works. Thanks in advance!SolvednicoleethierJun 24, 2025Brass Contributor574Views0likes16Comments
Tags
- access1,712 Topics
- office 365396 Topics
- 2016205 Topics
- developer199 Topics
- Access Web Database104 Topics
- Access Web App60 Topics
- sharepoint55 Topics
- 201354 Topics
- admin46 Topics
- 201044 Topics