Recovering a VBA protect password
I wrote a database in 2009/2010 in 2007. I migrated it to 2010, changed it to an accdb and password protected the VBA. In 2017, I left the company, handed over all of my passwords, and left my code in another's hands. In Sept 2021, they asked me to please come back, I did, and the password to the DB I am trying to recover was lost. I have tried using HxD, which doesn't work with accdb. How can I recover the password?
Reading data from a scale via serial port
Hello all I am trying to find some way to write data coming from a scale, device that reads weights, into a data field for an already created form. The scale would be connected to a computer via a serial port. User open up the form with fields filled in by the user, the form references a unique id (that was inserted by the user), that unique id is used to pull the correct weight data from the scale and populate onto the form. I have read that I need to create an application via VBA using MSCom but I dont see them connecting VBA application with Access form. Any help would be appreciated.MS forms 2.0 being disabled after windows updates on Win 10.
After installing one of the many Windows Update On Windows 10 controls on Microsoft Forms 2.0 are disabled and ActiveX control is disabled. Error message 2926 points to settings in the Local security Policy. Please help me enable control and ActiveX MS Forms 2.0 because I lost a month of work due to Microsoft settings.
Access 2019 - List Box.Requery event on Main Form causes Sub Form Current event to trigger
I have a simple Main Form with one SubForm. On the Main Form I have a ListBox called "listItems" whose RowSource is set to a Query. If I issue a listItems.Requery, the Current event of the SubForm is triggered. Why is this happening? And is it possible to prevent the SubForm current event from triggering?VBA: DoCmd.RunCommand acCmdCopy not working
I have a Rich Text Formatted Access field on a subform that I need to copy to the clipboard. Because Writeline doesn't have a FormattedText option, I can't simply write the field to the clipboard. Doing that copies it with the code and unformatted text. So instead, I'm trying to use DoCmd.RunCommand acCmdCopy Here's the code: 'set focus on subform Me![Case Attachments subform].SetFocus 'go to the last record on the subform DoCmd.GoToRecord , , acLast 'Copy the Field value DoCmd.RunCommand acCmdCopy The copy isn't working. The clipboard is empty. Interestingly, when I add a debug test right before the acCmdCopy: Dim tryit As String tryit = Me![Case Attachments subform].Form![Doc Description].Text MsgBox (tryit) it shows me that tryit equals the text I need to copy. I.e., I have the right field selected in its entirety. Anyone have any suggestions on how to get it to work or alternatives to copy the rich text to the clipboard so it can be paste correctly. (And, before you offer, NO, I don't want to write VBA code to jump over to Word, create a new file, paste it there, copy it, and delete the Word file).Appcrash Access / VBA
Hi, I am part of a development team that has an application written in access / vba (access runtime 2000) in production and without installing any updates on some machines, with the Windows 10/11 operating system, the program no longer starts. Searching the internet, we found this article: https://learn.microsoft.com/en-gb/DeployOffice/security/internet-macros-blocked#use-policies-to-manage-how-office-handles-macros Could the problem be related to this update? We tried following the guidelines to get it back up and running but couldn't fix it. Has anyone faced and solved any similar problem? Thanks for any help. --- Salve, faccio parte di un team di sviluppo che ha in produzione un'applicazione scritta in access / vba (access runtime 2000) e senza l'installazione di nessun aggiornamento su alcune macchine, con sistema operativo Windows 10/11, il programma non parte più. Eseguendo delle ricerche su internet abbiamo trovato questo articolo: https://learn.microsoft.com/en-gb/DeployOffice/security/internet-macros-blocked#use-policies-to-manage-how-office-handles-macros Il problema potrebbe essere collegato a questo aggiornamento? Abbiamo provato ad seguire le linee guida per ripristinare il funzionamento ma non siamo riusciti a risolvere. Qualcuno ha affrontato e risolto qualche problema simile? Grazie per un eventuale aiuto.
VBA Modules Access no longer available
Hi everyone, I have (maybe: i had) a file access with more VBA modules inside. The file is stored into a OneDrive's location. After a couple of moths I've opening the files to continue the programming activities and I've got a surprice. All modules are not longer available. I see it in the panel but whe I try to open it I've a message: The module name is wrong or it refers to a nonexistant module. I contacted Microsoft support and I discovered a huge truth: There was never support for Microsoft Access. Is there someone that had same problem and fixed it ?Error de infracciones de bloqueos
Buenos Días, Estoy desarrollando una base de datos nueva en la empresa y resulta que después de crear una consulta de actualización "UPDATE" que se ejecuta al pulsar un botón hay registros en los que me sale el siguiente error y otros en los que me lo actualiza directamente. Por desgracia no he conseguido en ningún sitio conseguir información relevante o que me ayude. Alguien puede saber que sucede...?? Uso la versión Access 2013
