976 questions

Sort by: Updated
4 answers

How can I translate the results of a dynamic query into a report?

I have a table in MS Access with Medical Lab results. There are 25 fields of results. I have a dynamic query that allows changing the field to display in a query and it is working properly. I want to build a report that will allow the different fields to…

Microsoft 365 and Office | Access | Development
asked 2026-10-30T20:51:31.98+00:00
Carol Davis 25 Reputation points
commented 2026-11-05T17:25:37.0733333+00:00
DBG 11,801 Reputation points Volunteer Moderator
1 answer

Access 2021 and Access 2024 now saving the same database as a Template with a Large File Size

Both Template Files are the very same database and were filled out in the exact same way and are saved as Template Files. I designed the Database. The small Template file size is 2.75MB Here is the link to the download on my Google Drive…

Microsoft 365 and Office | Access | Development
asked 2026-10-27T14:12:10.8666667+00:00
Joseph Holland 0 Reputation points
answered 2026-10-28T13:59:18.4433333+00:00
Joseph Holland 0 Reputation points
3 answers One of the answers was accepted by the question author.

Host an Access split database backend online

I code in VB and use a split Access db with the backend on the office server and the frontend on the various office workstations. Is it possible to place the Access db backend on an online server and have a version of the access frontends on mobile…

Microsoft 365 and Office | Access | Development
asked 2026-10-22T15:37:52.54+00:00
Jon Bullock 40 Reputation points
answered 2026-10-22T16:24:27.9766667+00:00
Heimerdinger 1,465 Reputation points Independent Advisor
2 answers

Can't Paste Multiple Objects in MS Access

Simple as that. Select multiple objects on an MS Access form, and either copy or cut them. They are not pastable. Not on the same form, and not on any form. This has been broken for AT LEAST a year now, as I found a report from 2025 citing the same…

Microsoft 365 and Office | Access | Development
asked 2026-08-17T18:14:04.8666667+00:00
David Mancini 6 Reputation points
edited a comment 2026-10-22T13:23:40.1933333+00:00
Ian Thompson 0 Reputation points
2 answers

help with environ("username") in access database

I can't get this to work hopefully there are answers already to this ?

Microsoft 365 and Office | Access | Development
asked 2026-09-26T23:15:19.0966667+00:00
James Speckmann 5 Reputation points
commented 2026-10-18T01:17:00.27+00:00
Daniel Pineault 631 Reputation points
1 answer

UseDefaultPrinter Setting For Access Forms No Longer Exposed in Design View?

I have inherited an Access database that is being used as a front-end. One of the users has reported a bug where a specific print function is not respecting the default printer set in Windows. Upon investigation, it looks like whomever made this part…

Microsoft 365 and Office | Access | Development
asked 2026-10-09T15:25:26.77+00:00
Robert S 0 Reputation points
commented 2026-10-14T18:25:54.63+00:00
Robert S 0 Reputation points
2 answers

I cannot see or select the tables when creating and ACCESS ODBC

I create the User ODBC But I cannot add the tables so when I connect to a datassource from crystal reports I cannot select tables or map indexed fields

Microsoft 365 and Office | Access | Development
asked 2026-09-14T15:35:21.52+00:00
Frank Valendo 0 Reputation points
edited an answer 2026-09-23T17:32:44.1266667+00:00
Don Varnau 19,945 Reputation points Volunteer Moderator
3 answers

Share data from 2 tables

Sorry new to access so if a basic question please forgive me i have 2 tables lead Activity They both have a common id number i want to be able to produce and lead that doesnt have a activity can anyone help thanks in anticipation

Microsoft 365 and Office | Access | Development
asked 2026-09-13T13:12:45.14+00:00
Mark Powell 0 Reputation points
commented 2026-09-14T07:58:44.9266667+00:00
Aetherin 3,680 Reputation points Independent Advisor
2 answers One of the answers was accepted by the question author.

Access 365: Control stacking order changes when using Tab key in form Design View (2309 and later)

