Access Development

5 answers

MS ACCESS Report Design Detail Section

Hi Experts I am designing an invoice in MS Access. I need to make the height of detail section fixed so that the height remains same. Mainly i want the report footer to be positioned a little below. Currently if there is one row the detail section…

asked

MS-LovesAccess 101

commented

kalpesh italiya 0

0 answers

Change in VBA library for Excel.workbook?

I have an Access DB developed over several years in which there is a VBA module for exporting selected tables to a single, multi-worksheet Excel file. After a Windows update this morning, the VBA module fails with a compilation error over this code…

asked

Mike Surridge 0

commented

Mike Surridge 0

1 answer

I can't access my student/business account

I recently lost access to the device where I had Microsoft Authenticator installed and configured for my business account. With a new device in hand, I tried to configure this account again on this new device, and then the problems started. I can no…

asked

Eduardo S.Ferreira 0

commented

BANDELA Siri Chandana 325 Microsoft Vendor

1 answer

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…

asked

Philip Cox 5

edited a comment

Viorel 118.4K

3 answers

How do list results of a column in a table in one field separated by commas in MS Access

I would like to know how to get a column into a query field. Similar to how in Access if you use the multi-value field in MS Access. However, i do not wish to use the mutli-value. For example, if I had a table column1 with A C D F G (one…

asked

imodett 61

edited the question

Emi Zhang-MSFT 25,711 Microsoft Vendor

2 answers

Two finger scrolling not working in Access

Two-finger scrolling on a touchpad is not working on an Access form. It works OK in Excel, so it's not the computer or the mouse/touchpad drivers. It's also fine on the Navigation Pane in Access. If I open a table, it does scroll but is jerky and…

asked

john fallows 15

commented

SonofTheAlmighty 0

0 answers

Access to Word Document

Office 365. I have an Access report with one image (logo) and 4 subreports as a Print Preview. I need to save it as a Word .docx. Would it be best to just use the export to word command on the Print Preview tab or should I try to set it up as a merge…

asked

Maxine Nietz 1

2 answers

For MS Access Error Message: ODBC call failed. String or binary would be truncated #8152

Dear all, I have a MS Access DB Form (mask) and a "comments" field in the mask connects to a SQL Server db table field of 2500 length. I extended the length to 3000 char as per request and refreshed the connection, but the user still cannot…

asked

Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0

answered

Tom van Stiphout 1,696 MVP

3 answers

How do I fix the OLE Object in Access Error 3118?

Cannot join on Memo or OLE Object <name>. (Error 3118)

asked

April Kurtz 0

edited an answer

Ken Sheridan 2,841

1 answer

Sandbox environment to try MS-4010 Labs

Is Microsoft is providing any sandbox environment to try MS-4010 Labs?

asked

Gurjot Brar 20

commented

Gurjot Brar 20

4 answers

How do I close orphan database connections?

The last step in my Access application (before DoCmd.Quit) is to close the connection to the backend database on the network drive, as follows: This has always worked until one of the workstations was upgraded to Windows 11. Now when that workstation…

asked

DarrellDoesData 20

edited the question

Emi Zhang-MSFT 25,711 Microsoft Vendor

2 answers

Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?

Hello, within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...? Was given an Access DB and need to migrate and need to know if they are all simple straight forward stand alone Tables or if…

asked

techresearch7777777 1,881

commented

Emi Zhang-MSFT 25,711 Microsoft Vendor

0 answers

MS ACCESS 2021

/ functions in MS Access Filed properties in tables and most useful / important features

asked

Saleem2148 0

commented

Saleem2148 0

1 answer

Can anyone tell me what happened with sending emails from accessweth outlook (new)

I had a button on a form that I click and the invoice would show and clicked send and it would send it as a email through outlook as pdf. work this way for 15 years has not worked since tuesday.

asked

Bazza1 0

edited an answer

Karl Donaubauer 1,891 MVP

0 answers

Not able to access the account/subscription I was added to

I recently joined an organization. The account owner added me to the microsoft azure as an external user. I am able to login. Then they added the 'Global administrator' role against my user. They also added me under their microsoft azure subscription.…

asked

Avin 0

commented

Tom van Stiphout 1,696 MVP

1 answer

I clicked on Access policies on my ley vault, but i was shown this "Access policies not available". How do i make it available?

Access policies not available. The access configuration for this key vault is set to role-based access control. To add or manage your access policies, go to the Access control (IAM) page. How can I resolve this

asked

Charles Onyebuchi 20

accepted

Charles Onyebuchi 20

1 answer

no unique index found for the referenced field of the primary table

This error pops up during creation of relationships "no unique index found for the referenced field of the primary table"

asked

O'Donnell, Sharman@DIR 0

answered

Olaf Helper 45,126

2 answers

Access database locked

Access database locked as it is apparently opened by Admin on a single user computer. the message box says try again when the database is available. i have waited 24 hours to no avail

asked

RajuH 0

edited an answer

Karl Donaubauer 1,891 MVP

3 answers

MS Access version 2407 unable to connect to Salesforce via Linked Table Manager

Has anyone else experienced a problem connecting to Salesforce after updating to version 2407 (Build 17830.20138) Current Channel? Issue started happening last week (7/29/2024) to user where they get error ODBC--connection to '{{Salesforce}}' failed when…

asked

Brent Smiley 0

answered

Karl Donaubauer 1,891 MVP

1 answer

Enabling user authentication to connect Access front end to Azure SQL Database

I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…

asked

George Dimitrov 0

edited a comment

Oury Ba-MSFT 19,571 Microsoft Employee

Filter

Content

883 questions with Access Development tags

MS ACCESS Report Design Detail Section

Change in VBA library for Excel.workbook?

I can't access my student/business account

How to view .SNP file

How do list results of a column in a table in one field separated by commas in MS Access

Two finger scrolling not working in Access

Access to Word Document

For MS Access Error Message: ODBC call failed. String or binary would be truncated #8152

How do I fix the OLE Object in Access Error 3118?

Sandbox environment to try MS-4010 Labs

How do I close orphan database connections?

Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?

MS ACCESS 2021

Can anyone tell me what happened with sending emails from accessweth outlook (new)

Not able to access the account/subscription I was added to

I clicked on Access policies on my ley vault, but i was shown this "Access policies not available". How do i make it available?

no unique index found for the referenced field of the primary table

Access database locked

MS Access version 2407 unable to connect to Salesforce via Linked Table Manager

Enabling user authentication to connect Access front end to Azure SQL Database