Forum Widgets
Latest Discussions
Access SQL Syntax Highlighting, Autocomplete, and Formatting
I just had Access (the newest version with Office 365) lose all syntax highlighting, autocomplete, and the formatting that had been allowed previously. It worked last night, and this morning it was all gone. The issue is on my Windows 10 desktop. It still highlights syntax and formats for readability on my Win 11 laptop. The only thing I can find between the two versions that is different is there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop. I would like to reiterate that it was fine last night on the desktop. I opened the same database this morning, and it was gone. I checked other databases, they all lack the highlighting and formatting on my desktop, but it is still there on my laptop. I attempted to update, repair, and reinstall office, and nothing changed. I am trying to determine what might have caused this, and if there is anything to do about it. The highlighting, autocomplete, and formatting are not a complete necessity, but they made working with the queries a lot easier for me, since I am a not particularly experienced with SQL.How do I reference query data from an Access Macro
I have a simple Select query that returns a number of records. In my Access macro (just for clarification, I do mean Access Macro and not VBA) I want to check how many records the query returns in an IF statement. In this specific case the check would be on zero returned records, but being able to check non-zero in the future might be useful. I have tried various internet searches but the only results I found relate to VBA. Suggestions on how to do this check would be appreciated. Thank You
Access Abfrage Schaltfläche Ausführen! deaktiviert
Seit Tagen ärgere ich mich in Access über den folgenden Sachverhalt: Ich habe eine DB erstellt. Ich habe eine Abfrage über den Abfrageentwurf erstellt. Dies funktioniert korrekt. Wenn ich jedoch im Abfrageentwurf die Schaltfläche "Ausführen!" betätigen will, ist diese deaktiviert. Microsoft Support ist nicht in der Lage oder Willens diesen defect zu beheben. Ich habe dieses Problem schon in der Tech Community aufgeschaltet, erhielt die verschiedensten Antworten. Ich erhielt den Rat im untenstehenden HKEY die Anpassung vorzunehmen. Schon der der Ordner Access Connectivity etc. fehlt auf meinem Rechner... HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office[Version]\Access Connectivity Engine\Engines\SandBoxMode
Troubleshooting Queries in Access
Hi All, I am trying to run a query in an Access database, the query is expected to populate an existing table with new data, however it is not running as expected. As per the set-up process, 1. Have deleted old tables (with previous data), and imported new data for these tables from a different Access database 2. Then I am doing a compact and repair. 3. Then I am running query that is expected to populate the table, I see no records are added to the table Could this be a file reference issue **or** lack of data **or** missing tables /steps **or** a connection within Access. Appreciate step by step process to diagnose the issue
Query failure in Windows 11
Hi I just had a new computer at work, and changed from windows 10 to windows 11. I have a query, which compare 2 tables, and add rows in table2 that dont exits in table1. This has been working for years, but now it, only sometimes, double all the rows. INSERT INTO MPS Columns from Table2 (Access linked to sharepoint) SELECT MPS2. Columns from table1 FROM MPS2 WHERE not exists (Select 1 from MPS WHERE MPS.[MPSid] = MPS2.[MPSid]); It compares a unik field MPSid It doubles the rows sometimes, and the MPSid is the same, in the doubled rows Has something changed, or is there a workaround? Best Regards TonyImpossible d'installer Windows 10 22h2
Bonjour, je n’arrive pas à mettre à jour Windows 10 vers la version 22H2. À chaque tentative, j’ai le message « Des problèmes se sont produits lors de l’installation de certaines mises à jour, mais nous réessaierons plus tard. » Mon PC a un processeur AMD Ryzen 7 1700, Windows 10 version 1909 installé sur SSD et aucun antivirus tiers actif. J’ai essayé le dépanneur Windows Update, redémarré le PC et vérifié la connexion Internet et l’espace disque, tout est OK. Je voudrais savoir comment forcer la mise à jour vers Windows 10 22H2 sans perdre mes fichiers ou s’il existe une autre méthode officielle via l’outil de mise à jour ou l’ISO. Merci pour votre aide.
Access Query Finding Old/Deleted Data
I have replaced several outdated tables in an Access database recently with updated versions. The issue that is now occurring is that my queries are pulling the old data that doesn't exist anymore in the table and creating duplicate entries in my output (one row with the updated data and one row with the deleted data). Does anyone know why this happens and what the fix is? The old data isn't in my table so I'm not sure how to surface it to remove it.
errore nel salvataggio di maschere ERRORE DEFINITO DELL'APPLICAZIONE O DALL'OGGETTO
Da qualche giorno, a seguito di aggiornamenti, non si riesce a creare maschere e report guidati con Access. Al momento del salvataggio della maschera, compare il messaggio ERRORE DEFINITO DELL'APPLICAZIONE O DALL'OGGETTO. Faccio presente che fino a 10 giorni fa funzionava tutto perfettamente. Ho anche provato a disinstallare e reinstallare il prodotto.
