Forum Widgets
Latest Discussions
Application.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 Contributor139Views0likes3Comments
Mail 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 17, 2025Copper Contributor85Views0likes1Comment
Access 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 Contributor32Views0likes1Comment
Text 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 Contributor304Views0likes7CommentsSort 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, 2025Copper Contributor314Views0likes16CommentsACCDE File - Hide Everything
Hello I have a database for which I want to hide the navigation pane and the menu ribbon (everything) in a ACCDE file. I just want my Home Page Form to open when the link to the app is selected and nothing else is visible. DoCmd.ShowToolbar "Ribbon", acToolbarNo does not work. I have tried a link on one of the previous answers and error 404 came up. Help would be greatly appreciated. Kindest regards AdrianSolvedadriankuchtaJun 04, 2025Copper Contributor313Views0likes16Comments
Read or convert Access 97 DB
Hello I have multiple random Access 97 databases that I need to be able to read or convert. I have scoured the web and not being real successful. Does anyone know of any tools to do this? I don't have an older version of Office / Access to try to pull it in like Office 2007. If there is a legal way to get an older copy of Office I am willing to purchase it. Any help would be appreciated.SolvedDon_Inst_SupportMay 24, 2025Copper Contributor217Views0likes4Comments
Criteria for a query
I have a database containing multiple records, and I want to create a query that allows the user to specify how many times the records should be displayed. This should be done without duplicating the original data preferably using a criteria. Sample: 1 Row Date: 02/16/2025 Code: 123456789 Description: Test But if the user types 2 will show a duplicate row. 2 Rows Date: 02/16/2025 Code: 123456789 Description: Test Date: 02/16/2025 Code: 123456789 Description: TestSolvedFJMSalgueiroApr 15, 2025Copper Contributor93Views0likes3Comments- asmobilevlogApr 04, 2025Copper Contributor127Views2likes3Comments
Trouble identifying 'Primary' phone number
Hi - I'm new...ish to Access. I've used it to cleanup raw data before importing into main SQL db, but have not really 'developed' in it. My SQL is rusty and I've only dabbled with VBA. I'm building a db that has a separate table for 'phonenumber', I'm using a Y/N checkbox with the intent that if the checkbox is checked, then that is the primary phonenumber to use (this is on a continuous form). Since a record can have more than one phonenumber, how do I code it so when someone goes to check an additional checkbox, that it 1)warns them that another phonenumber has already been marked as the primary number (if another one has indeed been checked...if not, then allow the checkbox to be checked), and then 2)if the user wants to change which is the primary phonenumber, then have the update clear the other checkbox and check the current checkbox. Just so you understand, I'm not talking about making the phonenumber the primarykey - I have the primarykey as PhoneID. Thanks in advance for your help! I thought I posted this yesterday but now I can't find it at all so forgive me if this ends up being a duplicate post.Solvedns61Mar 07, 2025Copper Contributor213Views0likes5Comments
Resources
Tags
- access1,677 Topics
- office 365375 Topics
- 2016201 Topics
- developer197 Topics
- Access Web Database103 Topics
- Access Web App57 Topics
- sharepoint53 Topics
- 201352 Topics
- 201042 Topics
- admin42 Topics