Issue In Microsoft Access for Microsoft 365, in form Design View, when overlapping controls are selected, the stacking order (front/back display order) changes unexpectedly when using the Tab key to move the selection. Example Initial state (design…

Microsoft 365 and Office | Access | Development
asked 2026-06-11T09:37:07.5033333+00:00
tsuji 20 Reputation points
commented 2026-09-11T00:55:08.89+00:00
tsuji 20 Reputation points
2 answers

A bug that prevents Access Runtime 365 from being used on Windows 10.

Thank you for your continued support. Although the issue has now been resolved, starting on August 22, we encountered a problem where Access assets opened in Access Runtime 365 could not be opened. The affected device was running Windows 10. Since a…

Microsoft 365 and Office | Access | Development
asked 2026-08-25T02:05:13.2033333+00:00
test_account 0 Reputation points
edited an answer 2026-09-02T16:16:01.3466667+00:00
Karl Donaubauer 4,016 Reputation points MVP
4 answers

Microsoft Access Report – 3rd Page Prints at 1/4 Size Only When Printing Full Report

I'm having an unusual Microsoft Access printing issue at one of three locations. I have a report called rpt_Contract that includes two subreports, rpt_Legal1 and rpt_Legal2. The report prints as three pages. At one location only, when all three pages are…

Microsoft 365 and Office | Access | Development
asked 2026-08-17T19:48:30.6733333+00:00
Jazzy23 10 Reputation points
commented 2026-09-02T09:10:24.7866667+00:00
Denis Szücs 0 Reputation points
2 answers

How to allow access with vba forms and modules run on another laptop?

I built an Access database which is basically a frontend that uses forms with vba code and passthrough queries to connect to a SQL Server database. It works fine on the machine I built it on, but when I try to run it on my new laptop it hides a bunch of…

Microsoft 365 and Office | Access | Development
asked 2026-08-10T19:52:36.5433333+00:00
Dan Griswold 0 Reputation points
commented 2026-08-12T09:26:29.7033333+00:00
JeseminQH 1,130 Reputation points Independent Advisor
30 answers

Search for subform record based on text box

I am trying to bring up a form record based on text entered in a text box. The form "Furnace + Header Data Form" is a parent form, with 2 subforms called "Header Data Form" and "Surrogate Data Form". This question is in…

Microsoft 365 and Office | Access | Development
Developer technologies | Visual Basic for Applications
asked 2022-12-12T18:31:50.943+00:00
carmens 6 Reputation points
answered 2026-07-24T19:39:24.4133333+00:00
unshackled 0 Reputation points
1 answer

How can I prevent the code I write in Access SQL from being automatically reformatted into multiple lines?

Even if I write my SQL code on a single line in Access, it gets automatically reformatted into multiple lines when I run the query. How can I prevent this?

Microsoft 365 and Office | Access | Development
asked 2026-07-08T09:52:06.6633333+00:00
Mine Dayan 0 Reputation points
commented 2026-07-09T13:46:37.5133333+00:00
Michelle-N 20,745 Reputation points Microsoft External Staff Moderator
1 answer

In Access how to set criteria for show field content or not

In access: How to display a field's contents or the word "unavailable" based on another field with a yes/no structure. This is for a query that is being used for generating a report.

Microsoft 365 and Office | Access | Development
asked 2026-06-27T18:01:59.6733333+00:00
Anita Diamond 0 Reputation points
answered 2026-06-27T18:09:11.3033333+00:00
Duane Hookom 27,030 Reputation points Volunteer Moderator
2 answers

How to view .SNP file

I have a number of files in .SNP format, which originally could be opened with the Microsoft Snapshot Viewer which was part of Microsoft Access. I cannot find a safe version of that program to download. How can I view these .SNP files now or convert them…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | For business | Windows
asked 2024-11-02T12:44:18.7533333+00:00
Philip Cox 5 Reputation points
answered 2026-06-14T06:37:17.1233333+00:00
Gustav 767 Reputation points MVP
4 answers

VBA fails after recent Windows update...

I have this old MS-Access program (from 2002) where i use a matrix routine from Excel. It has worked until recently - but now fails on my Windows11-PC. I have an older bakup-PC with Windows10. They share the same OneDrive, and the program works on the…

Microsoft 365 and Office | Access | Development
asked 2026-06-10T15:55:38.2833333+00:00
Jake104E 40 Reputation points
commented 2026-06-11T22:14:37.9366667+00:00
Hin-V 16,830 Reputation points Microsoft External Staff Moderator
5 answers One of the answers was accepted by the question author.

Microsoft Access Conditional Formatting Color Palette Choices Reduced

Microsoft Access Conditional Formatting Color Palette Choices Reduced. I used to be able to choose from about 40ish colors, then the next menu to about 100 color, then to the custom palette. The 40ish color palette is now replaced with a simple 10…

Microsoft 365 and Office | Access | Development
asked 2026-04-25T00:43:26.2733333+00:00
Angela Marie 45 Reputation points
commented 2026-06-03T16:46:12.75+00:00
Angela Marie 45 Reputation points
3 answers

Append to Clipboard using MS Access VBA

I have a delimited string, ConstStr = "1356, 1360, 1366, 1368", and would like to add each value in the string to the clipboard so that, when executing a "Paste", all the values would fill individual cells,…

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:01:34.2066667+00:00
Doug 25 Reputation points
edited a comment 2026-05-21T14:10:07.3066667+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

Microsoft Forms 2.0 Object Library

The "Microsoft Forms 2.0 Object Library" is not found in my MS Access Reference drop down list. Where is it found?

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:53:53.5933333+00:00
Doug 25 Reputation points
accepted 2026-05-21T14:07:36.35+00:00
Doug 25 Reputation points